function get_worksheets_list

function get_worksheets_list(
    p_xlsx in blob
) return t_xlsx_sheet_properties

get list of xlsx worksheets

function get_docx_properties

function get_docx_properties(
    p_docx in blob
) return t_docx_properties

get docx properties

function get_docx_plaintext

function get_docx_plaintext(
    p_docx in blob
) return clob

extracts plain text from docx

function get_file_from_template

function get_file_from_template(
    p_template in blob,
    p_names in t_str_array,
    p_values in t_str_array
) return blob

performs substitutions on a template

function get_xlsx_properties

function get_xlsx_properties(
    p_xlsx in blob
) return t_xlsx_properties

get XLSX properties

function get_xlsx_column_number

function get_xlsx_column_number(
    p_column_ref in varchar2
) return number

get column number from column reference

function get_xlsx_column_ref

function get_xlsx_column_ref(
    p_column_number in number
) return varchar2

get column reference from column number

function get_xlsx_cell_value

function get_xlsx_cell_value(
    p_xlsx in blob,
    p_worksheet in varchar2,
    p_cell in varchar2
) return varchar2

get cell value from XLSX file

function get_xlsx_cell_values

function get_xlsx_cell_values(
    p_xlsx in blob,
    p_worksheet in varchar2,
    p_cells in t_str_array
) return t_str_array

get multiple cell values from XLSX file

function get_xlsx_cell_values_as_sheet

function get_xlsx_cell_values_as_sheet(
    p_xlsx in blob,
    p_worksheet in varchar2,
    p_cells in t_str_array
) return t_xlsx_sheet

get multiple cell values from XLSX file (as sheet)

function get_xlsx_cell_array_by_range

function get_xlsx_cell_array_by_range(
    p_from_cell in varchar2,
    p_to_cell in varchar2
) return t_str_array

get an array of cell references by range

function get_xlsx_number

function get_xlsx_number(
    p_str in varchar2
) return number

get number from Excel internal format

function get_xlsx_date

function get_xlsx_date(
    p_date_str in varchar2,
    p_time_str in varchar2:=null
) return date

get date from Excel internal format

function get_pptx_properties

function get_pptx_properties(
    p_pptx in blob
) return t_pptx_properties

get pptx properties

function get_pptx_media_list

function get_pptx_media_list(
    p_pptx in blob,
    p_slide in number:=null
) return t_str_array

get list of media files embedded in presentation

function get_pptx_plaintext

function get_pptx_plaintext(
    p_pptx in blob,
    p_slide in number:=null,
    p_note in number:=null
) return clob

get plain text from slide

record t_core_properties

type t_core_properties is record(
    title varchar2(2000),
    subject varchar2(2000),
    creator varchar2(2000),
    keywords varchar2(2000),
    description varchar2(2000),
    last_modified_by varchar2(2000),
    revision number,
    created_date date,
    modified_date date
)

record t_app_docx

type t_app_docx is record(
    application varchar2(2000),
    app_version varchar2(2000),
    company varchar2(2000),
    pages number,
    words number
)

record t_docx_properties

type t_docx_properties is record(
    core t_core_properties,
    app t_app_docx
)

record t_app_xlsx

type t_app_xlsx is record(
    application varchar2(2000),
    app_version varchar2(2000),
    company varchar2(2000)
)

record t_xlsx_properties

type t_xlsx_properties is record(
    core t_core_properties,
    app t_app_xlsx
)

record t_app_pptx

type t_app_pptx is record(
    application varchar2(2000),
    app_version varchar2(2000),
    company varchar2(2000),
    slides number,
    hidden_slides number,
    paragraphs number,
    words number,
    notes number,
    presentation_format varchar2(2000),
    template varchar2(2000)
)

record t_pptx_properties

type t_pptx_properties is record(
    core t_core_properties,
    app t_app_pptx
)

record t_xlsx_cell

type t_xlsx_cell is record(
    column varchar2(2),
    row number,
    value varchar2(4000)
)

varray t_xlsx_sheet

type t_xlsx_sheet is varray of t_xlsx_cell index by varchar2(20)

record t_xlsx_sheet_attributes

type t_xlsx_sheet_attributes is record(
    r_id varchar2(255),
    sheetid number,
    name varchar2(31),
    state varchar2(10)
)

varray t_xlsx_sheet_properties

type t_xlsx_sheet_properties is varray of t_xlsx_sheet_attributes index by pls_integer