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.
manalibhadula 0 Newbie Poster
David_50 13 Junior Poster in Training
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?
manalibhadula 0 Newbie Poster
no , i want to compare only the data in the cells.
David_50 13 Junior Poster in Training
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.