Working with Spreadsheet SDK
- Getting Started with Spreadsheet SDK
- Cell Class
- Document Members
- Document Constructor
- Document Properties
- Document.Close Method
- Document.Create Method
- Document.CreateWorksheet Method
- Document.DeleteWorksheet Method
- Document.Load Method
- Document.LoadAsync Method
- Document.Upload Method
- SpreadsheetSDK Class
- Style Class
- Worksheet Members
- Worksheet Constructor
- Worksheet Properties
- Worksheet Methods
Working via Protocol
- Getting Started with Protocol
Protocol API Reference
- Base URL for Sent Requests
- Work with Files
- Work with Documents
- Work with Worksheets
- Work with Cells
- Work with Rows and Columns
- WordPress Plugin
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"]
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.