Hi Team,
Im using Light Cells Api to render an excel. I have got 2 worksheets and I need to set 2nd sheet to be focussed by default on opening the excel.
I would like to know where do I need to use the below 2 properties ?
this.workbook.getWorksheets().setActiveSheetIndex(1);
this.workbook.getSettings().setFirstVisibleTab(1);
Since Im using Light Cells Api, I just tried using this properties in nextRow() when it reaches the maxRow. But it does not seem to work.
Please let me know should use it after saving the workbook or before or at some other placeā¦
Advance thanks for the solution.
Thanks.