tag:blogger.com,1999:blog-2813822908483947681.post7859025805790363590..comments2024-02-08T13:45:58.449+00:00Comments on Graham's PeopleSoft Blog: Rowset to Excel - PeopleCode Friday #2Grahamhttp://www.blogger.com/profile/09150581893711693248noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-2813822908483947681.post-50936143241267680382022-03-27T18:11:13.037+01:002022-03-27T18:11:13.037+01:00Is there anyway to change the report lables dynami...Is there anyway to change the report lables dynamically using formatresultstring ?Tilakhttps://www.blogger.com/profile/12719335351123095270noreply@blogger.comtag:blogger.com,1999:blog-2813822908483947681.post-29908799026645724302022-03-27T18:08:39.452+01:002022-03-27T18:08:39.452+01:00This comment has been removed by the author.Tilakhttps://www.blogger.com/profile/12719335351123095270noreply@blogger.comtag:blogger.com,1999:blog-2813822908483947681.post-51626565571835243122019-06-17T20:51:01.189+01:002019-06-17T20:51:01.189+01:00Hey Jim! Somewhat related/adjacent to this post,...Hey Jim! Somewhat related/adjacent to this post, do you know of a way to default the filename when clicking on the delivered download to excel icon on a grid. The default is ps.xls. I see that there is a save as option but I'm curious if it's possible to default to another name? Thanks for all the posts! TedMusicForCubsFanshttps://www.blogger.com/profile/05999935563741717505noreply@blogger.comtag:blogger.com,1999:blog-2813822908483947681.post-8058692109480821042018-04-22T08:08:07.920+01:002018-04-22T08:08:07.920+01:00@link, yes, but it is a bit of a challenge from Pe...@link, yes, but it is a bit of a challenge from PeopleCode. You can see an example at http://jjmpsj.blogspot.com/2016/07/dynamic-java-in-peoplecode.htmlJim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-2813822908483947681.post-65032526902330076912018-02-02T13:17:06.167+00:002018-02-02T13:17:06.167+00:00@Graham. Thanks for sharing this. It was helped me...@Graham. Thanks for sharing this. It was helped me lot for one of my development.<br /><br />@Jim. Have you created spreadsheet using Apache POI.linkhttps://www.blogger.com/profile/16872725397986258869noreply@blogger.comtag:blogger.com,1999:blog-2813822908483947681.post-14152823096812536952015-10-09T18:38:55.189+01:002015-10-09T18:38:55.189+01:00I will be sharing another alternative during my Op...I will be sharing another alternative during my OpenWorld session: Using <a href="https://poi.apache.org/" rel="nofollow">Apache POI</a>, which is delivered in 8.54. POI is a bit complicated for creating simple spreadsheets, but highly valuable for complex worksheet creation (calculations, formatting, etc). My primary motivation for using POI is to read and process spreadsheets.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-2813822908483947681.post-1634741544186181632015-10-07T12:45:29.628+01:002015-10-07T12:45:29.628+01:00@Kevin. Thanks. I like what you're doing wit...@Kevin. Thanks. I like what you're doing with the Query API and related content framework. Thanks for sharing.<br /><br />I tried using FormatBinaryResultsString method in my example but the Excel document just contains the word "False". Switching the file write to use WriteRaw method resulted in the application server crashing. Investigating......<br /><br />Thanks again Kevin.<br />Graham<br /><br />Grahamhttps://www.blogger.com/profile/09150581893711693248noreply@blogger.comtag:blogger.com,1999:blog-2813822908483947681.post-34255469248955756722015-10-04T16:59:54.575+01:002015-10-04T16:59:54.575+01:00Very interesting post! I did not know that the Qu...Very interesting post! I did not know that the Query API would accept any rowset, very cool. I had written my own rowset to excel function using David Vandiver's SQR2XLS iScript function as my foundation. I also incorporated my own stlyes that I associate to the column by field type. So I can format the currency and dates. Here is my blog post on how to stream the excel in binary. <br /><br />http://pskcw.blogspot.com/2015/05/using-query-api-to-generate-xls.html<br /><br />We are using this in combination with my own Rowset to cells function that can be found on my blog as well in Related Content and Actions to deliver reports directly to the end user without customization.<br /><br />Thanks for sharing!<br />Kevin Weaverhttps://www.blogger.com/profile/09237087594753403371noreply@blogger.com