|
DOCUMENTS 5 - PortalScripting API
|
|
DOCUMENTS 5 - PortalScripting API
|
This is the complete list of members for XLSXWorksheet, including all inherited members.
| addAutofilter(number firstRow, number firstCol, number lastRow, number lastCol) | XLSXWorksheet | |
| freezePanes(number row, number col) | XLSXWorksheet | |
| getLastError() | XLSXWorksheet | |
| importFromJSON(String jsonString, number row=0, number col=0) | XLSXWorksheet | |
| importFromJSONFile(String jsonFilePath, number row=0, number col=0) | XLSXWorksheet | |
| insertChart(number row, number col, XLSXChart chart, number xOffset=0, number yOffset=0, number xScale=1, number yScale=1) | XLSXWorksheet | |
| insertImage(number row, number col, String filename, number xOffset=0, number yOffset=0, number xScale=1, number yScale=1) | XLSXWorksheet | |
| mergeRange(number firstRow, number firstCol, number lastRow, number lastCol, String value, XLSXFormat format=null) | XLSXWorksheet | |
| setColumn(number firstCol, number lastCol, number width=8.43, XLSXFormat format=null, boolean hidden=false, number level=0, boolean collapsed=false) | XLSXWorksheet | |
| setFirstSheet() | XLSXWorksheet | |
| setFooter(String footer, number margin=0.3) | XLSXWorksheet | |
| setGridlines(string option) | XLSXWorksheet | |
| setHeader(String header, number margin=0.3) | XLSXWorksheet | |
| setHorizontalPagebreaks(number[] breaks) | XLSXWorksheet | |
| setLandscape() | XLSXWorksheet | |
| setMargins(number left=-1, number right=-1, number top=-1, number bottom=-1) | XLSXWorksheet | |
| setPageView() | XLSXWorksheet | |
| setPaperType(number type=0) | XLSXWorksheet | |
| setPortrait() | XLSXWorksheet | |
| setRow(number row, number height=15, XLSXFormat format=null, boolean hidden=false, number level=0, boolean collapsed=false) | XLSXWorksheet | |
| setTabColor(number color) | XLSXWorksheet | |
| setVerticalPagebreaks(number[] breaks) | XLSXWorksheet | |
| setZoom(number scale=100) | XLSXWorksheet | |
| splitPanes(number vertical, number horizontal) | XLSXWorksheet | |
| writeBlank(number row, number col, XLSXFormat format=null) | XLSXWorksheet | |
| writeBoolean(number row, number col, boolean value, XLSXFormat format=null) | XLSXWorksheet | |
| writeCell(String type, number row, number col, var value, XLSXFormat format=null) | XLSXWorksheet | |
| writeDatetime(number row, number col, Date value, XLSXFormat format=null) | XLSXWorksheet | |
| writeFormula(number row, number col, String value, XLSXFormat format=null) | XLSXWorksheet | |
| writeLink(number row, number col, String value, XLSXFormat format=null) | XLSXWorksheet | |
| writeNumber(number row, number col, number value, XLSXFormat format=null) | XLSXWorksheet | |
| writeRichString(number row, number col, String value, XLSXFormat format=null) | XLSXWorksheet | |
| writeString(number row, number col, String value, XLSXFormat format=null) | XLSXWorksheet |