|
|
|
|
SpreadsheetClose (Function) In french: TableurFerme SpreadsheetLoad(PSHEET_Spreadsheet, "doc1.XLS") SpreadsheetClose(PSHEET_Spreadsheet) ShellExecute("doc1.xlsx") Syntax
SpreadsheetClose(<Spreadsheet control>)
<Spreadsheet control>: Control name Name of the Spreadsheet control to be used. Remarks - By default, SpreadsheetLoad leaves the XLSX file open in write mode. When the document is saved, only the cells that have been changed in the Spreadsheet control are overwritten..
- To open the ".xlxs" file with another application, it must be closed with SpreadsheetClose.
- If no ".xlsx" file was opened, SpreadsheetClose has no action.
- This function can only be used on a Spreadsheet control found in a window.
Related Examples:
|
Unit examples (WINDEV): The Spreadsheet control
[ + ] Using the Spreadsheet control. This example explains how to: - load an xlsx file in a spreadsheet control, - save the spreadsheet in a file, - fill the control with data coming from the database, - insert rows, columns, - access the cells and handle them (modify their value, their style, ...), - enter formulas, - ...
|
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|