Set Active Sheet in Excel using Aspose Cells for JAVA

Aspose.Cells Product Family
1

Dear Warren,

Would it be possible to add a method to the Worksheets class that sets the active sheet? Currently I can only find getters for the active sheet.

Thanks and best regards,
Ulf Ekström

2

Hi Ulf,

Please try this fix.

3

Works great! Thanks.

4

Dear Warren,

One of our developers found a small issue with the setActiveSheet method. The tab of the previously active sheet is still highlighted. So it looks like two sheets are selected.

Thanks,
Ulf

5

Hi Ulf,

Please try this fix.

In this fix, setActiveSheet method will make other worksheets unselected.

We add Worksheet.setSelected() method to help user select some worksheets at the same time and add Worksheet.isActive() method.

6

Hi Ulf,

The attachement is docs.

7

Works great!