tag:blogger.com,1999:blog-20567072.post115372960024489295..comments2024-01-27T11:19:30.468+01:00Comments on Roels Blog: How to create neatly formatted Excel documents using PL/SQL?Anonymoushttp://www.blogger.com/profile/03932233704705635918noreply@blogger.comBlogger21125tag:blogger.com,1999:blog-20567072.post-42232707174987858792012-10-04T21:12:47.385+02:002012-10-04T21:12:47.385+02:00You can also try ORA_EXCEL package which can gener...You can also try ORA_EXCEL package which can generate formatted excel xlsx files from PL/SQQ, for more info please chech http://www.oraexcel.comAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-20567072.post-80935590363307663912011-09-28T15:18:14.953+02:002011-09-28T15:18:14.953+02:00I've searched all over the place, but haven...I've searched all over the place, but haven't been able to get this to work....<br /><br />I know this is an old post, does it still work though?Tim Wardhttps://www.blogger.com/profile/05630060400817813200noreply@blogger.comtag:blogger.com,1999:blog-20567072.post-56431121950971748482010-07-28T13:18:17.455+02:002010-07-28T13:18:17.455+02:00Excel files are very popular on my PC. Once I lost...Excel files are very popular on my PC. Once I lost all of them. I was upset, but I kept one's head and entered the Inet. I discovered there - <a href="http://www.recoverytoolbox.com/excel_unable_to_read_file.html" rel="nofollow">this file is not in a recognizable format Excel</a>, which restored whole excel files quite simply.Alexhttps://www.blogger.com/profile/02892788277177092618noreply@blogger.comtag:blogger.com,1999:blog-20567072.post-47053871099769662302010-05-19T17:12:41.805+02:002010-05-19T17:12:41.805+02:00Hey,
Check out this PL/SQL tool kit we started us...Hey,<br /><br />Check out this PL/SQL tool kit we started using. It let's the PL/SQL developer call a couple of procs to do this and more. It supports functions that our business folks in finance love. It's at http://www.peak42solutions.com. It has a weird name excellant.<br /><br />Thanks,<br /><br />BillAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-20567072.post-9318916702779072352010-01-11T09:01:17.549+01:002010-01-11T09:01:17.549+01:00Test.xls is getting created in the procedure. What...Test.xls is getting created in the procedure. What should be done if the excel file is already existing and formatted. Can i add some additional formatting for an existing formatted .xls file.Need help on this.TIAAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-20567072.post-20535994450992549422009-08-02T03:22:23.110+02:002009-08-02T03:22:23.110+02:00Some days ago I convert my excel file in other for...Some days ago I convert my excel file in other format and unfortunately it was damaged.In this situation friend said me about one nice tool-<a href="http://www.recoverytoolbox.com/how_can_i_view_xlsx_files_from_microsoft_excel.html" rel="nofollow">xlsx viewer</a>.As he said it helped to him and has free status.Moreover program helped me too and it can farther recovery of corrupted worksheets in xltm, xlsx, xlt, xls, xlsm, xlam and xltx formats.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-20567072.post-54365554524236127362009-07-02T05:19:00.011+02:002009-07-02T05:19:00.011+02:00Yesterday when I worked with excel files I saved i...Yesterday when I worked with excel files I saved it and went to bed,next morning I saw that my file corrupted,but in some hours to me came a friend,he advised me-<a href="http://www.recoverytoolbox.com/excel_file_repair.html" rel="nofollow">repairing Excel</a>,as he said this tool is reliable and has free status,it repairing Excel files, except the possibility to export recovered data into a new Microsoft Excel file,repairing Microsoft Excel files,will learn more about this problem and about how to repair an Excel file,contains the most features of registered program for repairing Excel files, except the possibility to export recovered data into a new Microsoft Excel file.Alexhttps://www.blogger.com/profile/02892788277177092618noreply@blogger.comtag:blogger.com,1999:blog-20567072.post-31670689104439108062009-02-25T11:44:00.000+01:002009-02-25T11:44:00.000+01:00how to reduce the table row hight and width in htp...how to reduce the table row hight and width in htp.tablerowkaparthihttps://www.blogger.com/profile/02377978305954778713noreply@blogger.comtag:blogger.com,1999:blog-20567072.post-43520152164648465832008-08-25T15:58:00.000+02:002008-08-25T15:58:00.000+02:00I tried this , it works fine but the rows and colu...I tried this , it works fine but the rows and columns outside the html table in the excel file have no formatting. Is there a solution to open the results as excel and still retain the formatting ?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-20567072.post-70871109518848018252008-05-08T06:48:00.000+02:002008-05-08T06:48:00.000+02:00can I run from sqlplus?can I run from sqlplus?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-20567072.post-22685302802544399912007-09-26T16:53:00.000+02:002007-09-26T16:53:00.000+02:00Take a look at http://radio.weblogs.com/0137094/20...Take a look at http://radio.weblogs.com/0137094/2006/10/26.html for information on ExcelDocumentType. That's a great solution for creating complex spreadsheets!Roelhttps://www.blogger.com/profile/07819238980013808276noreply@blogger.comtag:blogger.com,1999:blog-20567072.post-45862691267679366152007-09-25T11:45:00.000+02:002007-09-25T11:45:00.000+02:00Hi,if we can also create tabs in excel workbook. i...Hi,<BR/><BR/>if we can also create tabs in excel workbook. i mean more than two sheets in a excel workbook.Arun DIixthttps://www.blogger.com/profile/01303033853207212920noreply@blogger.comtag:blogger.com,1999:blog-20567072.post-11817558740244260382007-07-13T19:17:00.000+02:002007-07-13T19:17:00.000+02:00I have generated a package in pl/sql to generate e...I have generated a package in pl/sql to generate excel file. This basically creates Excel in xml format. Please find it here.<BR/>http://sanjeev-oracle-world.blogspot.comAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-20567072.post-72753707043396542742007-06-22T09:54:00.000+02:002007-06-22T09:54:00.000+02:00If you want to store the result on a file system o...If you want to store the result on a file system or in the database, you should use create a function (similar to the shown procedure) which uses htf-functions instead of the htp-procedures (use search-and-replace) and returning the total content (in a clob). The result can be saved to disk (using utl_file) or somewhere in the database.<BR/><BR/>HTH<BR/>RoelRoelhttps://www.blogger.com/profile/07819238980013808276noreply@blogger.comtag:blogger.com,1999:blog-20567072.post-90157381210268141012007-06-21T23:08:00.000+02:002007-06-21T23:08:00.000+02:00How could I run this as a standalone procedure??I ...How could I run this as a standalone procedure??<BR/><BR/>I see you have a internet explorer.<BR/>But I am using PL/SQL developer.<BR/><BR/>I am trying to find a way to create a excel sheet from Oracle and came across you article.<BR/><BR/>Thanks,Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-20567072.post-66713575275893602032007-06-08T09:33:00.000+02:002007-06-08T09:33:00.000+02:00I didn't test it, but I expect it to work from Exc...I didn't test it, but I expect it to work from Excel 2000 upwards, because there are no 'new features' used.Roelhttps://www.blogger.com/profile/07819238980013808276noreply@blogger.comtag:blogger.com,1999:blog-20567072.post-32291947071808922342007-06-07T11:25:00.000+02:002007-06-07T11:25:00.000+02:00hey roel, your above code is working on excel 2003...hey roel, your above code is working on excel 2003, but do you think above code is supported by excel 2000 forwards ?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-20567072.post-33560792012304707852007-03-28T08:21:00.000+02:002007-03-28T08:21:00.000+02:00The procedure shown in the blog is run from within...The procedure shown in the blog is run from within the browser (using a DAD - e.g. using XE). Then you will be prompted what to do with the tet.xls file. You can see some of the output in TOAD by using the owa_util.showpage procedure.Roelhttps://www.blogger.com/profile/07819238980013808276noreply@blogger.comtag:blogger.com,1999:blog-20567072.post-39627760195993716322007-03-27T22:26:00.000+02:002007-03-27T22:26:00.000+02:00I tried to execute it from TOAD.I tried to execute it from TOAD.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-20567072.post-41375138396933408452007-03-26T11:28:00.000+02:002007-03-26T11:28:00.000+02:00How and where did you start the procedure? From wi...How and where did you start the procedure? From within SQLPlus, TOAD or SQLDeveloper or from within your browser - assuming you have a webserver with a DAD installed?Roelhttps://www.blogger.com/profile/07819238980013808276noreply@blogger.comtag:blogger.com,1999:blog-20567072.post-33245777050751261302007-03-22T23:18:00.000+01:002007-03-22T23:18:00.000+01:00Roel,I tried executing you proc. It executed fine,...Roel,<BR/>I tried executing you proc. It executed fine, but I do not know where to retrieve the "test.xls" file from. I tried specifying a path such as "c:\test.xls", but it is not there. <BR/><BR/>Let me know<BR/>ThanksAnonymousnoreply@blogger.com