PeopleSoft: Read / Update Excel / CSV Files


Read / Write CSV File in PeopleCode

In this post, we explain how to read / write CSV Files in PeopleSoft with working examples. You can stick this code into an Application Engine program and generate / parse CSV Files on the fly. You start with .....

Read Modify Excel Files in PeopleCode - Part 4

In our earlier posts, we saw how to read an Excel document inside a PeopleSoft application by using JExcel Java API. We wrote a Java wrapper class to return the Workbook object to PeopleSoft and then invoked relevant methods to read data from the worksheet /Cell. In this post, we will see how to create a new Excel document from PeopleSoft using JExcel. To set an objective for us, we will list ....

PeopleSoft Password Protect Excel WorkSheets

One common requirement for PeopleSoft applications is to generate an Excel document which is protected with a password. In our initial series of posts on JExcel, we saw how to integrate JExcel with PeopleSoft to generate, read and Modify Excel spreadsheets. In this post, we will see how to password protect an Excel document from PeopleSoft. We will produce an example that creates and Excel ....

Read Modify Excel Files in PeopleCode - Part 6

In Part 5 of this series, we modified the wrapper class method to include a method that returns a workbook object, which can be used to Modify a copy of the workbook. We also created a simple workbook ReadDocument.xls which we are aiming to modify by including the account lock status of users in Column B. In the concluding part of this series, we will present the PeopleCode snippet which modifies ....

Read Modify Excel Files in PeopleCode - Part 5

Ok, until this post we know how to create a new XLS document from PeopleSoft, write some contents into it and save it as a new workbook. We also know how to read an existing spreadsheet contents and do some processing in PeopleCode based on the values that are read.In the final part of this series, we will see how to modify existing Excel documents in PeopleSoft using JExcel API. To set an ....

Read Modify Excel Files in PeopleCode - Part 3

In our previous part of this post, we tried using reflection techniques to read data from an Excel document in PeopleCode. At the end of that post, we said we would explain the same approach by using a wrapper class in Java. We wrote lines and lines of code to get scope of the methods we need to invoke and finally ended up reading an Excel document. For all those Reflection enthusiasts, refer to ....

Read Modify Excel Files in PeopleCode - Part 2

We defined our objective in Part 1 of this series. In this post, we will explain how to read the Excel document ReadExcel.xls in PeopleCode. To start with, we will create a java object for jxl.workbook from PeopleCode. Local JavaObject &obj_readxls_l = GetJavaClass(jxl.Workbook).getWorkbook(CreateJavaObject(java.io.File, ReadExcelUsingJava.xls)); This will invoke the famous error again; ....

Read Modify Excel Files in PeopleCode - Part 1

Well, we know that PeopleSoft has the concept of File Layouts which helps you to create Excel documents. On top, if you are using the process scheduler on Windows, you can create Excel documents from PeopleSoft by using COM objects native to Microsoft. This post is for those, who are not very keen to use File Layouts due to its inflexibility (and neither have their process scheduler running on ....

No comments:

Post a Comment