OAC DV - Export Formatted Data from a Visualization to Excel (Preview)

Vivek.More

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Sensata Technologies

Description (Required): We have Export to Excel (Preview) option in OAC DV. But it is not working in Browsers like Google Chrome, Mozilla Firefox.

Use Case and Business Need (Required): It is working in Microsoft Edge but it very slow. Also, it is not working when end users change some Filters and then try to Export in Excel.

It is showing error: "Workbook not saved. We were unable to process excel (xlsx) export request.

Enhancement Request / Service Request: SR 3-31763650691

Avinash Krishnaram-Oracle

Hi Vivek,

1. Export to excel should work on all browsers. There was an issue with exporting data with unsaved workbooks that we have fixed
2. There is an enhancement for exporting the filtered result set to excel. At the moment it ignores the filters applied and exports all data. We have not prioritized this enhancement yet.

Mrudula Kothapalli

Hi Avinash,

Do we have any update from oracle on the second point?

1. There is an enhancement for exporting the filtered result set to excel. At the moment it ignores the filters applied and exports all data. We have not prioritized this enhancement yet.

Thanks,

Avinash Krishnaram-Oracle

Hello,

The enhancement is planned for 2H CY 2023.

Thanks.

Mohaideen Abdul Kadar-Oracle

Hi Avinash,

Please confirm whether the excel export with filtering the data based on the selected filters issue will also be fixed in upcoming product patch upgrade.

Thanks.

Avinash Krishnaram-Oracle

Hello,

We have fixed this issue. As a end user / consumer user - user will not be prompted to save the workbook when exporting data to excel. The issue was fixed with March 2023 OAC update.

Thanks.

Marcelo Finkielsztein

Question please!

I do NOT see the option export to EXCEL. On my OAC DV Visualizations i only see export to:

pptx, pdf, png, csv.

What am I missing please?

Thanks,

Marcelo

Avinash Krishnaram-Oracle

Excel export is a Public Preview feature. Please make sure an administrator has turned on this feature in your instance (from the admin Console).

Marcelo Finkielsztein

THANK YOU !!!

Marcelo Finkielsztein

This is the error message I am getting when I try to export to Excel:

Marcelo Finkielsztein

Update: a VERY simple workbook worked fine. Not sure why the my 1st attempt cannot be exported.