FlexCelHtmlExport.ExportAllVisibleSheetsAsTabs Method

Overloads

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 OnSheetNameEvent​Handler Use this event to customize the filename for the created files, and use something different than the sheet name.

See also