araczkowski / am_fill Goto Github PK

# 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