Spread 8.0 Documentation
DLL
Support Options

Glossary Item Box

DLL


To export to an Excel file

  1. Call the SSExportExcelBook function or the SSExportExcelBookEx function and set the parameters as follows (BIFF8 format):
    1. Set the lpszFileName 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 lpszLogFileName parameter to the path and file name of the log file that records the manner in which Spread handled the import or export of features, including cell types and other settings.
      If you do not want to generate a log file, set the LogFileName parameter to NULL.
    3. Set the flags parameter if you used the SSExportExcelBookEx function.
  2. Use the SSSaveExcel2007File function to export to an xlsx file.
  3. Call the SSExportToExcel function or the SSExportToExcelEx function and set the parameters as follows (BIFF8 format):
    1. Set the lpszFileName 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 lpszSheetName 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 lpszLogFileName parameter to the path and file name of the log file that records the manner in which Spread handled the import or export of features, including cell types and other settings.
      If you do not want to generate a log file, set the LogFileName parameter to NULL.
    4. Set the flags parameter if you used the SSExportToExcelEx function.
© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.