GET_XLSX_WORKSHEETS Function

22.8 GET_XLSX_WORKSHEETS Function

This function returns information on worksheets within an XLSX workbook as a list of apex_t_parser_worksheet instances.

Syntax

APEX_DATA_PARSER.GET_XLSX_WORKSHEETS (
    p_content   IN BLOB )
RETURN apex_t_parser_worksheets;

Parameter

Parameter	Description
`p_content`	XLSX worksheet as a BLOB.

Returns

Returns table with worksheet information.

Example

select * from table(
    apex_data_parser.get_xlsx_worksheets(
        p_content =>{BLOB containing XLSX file}

SHEET_SEQUENCE SHEET_DISPLAY_NAME   SHEET_FILE_NAME   SHEET_PATH              
1              Sheet1               sheet1.xml        worksheets/sheet1.xml

Parent topic: APEX_DATA_PARSER