My Oracle Support Banner

E-PC:PSSpreadsheet Open Method Fails When Invoked By App Designer. (Doc ID 2717268.1)

Last updated on OCTOBER 06, 2020

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.58 and later
Information in this document applies to any platform.


 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");
&"C:\temp\sample.xlsx", False);
Invoke the program from within App Designer and you get:
Sep 08, 2020 10:33:09 AM getWorkbookManager
INFO: Enter getWorkbookManager
Sep 08, 2020 10:33:10 AM getWorkbookManager
INFO: Exit getWorkbookManager
Sep 08, 2020 10:33:10 AM 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
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 
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC =




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

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