Generate New Excel format (XLSX) files using Oracle PLSQL [message #670578] |
Fri, 13 July 2018 15:09 |
|
nickz
Messages: 39 Registered: September 2013 Location: US
|
Member |
|
|
I would like your help to design a Oracle PLSQL code to export multiple tables from an Oracle DB schema to a pre-mapped Oracle directory EXPORT_FILES as one XLSX file.
- Program should generate one Excel workbook (Excel 2007+) in new format (.xlsx), as it can hold more number of rows, and is of significantly less size than older Excel format (XLS)
- Each table data will be in a separate worksheet
- Worksheet name should be the table name
- Do some regular formatting for each worksheet. Example - freeze header row, bold font header row, gray color header row, font Calibri size 9 etc.
- Have Header and Footer in all sheets for business purposes
- Good-to-Have feature: generate XLSX files, and ZIP it as well, all using PLSQL code. So that the final output is a ZIP file in the Oracle directory, thus saving a lot of space.
I saw a script here to generate Excel files and it's working, but the XLS files are much much larger since my table data is huge.
https://community.oracle.com/thread/2544010?start=0&tstart=0
I exported the same data using Oracle SQL Developer tool as XLSX files, and the size is much smaller. XLSX would be a much better option.
Thanks in advance
|
|
|
|
|
|