Reading Excel in Application Engine
I am looking for examples on how to read an Excel document on a Unix based OS with Application Engine.
What is the best way to open, read and process data in Excel (XLS) with AE?
Thanks.
What is the best way to open, read and process data in Excel (XLS) with AE?
Thanks.
Tags: application, engine, excel, peoplesoft, unix
Replies to This Discussion
-
Permalink Reply by Andy Cheng on -
I think you should convert your Excel file to csv format.
-
Permalink Reply by John A. Bertels on
-
Agreed. A File Layout Definition should be used; presumably, you know which fields are in the file and the File Layout will parse the data into the fields properly.
Newsletters
Sign up for our FREE
PeopleSoft
Newsletter!
Latest Activity
Thank You Senthil. That makes sense.
There is a problem in the very first line. Variables &FileDirAndName and &Archive_Dir will not be resolved if its inside the double quotes. You have to do something like this:
&cmd = "cp " | &FileDirAndName " " | &Archive_Dir;
Also, your IF stat...
A group for PeopleSoft recruiters to communicate and work together to fill their open PeopleSoft positions
© 2009 Created by Derek Tomei
