UK Oracle User Group

Rowset to Excel

3 October 2015

Graham Smith shares a useful technique for exporting RowSet record data to Excel.

We all know that PeopleSoft grids can be exported to Excel using the button on the grid status bar.


But what if the data you want to export to Excel is not in a grid?  What if you need to programatically export data using PeopleCode.

I'm sure there are many ways to do this but I recently came across this useful technique for exporting RowSet record data to Excel.   Here's a working code sample.


The magic is in the use of the FormatResultString method from the Query class.  This accepts a rowset as input and will produce a string of HTML which when opened in Excel does just nicely.



Graham has added the code for people to copy from his blog posting.

Source: Graham's PeopleSoft Blog

We'd love to get your feedback on this; you'll need a UKOUG login to provide it, so if you don't have one, please click on 'create a web profile' first.

Send this page to your friend

Your details

Your friend's details


Please click the box below to indicate you are a human rather than an automated system completing this form.