Spread 8.0 Documentation
ActiveX
Support Options

Glossary Item Box

ActiveX


To export to an Excel-formatted file

  1. To export a book (BIFF8 format), call the ExportExcelBook method or the ExportExcelBookEx method, and set the parameters as follows:
    1. 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.
    2. 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 "".
    3. Set the flags parameter if you used the ExportExcelBookEx method.
  2. To export to an xlsx formatted-file, use the SaveExcel2007File method.
  3. To export a sheet (BIFF8 format), call the ExportToExcel method or the ExportToExcelEx method, and set the parameters as follows:
    1. 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.
    2. 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".
    3. 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 "".
    4. Set the flags parameter if you used the ExportToExcelEx method.
© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.