set active worksheet

[Conisor]

Hello i'm kind of new here.

I've been searching for the past 2 days but i can't find how to set the main worksheet that should be active on file open.

I'm doing some worksheet duplication in .net.

Is there a way to select the current active worksheet. Or to force the first sheet to be the active one?

I am asking this as when the worksheets get duplicated they all scroll to the right, thus when you open the file you have to scroll all the way to the left to see any

Pictures for clarity

[Betsy.jiang]

Dear Conisor,

Sorry for late reply as weekend.
Spire.XLS supports that, please refer to code below.

Code: Select all

            workbook.Worksheets[1].Activate();
            //workbook.Worksheets["SheetName"].Activate();

If there is any question, please free free to contact us.

Thanks,
Betsy
E-iceblue support team

[Conisor]

Thank you so much

That worked like a charm.

[Betsy.jiang]

Dear Conisor,

Thanks for your feedback.
Please feel free to contact us if you have any question.

Sincerely,
Betsy
E-iceblue support team

[realrxen]

Hello,

I met the similar problem today, the activated sheet was the last sheet in generated xlsx.file, you know, the 'Evaluation Warning sheet'

And then, I used this code refered in the website ,

Code: Select all

# workbook.Worksheets["Table Catalog"].Activate();

It does not works.

Could you tell me the reason for that?

related version:
Python 3.7
Spire.XLS-14.2.2 (not inclued license)
plum-dispatch-1.7.4

[realrxen]

Dear Conisor,

Thanks for your feedback.
Please feel free to contact us if you have any question.

Sincerely,
Betsy
E-iceblue support team

Hello,

I met the similar problem today, the activated sheet was the last sheet in generated xlsx.file, you know, the 'Evaluation Warning sheet'

And then, I used this code refered in the website ,

CODE: SELECT ALL
# workbook.Worksheets["Table Catalog"].Activate();



It does not works.

Could you tell me the reason for that?

related version:
Python 3.7
Spire.XLS-14.2.2 (not inclued license)
plum-dispatch-1.7.4

[Abel.He]

Hi,

Thanks for your inquiry.
The reason of your issue is that the avtive sheet will be set to the last sheet (Evaluation Warning sheet) if you don’t apply license when using commercial version of Spire.Xls.
For new user, we will to provide a month temporary license to help you remove warning message and limitations. If you need it, you can contact our sales team via email(sales@e-iceblue.com).

Sincerely
Abel
E-iceblue support team