After doing some research, I found out that XSSF.addMergedRegion method is giving Excel error
Excel found unreadable content in xyz.xlsm, Do you want to recover the contents of the workbook? If you trust the source of this workbook, click yes." When I click Yes, I get another popu up "Excel was able to open the file by repairing or removing the unreadable content. Removed Records: Merge Cells from /xl/worksheets/sheet1.xm" basically I am using sheet.addMergedRegion(new CellRangeAddress(row.getRowNum(), row.getRowNum(),Column.a$, Column.e$)); which should merge the cells from column a to column e, when I comment this line of code , I am not getting excel error, this error is occuring when opening the .xlsm file from java application , basically template.xlsm is already existing for me and java application will use this existing template to write the data in to it and when needed creates new rows, during that process it has to merge cells with above line of code. how do I avoid the excel error which is caused because of merging of cells. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/XSSFSheet-addMergedRegion-giving-excel-error-tp3389764p3389764.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
