how to create Excel workbook with separate tabs using PeopleSoft People code PSSpreadsheet object

Hi,

We are currently using PeopleSoft 9.2 with PeopleTools 8.58. Our business requirement is to generate an Excel workbook that contains multiple tabs, with each tab representing a different file. The Payroll interface produces three .csv output files, which I am converting into .xlsx format using PeopleCode. Additionally, I need to combine these three files into a single workbook with separate sheets for each file.

Could you please suggest the PeopleCode approach or sample code to accomplish this?

Below is the code i am using:

&ss.Open(&outFileName, True);
&file = GetFile(&csvFileName, "R", "A", %FilePath_Absolute);

If &file.IsOpen Then
While &file.ReadLine(&line)