Workbook tab groups

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
Tod
Posts: 1
Joined: Thu Apr 02, 2020 6:20 pm

Workbook tab groups

Post by Tod »

I do not see a way to alter or access workbook tab groups.

1. load a blank excel file that has one sheet
2. add a second sheet.
3. save it.
4. open the saved file in microsoft excel. You will see that both sheets are grouped.

I have tried using .selectedsheet. Has no effect on tab groups.

This behavior is not in FreeOffice. I have not tried LibreOffice yet.
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Workbook tab groups

Post by larsa »

Hello

This is fixed now. Use the property TabSelected to set if a tab is selected or not. Example: XLS[1].TabSelected := True;
Lars Arvidsson, Axolot Data
Post Reply