tag:blogger.com,1999:blog-2131509019147385078.post1195773042585298536..comments2023-10-29T01:47:25.410-07:00Comments on PeopleSoft Journal: Creating excel file from PeopleSoftTonyhttp://www.blogger.com/profile/15957950620803247548noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-2131509019147385078.post-82928201213511785922013-04-16T03:11:02.998-07:002013-04-16T03:11:02.998-07:00Dorothea,
I think this is the simplest method of ...Dorothea,<br /><br />I think this is the simplest method of writing data to the cells. Are you looking for a method whereby the entire data of record to be copied to the cells with single statement? If that is the case then you need to create your own framework for it and use it. As of my best knowledge there is no framework delivered by Oracle to handle office applications.<br /><br />Regarding formatting the cells, you can do all the formats that you do with the excel in peoplecode. You can refer msdn library to get the properties or methods available for this COM object. The examples quoted in the Microsoft site may be another language; but yes you can use the properties and methods. Refer the below site as a start.<br /><br />http://msdn.microsoft.com/en-us/library/office/ff834673.aspx<br />Tonyhttp://www.peoplesoftjournal.blogspot.com/noreply@blogger.comtag:blogger.com,1999:blog-2131509019147385078.post-43982221694681152682013-04-10T13:42:59.411-07:002013-04-10T13:42:59.411-07:00Do you have an example of how to write data to the...Do you have an example of how to write data to the cells? I have the following but want to see if there's a more effcient way. <br />Also, where can I find more information on formating?<br /><br />&Rec = CreateRecord(Record.MYWRK);<br />&I = 15;<br />&SQL_Line = GetSQL(SQL.OUTSQL);<br />While &SQL_Line.Fetch(&Rec)<br /> &oWorkSheet.Cells(&I, 3).Value = &Rec.DATE_STR.Value;<br /> &oWorkSheet.Cells(&I, 4).Value = &Rec.TRANS_ID.Value;<br /> &oWorkSheet.Cells(&I, 5).Value = &Rec.AMT_STR.Value;<br />...<br /> &I = &I + 1;<br />End-While;Anonymoushttps://www.blogger.com/profile/02631332293768836846noreply@blogger.com