E-PC/E-nVision: PSSpreadsheet Class Method SetRowSetData Does not Bring the Rowset Data. (Doc ID 2612464.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

When using the PSSpreadsheet class to create Excel files, and using the method SetRowSetData to populate the sheet, the method fails to bring the rowset rows. Only 1 row is inserted and not all columns populated.

When the rowset does not have a date field, SetRowSetData works fine. However, if there is a date field in the rowset, SetRowSetData brings only the header and the 1st row of data. Even so, that 1st row of data does not contain everything. Only the columns before the Date field have data from the rowset. Remaining columns, including the Date field, are blank.

The issue can be reproduced at will with the following steps:
1. Write PeopleCode to generate an Excel file, trough the PSSpreadsheet class, using the SetRowSetData method.
2. Execute the code in PIA.
3. Note, in the resulting spread sheet, that only the header and 1 row were inserted. 

Cause

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