E-PC:PSSpreadsheet Open Method Fails When Invoked By App Designer.
(Doc ID 2717268.1)
Last updated on APRIL 04, 2025
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.58 and laterInformation in this document applies to any platform.
Symptoms
Attempting to build an Excel workbook using the PSSpreadsheet object fails if code is placed in App Engine and invoked from within App Designer.
Insert the following code:
Local object &ssObject;
Local any &success;
&ssObject = CreateObject("PSSpreadsheet");
&ssObject.open("C:\temp\sample.xlsx", False);
&ssObject.SetActiveSheetName("Sample");
&ssObject.Save();
Invoke the program from within App Designer and you get:
Sep 08, 2020 10:33:09 AM com.peoplesoft.pt.psspreadsheet.WorkbookManager getWorkbookManager
INFO: Enter getWorkbookManager
Sep 08, 2020 10:33:10 AM com.peoplesoft.pt.psspreadsheet.WorkbookManager getWorkbookManager
INFO: Exit getWorkbookManager
Sep 08, 2020 10:33:10 AM com.peoplesoft.pt.psspreadsheet.WorkbookManager openWorkbook
INFO: Enter openWorkbook
PeopleTools 8.58.05 - Application Engine
Copyright (c) 1988-2020 Oracle and/or its affiliates.
All Rights Reserved
java.lang.NoClassDefFoundError: org/apache/poi/openxml4j/exceptions/InvalidFormatException
com.peoplesoft.pt.psspreadsheet.WorkbookManager.openWorkbook(WorkbookManager.java:207)
Could not create/open workbook for (Open). (28,251) CH_SS_SMPL.MAIN.GBL.default.1900-01-
01.Step01.OnExecute PCPC:187 Statement:2
Message Set Number: 28
Message Number: 251
Message Reason: Could not create/open workbook for (%1). (28,251)
Process 7070887 ABENDED at Step CH_SS_SMPL.MAIN.Step01 (PeopleCode) -- RC = 8 (108,524)
Message Set Number: 108
Message Number: 524
Message Reason: Process 7070887 ABENDED at Step CH_SS_SMPL.MAIN.Step01 (PeopleCode) -- RC = 8
(108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC =
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |