E-PC: PSSpreadsheet Class Methods SetSheetActivate and SetActiveSheetName Not Working as Expected (Doc ID 3052348.1)

Last updated on OCTOBER 10, 2024

Applies to:

Symptoms

When using an application engine to generate an excel file with lets say 2 worksheets in it, using the PSSpreadsheet class, an excel file was successfully created.

However, the code written is not able to write data on the second worksheet.

The data intended for the second worksheet is getting written in the first worksheet, even the SetSheetActivate method was used to activate the second worksheet, way before writing the data via SetCellString method.

Bellow code was used to set the pointer and activate the second worksheet

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.