Search Results for

    Show / Hide Table of Contents

    FlexCelHtmlExport.ExportAllVisibleSheetsAsOneHtmlFile Method

    Overloads

    • FlexCelHtmlExport.ExportAllVisibleSheetsAsOneHtmlFile(String, String, String, String)
    • FlexCelHtmlExport.ExportAllVisibleSheetsAsOneHtmlFile(TextWriter, String, String, String, String)

    FlexCelHtmlExport.ExportAllVisibleSheetsAsOneHtmlFile(String, String, String, String)

    Exports all visible sheets in an xls file one after the other in the same html file.

    Syntax

    Namespace: FlexCel.Render

    public void ExportAllVisibleSheetsAsOneHtmlFile(String htmlFileName, String relativeImagePath, String relativeCssFileName, String sheetSeparator)

    Parameters

    <-> Parameter Type Description
    htmlFileName String Path where the generated html file will be stored.
    relativeImagePath String Folder where images will be stored, relative to the path in htmlFileName.
    If for example htmlFileName is "c:\reports\html\test.htm" 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 file.
    relativeCssFileName String Name for the Css file, with a path relative to the htmlFileName Path.
    if you set it to null, no css file created and the css will be stored inside each HTML file.
    If for example htmlFileName is "c:\reports\test.htm" and relativeCssFileName is "css\data.css" the css file will be saved in "c:\reports\css\data.css"
    sheetSeparator String An HTML string to write between all the different sheets being exported. You can use for example <hr /> here to add a horizontal line. You can also use the special macros <#SheetName>, <#SheetCount>, <#SheetPos> <#PrevSheetName> and <#PrevSheetPos> here to enter the current sheet name, the number of sheets and the current sheet respectively. The macros are case insensitive, you can enter them in any combination of upper and lower case.

    See also

    • FlexCelHtmlExport

    FlexCelHtmlExport.ExportAllVisibleSheetsAsOneHtmlFile(TextWriter, String, String, String, String)

    Exports all visible sheets in an xls file one after the other in the same html stream.

    Syntax

    Namespace: FlexCel.Render

    public void ExportAllVisibleSheetsAsOneHtmlFile(TextWriter html, String htmlFileName, String relativeImagePath, String relativeCssFileName, String sheetSeparator)

    Parameters

    <-> Parameter Type Description
    html TextWriter Stream where the HTML file will be saved.
    htmlFileName String The filename itself won't be used (since the html file is saved to a stream), but it will tell the path where the generated extra files (for example images) will be stored, and also the way images are named.
    relativeImagePath String Folder where images will be stored, relative to the path in htmlFileName.
    If for example htmlFileName is "c:\reports\html\test.htm" 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 file.
    relativeCssFileName String Name for the Css file, with a path relative to the htmlFileName Path.
    if you set it to null, no css file created and the css will be stored inside each HTML file.
    If for example htmlFileName is "c:\reports\test.htm" and relativeCssFileName is "css\data.css" the css file will be saved in "c:\reports\css\data.css"
    sheetSeparator String An HTML string to write between all the different sheets being exported. You can use for example <hr /><p>Sheet <#SheetName></p> here to add a horizontal line. You can also use the special macros <#SheetName>, <#SheetCount> and <#SheetPos> here to enter the current sheet name, the number of sheets and the current sheet respectively. The macros are case insensitive, you can enter them in any combination of upper and lower case.

    See also

    • FlexCelHtmlExport
    In This Article
    Back to top FlexCel Studio for the .NET Framework v7.24.0.0
    © 2002 - 2025 tmssoftware.com