Why am I getting "no data found" when uploading an Excel file to Application Express (APEX)?
We are using Apex version 21.2.0.
We have an application which uploads an Excel spreadsheet and displays it in a preview region. The file is parsed using the following statement:
select p.line_number,
p.col001, p.col002, p.col003, p.col004, p.col005, p.col006, p.col007, p.col008, p.col009, p.col010, p.col011, p.col012, p.col013
-- add more columns (col011 to col300) here.
from apex_application_temp_files f,
table( apex_data_parser.parse(
p_content => f.blob_content,
p_file_name => f.filename,
p_xlsx_sheet_name => case when :P4002_XLSX_WORKSHEET is not null then :P4002_XLSX_WORKSHEET end,