I am using the following code to try to download the contents of an interactive report to an excel file.
DECLARE
l_export apex_data_export.t_export;
l_region_id number;
BEGIN
SELECT region_id into l_region_id
FROM apex_application_page_regions
WHERE application_id = :app_id
and page_id = :app_page_id
and static_id = 'sp_report';
l_export := apex_region.export_data (
p_format => apex_data_export.c_format_xlsx,
p_page_id => :app_page_id,
p_region_id => l_region_id);
apex_data_export.download
( p_export => l_export );
END;
I can see that the l_export record is populated but where does the apex_data_export.download actually download the data to?
The documentation isn't very clear on this.
I would be grateful for any help.