t_row_ind := workbook.sheets( s ).rows.first() We have had the same performance issues, we solved it by changing the following Īdd1xml( t_excel, ‘xl/theme/theme1.xml’, t_xxx ) P.S.11 version 20, but important change: changed to date1904=false P.S.8 Fixed set_autofilter (only one autofilter per sheet, added _xlnm._FilterDatabase) P.S.4 Fixed issue with XML-escaping from text P.S.3 Fixed issue with timezones with a regionname I have added the possibility to add Comments and MergedCells to the Excel-file Excel itself is a far better tool for such things. The main purpose for this package is getting data from the database into an Excel file, so I deliberate did not include some Excel functionality, such as formulas, into the package. With this package it’s very easy to create an Excel 2007 file with only a few lines of PL/SQL code.Īs_xlsx.query2sheet( 'select * from dual' ) For this project I took an Apex-plugin I have written, (IR) Report to Excel (xlsx), and turned it into a PL/SQL package.
0 Comments
Leave a Reply. |