Is there a limit for rows and columns writing to Excel from a Java PX?

I have a Java PX that creates an xlsx file using Apache POI. The PX finishes successfully but when I tried to open some of the larger files, I receive and warning “Excel found unreadable context in ‘FILENAME’. Do you want to recover the contents of this workbook? If you trust the source of this workbook,click Yes’. If I click Yes, the file would open but all formatting is gone.

My Excel file has 73 column and it looks like if I write more then 896 rows, the warning would be displayed. I did another test with a file having 35 columns and I was able to write approximately 1,860 rows. Both scenarios equate to around 65,000 cells. 

Has anyone else encountered this issue? If so, how would I resolve this?

No Files Were Attached
wingng Agile User Asked on January 29, 2019 in Other APIs.
Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.