DLL

To export to an HTML file

1. If you have multiple sheets, set SSSetSheet first.
2. If you want to exclude part of the sheet, hide the appropriate columns or rows call the SSShowCol or SSShowRow functions and set the fShow parameter to FALSE.
3. If you do not want to display column or row headers, call the SSSetBool function and set the SSB_SHOWCOLHEADERS and SSB_SHOWROWHEADERS boolean to FALSE.
4. If you want to export the entire sheet or export several sheets into one HTML file, call the SSExportToHTML function and set the parameters as follows:
   1. Set the Col and Row parameters to –1.
   2. Set the lpszHtmlFile parameter to a valid path and file name.
      If you do not specify an extension, Spread will add .HTM.
   3. If one of the following statements is true, set the bAppendFlag parameter to 0 (False).
      • This is the only sheet you want to export.
      • This is the first function call for exporting multiple sheets into one HTML file.

        Note: The first time you call the SSExportToHTML function, you must set the bAppendFlag parameter to 0.

   4. If this is the second or later function call and you want to append data to an existing file, set the bAppendFlag parameter to 1 (True).
   5. Repeat steps 3.a–3.d until all data has been appended.
5. If you want to export a cell, column, rows, or blocks of cells, call the SSExportRangeToHTML function and set the parameters as follows:
   1. Set the Col, Row, Col2, and Row2 parameters to specify the cell, column, row, or block of cells.
      Using Column and Row Properties defines valid values for the Col and Row parameters.
   2. Set the lpszHtmlFile parameter to a valid path and file name.
      If you do not specify an extension, Spread will add .HTM.
   3. If one of the following statements is true, set the bAppendFlag parameter to 0 (False).
      • This is the only cell, column, row, or block of cells you want to export.
      • This is the first function call for a set of discontiguous data.

        Note: The first time you call the SSExportRangeToHTML function, you must set the bAppendFlag parameter to 0.

   4. If this is the second or later function call for a set of discontiguous data and you want to append data to an existing file, set the bAppendFlag parameter to 1 (True).
   5. Repeat steps 4.a–4.d until you have exported all the data you want.