FlexCelHtmlExport.ExportAllVisibleSheetsAsTabs Method
Overloads
- FlexCelHtmlExport.ExportAllVisibleSheetsAsTabs(String, String, String, String, String, TSheetSelector)
- FlexCelHtmlExport.ExportAllVisibleSheetsAsTabs(String, String, String, String, String, TSheetSelector, OnSheetNameEventHandler)
FlexCelHtmlExport.ExportAllVisibleSheetsAsTabs(String, String, String, String, String, TSheetSelector)
This method will export all the visible sheets on an xls file to an html file, writing each sheet in a different file. This is equivalent to calling Export on every sheet.
Syntax
Namespace: FlexCel.Render
public void ExportAllVisibleSheetsAsTabs(String htmlPath, String htmlFileNamePrefix, String htmlFileNamePostfix, String relativeImagePath, String relativeCssFileName, TSheetSelector sheetSelector)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
htmlPath | String | Path where html files will be stored. (one per sheet in the workbook) | |
htmlFileNamePrefix | String | This is a string that will be added to every file generated, at the beggining of the filename. For example, if htlmFileNamePrefix = "test_" and htmlFileNamePostfix = ".html", "sheet1" will be exported as "test_sheet1.html". If generating a single file (MHTML format), htmlFileNamePrefix + htmlFileNamePostFix will be used, without a sheet name. Note that you can change the sheetname to some other string in the OnSheetName event, so the final name will be htmlFileNamePrefix + "string returned in OnSheetName" + htmlFileNamePostfix. |
|
htmlFileNamePostfix | String | This is a string that will be added to every file generated, at the end of the filename. Make sure you include the extension here. For example, if htlmFileNamePrefix = "test_" and htmlFileNamePostfix = ".html", "sheet1" will be exported as "test_sheet1.html" If generating a single file (MHTML format), htmlFileNamePrefix + htmlFileNamePostFix will be used, without a sheet name. |
|
relativeImagePath | String | Folder where images will be stored, relative to the htmlPath. If for example htmlPath is "c:\reports\html" and relativeImagePath is "images", images will be saved in folder "c:\reports\html\images". If this parameter is null or empty, images will be saved in the same folder as the html files. |
|
relativeCssFileName | String | Name for the Css file, with a path relative to the htmlPath. Note that the css will be shared among all sheets, so only one file will be created. if you set it to null, no css file created and the css will be stored inside each HTML file. It is recommended that you provide an extenal name here, so the CSS is shared webpages are smaller. If for example htmlpath is "c:\reports" and relativeCssFileName is "css\data.css" the css file will be saved in "c:\reports\css\data.css" |
|
sheetSelector | TSheetSelector | Information about how to draw the tabs that will allow you to switch between the sheets. Set it to null if you do not want to include a sheet selector. |
See also
FlexCelHtmlExport.ExportAllVisibleSheetsAsTabs(String, String, String, String, String, TSheetSelector, OnSheetNameEventHandler)
This method will export all the visible sheets on an xls file to an html file, writing each sheet in a different file. This is equivalent to calling Export on every sheet.
Syntax
Namespace: FlexCel.Render
public void ExportAllVisibleSheetsAsTabs(String htmlPath, String htmlFileNamePrefix, String htmlFileNamePostfix, String relativeImagePath, String relativeCssFileName, TSheetSelector sheetSelector, OnSheetNameEventHandler OnSheetName)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
htmlPath | String | Path where html files will be stored. (one per sheet in the workbook) | |
htmlFileNamePrefix | String | This is a string that will be added to every file generated, at the beggining of the filename. For example, if htlmFileNamePrefix = "test_" and htmlFileNamePostfix = ".html", "sheet1" will be exported as "test_sheet1.html". If generating a single file (MHTML format), htmlFileNamePrefix + htmlFileNamePostFix will be used, without a sheet name. Note that you can change the sheetname to some other string in the OnSheetName event, so the final name will be htmlFileNamePrefix + "string returned in OnSheetName" + htmlFileNamePostfix. |
|
htmlFileNamePostfix | String | This is a string that will be added to every file generated, at the end of the filename. Make sure you include the extension here. For example, if htlmFileNamePrefix = "test_" and htmlFileNamePostfix = ".html", "sheet1" will be exported as "test_sheet1.html" If generating a single file (MHTML format), htmlFileNamePrefix + htmlFileNamePostFix will be used, without a sheet name. |
|
relativeImagePath | String | Folder where images will be stored, relative to the htmlPath. If for example htmlPath is "c:\reports\html" and relativeImagePath is "images", images will be saved in folder "c:\reports\html\images". If this parameter is null or empty, images will be saved in the same folder as the html files. |
|
relativeCssFileName | String | Name for the Css file, with a path relative to the htmlPath. Note that the css will be shared among all sheets, so only one file will be created. if you set it to null, no css file created and the css will be stored inside each HTML file. It is recommended that you provide an extenal name here, so the CSS is shared webpages are smaller. If for example htmlpath is "c:\reports" and relativeCssFileName is "css\data.css" the css file will be saved in "c:\reports\css\data.css" |
|
sheetSelector | TSheetSelector | Information about how to draw the tabs that will allow you to switch between the sheets. Set it to null if you do not want to include a sheet selector. |
|
OnSheetName | OnSheetNameEventHandler | Use this event to customize the filename for the created files, and use something different than the sheet name. |