AM_FILL rev 71224
PL/SQL package: using the Microsoft XLSX files as templates for data output
Based on the code of packages designed by Anton Scheffer
https://technology.amis.nl/wp-content/uploads/2011/02/as_xlsx11.txt
https://technology.amis.nl/wp-content/uploads/2013/01/as_read_xlsx9.txt
Require AS_ZIP package designed by Anton Scheffer
Download from: http://technology.amis.nl/wp-content/uploads/2010/06/as_zip7.txt
Created and tested:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
XLSX: Google Docs, Excel Online (Cloud @mail.ru), LibreOffice 5.3.7.2
Notes:
- the package does not support formula values, so Google Docs preview will show empty cells
(recalculation of formulas is required);
- anсient versions LibreOffice have incompatibility with named ranges and formulas.
Whats new:
rev 71224
- refactored;
- named exception added;
- INIT: e option raising exception reasons changed;
- INIT: d, n options added;
- fully qualified sheet names support added;
- IN_TABLE: ref_cursor support added;
- formulas support added;
- insert mode: merged cells cutting changed;
- FINISH: shifts down and extends named ranges (insert mode);
- ADDRESS function changed;
- IN_SHEET: make visible/hidden the source sheet.
- NEW_WORKBOOK changed.
rev 70309