The setPrintArea function is established to set a sheet's printarea.
var excel = new Excel("test.xlsx");
excel.setPrintArea("mySheet",0,10,0,100);
Calling | Returning |
Excel . setPrintArea ( sheetName , startRow , endRow , startCol , endCol ) | Excel |
Parameters | Type | Description |
sheetName | String | The sheet name. |
startRow | Number | The start row of the range to be print. Indexed from 0. |
endRow | Number | The end row of the range to be print. Indexed from 0. |
startCol | Number | The start col of the range to be print. Indexed from 0. |
endCol | Number | The end col of the range to be print. Indexed from 0. |