Re: Loading Large XLSM file using POI without Memory issue .

Hi, Please find my answers 1.Is the sheet to delete referenced in any formulas, names, chart series, etc. On other sheets? Ans: *No. There is no dependency with any other sheet * 2.Is it XLSX? Ans : It is *.XLSM format* ( Mine has set of macros available in it ) 3.Hope your suggestion on op

Re: Loading Large XLSM file using POI without Memory issue .

Is the sheet to delete referenced in any formulas, names, chart series, etc. On other sheets? Is it XLSX? If so, you may be able to just open it as a zip file and delete the sheet by manipulating the zip contents directly, without bothering to parse the xml. I would take a sample, open it in Exce

Re: Loading Large XLSM file using POI without Memory issue .

Hi Team, Thanks for your reply. 1.SAX Approach: We have tried this but our XLSM file has graph included in it Also it has many tables structure included in it . When we use SAX parser we were able to read the cell value but br