ActiveX
To export to an Excel-formatted file
-
To export a book (BIFF8 format), call the ExportExcelBook method or the ExportExcelBookEx method, and set the parameters as follows:
-
Set the FileName parameter to the path and file name of the file you want to export.
If you do not specify an extension, Spread will add .XLS.
-
Set the LogFileName parameter to the path and file name of the log file that records the manner in which Spread handles the export of Excel features, including cell types and other settings.
If you do not want to generate a log file, set the LogFileName parameter to "".
- Set the flags parameter if you used the ExportExcelBookEx method.
-
Set the FileName parameter to the path and file name of the file you want to export.
- To export to an xlsx formatted-file, use the SaveExcel2007File method.
-
To export a sheet (BIFF8 format), call the ExportToExcel method or the ExportToExcelEx method, and set the parameters as follows:
-
Set the FileName parameter to the path and file name of the file you want to export.
If you do not specify an extension, Spread will add .XLS.
-
Set the SheetName parameter to specify the name of the sheet you are creating in the file.
If you do not specify a name in the parameter, Spread will name it "Sheet1".
-
Set the LogFileName parameter to the path and file name of the log file that records the manner in which Spread handles the export of Excel features, including cell types and other settings.
If you do not want to generate a log file, set the LogFileName parameter to "".
- Set the flags parameter if you used the ExportToExcelEx method.
-
Set the FileName parameter to the path and file name of the file you want to export.