EXPORT TO XLSX-FILE

Package:as_xlsx

常用procedure及function：
—————————-清空———————————–
as_xlsx.clear_workbook;

————————-创建新sheet———————————–
as_xlsx.new_sheet(p_sheetname varchar2 := null);

————————-填充单元格———————————–
as_xlsx.cell(p_col pls_integer,
p_row pls_integer,
p_value date/number/varchar2,
p_numFmtId pls_integer := null,
p_fontId pls_integer := null,
p_fillId pls_integer := null,
p_borderId pls_integer := null,
p_alignment tp_alignment := null,
p_sheet pls_integer := null);

————————-合并单元格———————————–
as_xlsx.mergecells(p_tl_col pls_integer – top left
,
p_tl_row pls_integer,
p_br_col pls_integer – bottom right
,
p_br_row pls_integer,
p_sheet pls_integer := null);

—————————-xml———————————–
function finish return blob;

————————-保存到逻辑目录———————————-
procedure save(p_directory varchar2, p_filename varchar2);

————————-sql语句创建file———————————–
procedure query2sheet(p_sql varchar2,
p_column_headers boolean := true,
p_directory varchar2 := null,
p_filename varchar2 := null,
p_sheet pls_integer := null);