Need Export Excel More than 40 lakh records

M.bro

Hi All,

I am using oracle Forms and reports 12c and Database version also 12c.

I get new requirement from one of our valuable customer. They need down data into excel with min time.

I am working in Oracle application Express 5.0 also.

Please suggest me with tool is comfortable to use the download more records in Excel format with less than a half a minutes.

Alexandra David-Oracle

Regarding reports, you can generate Excel output using ENHANCEDSPREADSHEET format.

More details here:

https://docs.oracle.com/middleware/12211/formsandreports/build-reports/orbr_paptoexcel.htm#RSBDR0029

As for APEX, you may want to ask about this in the APEX community.

Regards,

Alexandra

M.bro

thanks for the Reply alexandra Vornic-Oracle

The link itself mentioned clearly 75000 rows only can be generated.

Large data sets (up to 75,000 rows) can be generated to the ENHANCEDSPREADSHEET output format.

Leave it the oracle application express technology. My Question is i need to download Excel more than 40 Lakh records.

Please suggest the solution or technology in oracle

Regards.

M.bro

Manu.

Dear,

Excel supports only 1048576 rows. Check the link https://support.office.com/en-us/article/Excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3

Manu.

M.bro

Dear Manu,

MS Supports 1048576 but oracle Provide Maximum How row to Exports Excel?

Regards

M.bro

Kalpataru

Create text delimited file or split your records into separate files like file1 , file 2 etc for each file will contains 1,048,576 rows.

What you have tried ?

How do you generating excel files ?

M.bro

Dear Kalpataru,

We are using 10g forms and reports using spreadsheet and 11g forms and reports using enhanced spreadsheet now we downloading upto 75000, but we need at least 1,00,000 to 5,00,000 records need to download with fraction of seconds

Create text delimited file or split your records into separate files like file1 , file 2 etc for each file will contains 1,048,576 rows.

Can you provide any link regarding the above subject. or better than this.

M.bro

Hi all,

Any update ...

cormaco

Hi M.bro,

you should have a long talk with your customer and explain to them that Excel is not the

proper tool to work with 4 million records.

What does your customer do with that data? Read them, print them? No.

This is probably used as input for some homebred Excel-based datawarehouse.

Ask them what they need that data for and suggest a solution based on SQL and APEX.

Interactive Grids in APEX look almost like Excel-sheets today, maybe that is all they need.

Kalpataru

You need to restrict the no of rows from Oracle Forms module.

Fors example you need to allow user to download report for 60,000 rows at a time.

M.bro

No i don't what restrict the no of rows and my users.

I need to download Export excel more that 75000 to maximum 1,50,000 rows or more. Not taking more second to download the excel file.