12.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 12-4 GET_XLSX_WORKSHEETS Parameters
Parameter | Description |
---|---|
|
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