Hi guys

Does anyone know any java api which can handle .xlsx file with 10lakh records? I have tried using POI XSSFReader, it is not supporting this much large file. My xlsx file size increases horizontlly as well as verticaly.

Recommended Answers

All 3 Replies

Accurate comparison might take advanced APIs, to compare workbooks sheet by sheet. For each sheet, it might be easier to convert the sheet to CSV or tab separated text and use a text comparison tool. There are free command line tools to do that. Do you want to detect styling differences?

no , i want to compare only the data in the cells.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.