GetHTMLRange

The GetHTMLRange command allows you to export a worksheet's part to a web page and get this page’s HTML code. To use this command in your post, you can use short code similar to the one below.

[sclapi command="GetHTMLRange" filename="MyTestApplication.xlsx" sheetindex=0 range="A1:E5" exportgridlines="true"]

Command Parameters

  • filename - a string value that specifies the required document's file name along with the extension.

  • sheetname - a string value that specifies the worksheet name.

    - or -

    sheetindex - a zero-based index of the worksheet.

  • range - a string value that specifies a cell range from which cells are exported. For example, range=”A1:B2”.

    - or -

    startrowindex - a zero-based index of the first row starting from which cells are exported.

    endrowindex - a zero-based index of the last row that limits the exported cell area.

    startcolumnindex - a zero-based index of the first column starting from which cells are exported.

    endcolumnindex - a zero-based index of the last column that limits the exported cell area.


    If none of the parameters above are specified, a used range of a worksheet is taken into account.

  • exportgridlines - a boolean value. True to export cell gridlines; otherwise, false. The default value is false.