PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

PSSpreadsheet Class

edited Apr 18, 2019 12:28PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 12 commentsAnswered

Hi,

i´m using the new PSSpreadsheet Class API (Tools 8.55). Works fine with some classes but others throw me out of the session (like a time-out but just about a few seconds).

This is part of the code i´m using:

Local string &outFileName = "some name";

&ss = CreateObject("PSSpreadsheet");

&ss.Open(&outFileName, True);

...

(create and fill a rowset named &rsx)

...

&ss.SetRowSetData(&rsx);    this line works fine! Fill my excel file with my rowset, in sheet "1" (a default active sheet when workbook created)

&ss.CreateSheet("3");            this line works fine too. It creates sheet "3" on my excel workbook

&ss.SetSheetActivate("3");     this line DOESN´T work. No error message shown,...just logs me out of my session.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center