How to setFirstVisibleTab on using Light Cells Api JAVA

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.

@Thilakbabu,

Considering the nature of Light Cells APIs, you can perform worksheet activation or relevant tasks outside of the implementation of the light cells APIs. For example, you may place such code lines before saving the file.