Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Excel download with huge data

vijay dasariNov 2 2021 — edited Nov 2 2021

Hi ,

Jdev:12.2.1.2.0

I have a table with huge data so when users generate reports based on customer numbers then we need to generate the xlsx file to the user (instantly) (not through email or server path)

I tried with apache poi and it's taking so much time and it's holding users screen and sometimes getting java heap exceptions.

can anyone suggest downloading the xlsx file in ADF( columns headers have color style)
each time , we are filtering the table based on user-selected customer and getting more than 100000 rows and writing into excel
Thanks in advance

Added on Nov 2 2021

#adf, #application-development-in-java, #jdeveloper, #jdeveloper-and-adf

3 comments

584 views