E-PC: Errors While Reading Data From Excel file - "OLE Automation error in Workbooks.Open: ObjectDoMethod: Microsoft Excel access the file" (Doc ID 3076685.1)

Last updated on MARCH 12, 2025

Applies to:

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

Symptoms

PeopleSoft Application is throwing random errors while reading the input excel (.xlsx) file using application engine. A custom program has been developed to read the input excel file and write fixed length text file. When executed the program via Application Designer i.e. 2-tier, it ran successfully.

After registering through PIA, AE program failed due to the below error when executed through process scheduler.

OLE Automation error in Workbooks.Open: ObjectDoMethod: Microsoft Excel cannot access the file '<D:\<filepath>\..\..\Filename.xlsx'.
There are several possible reasons: • The file name or path does not exist • The file is being used by another program. • The workbook you are trying to save has the same name as a currently open workbook.. (180,161) <Custom>.MAIN.GBL.default 1900-01- 01.Step01.0nExecute PCPC:2459 Statement 19

Other random errors were generated as well.

1. 'Excel.Application' does not support property or method 'Worksheets'. (180,160) <custom_component>.MAIN.GBL.default.1900-01-01.Step01.OnExecute PCPC:2443 Statement:19
2. 'Range' does not support property or method 'Value'. (180,160) <custom_component>.default.1900-01-01.Step01.OnExecute PCPC:4532 Statement:39
3. OLE Automation error in Excel.Application.Worksheets: ObjectDoMethod: Unknown error 80010001. (180,161) <custom>.MAIN.GBL.default.1900-01-01.Step01.OnExecute PCPC:2443 Statement:19
4. OLE Automation error in Range.Value: ObjectGetProperty: Unknown error 80010001. (180,161) <custom_component>.MAIN.GBL.default.1900-01-01.Step01.OnExecute PCPC:4436 Statement:38
5. OLE Automation error in Excel.Application.Quit: ObjectDoMethod: Unknown error 80010001. (180,161) <custom_component>.MAIN.GBL.default.1900-01-01.Step01.OnExecute PCPC:9483 Statement:98
6. 'Object' does not support property or method 'Value'. (180,160) <custom_component>.MAIN.GBL.default.1900-01-01.Step01.OnExecute PCPC:4532 Statement:39

The issue can be reproduced at will with the following steps:

1. Develop a custom code to read data from excel file.

2. Run the AE program via process scheduler.