14.7 GET_XLSX_WORKSHEETS Function

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

Syntax

FUNCTION GET_XLSX_WORKSHEETS(
    p_content   IN BLOB ) RETURN apex_t_parser_worksheets;

Parameter

Table 14-4 GET_XLSX_WORKSHEETS Parameters

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