Dear support, I am using xhssfworkbook while generation excel file.
This file having named range value. To validate the column name I added reference name. So, to do some operation I convert the actual column name to short format with help of naming convention. But when I read with Workbook same excel file it was not update the column. When I take the excel file and save the file manually then it was increase the size by 20k then I run the excel then it was working. Now my question, data is present but it was not update the column through naming convention. One more thing why increase the file size if I save the generated file manually. Instead of using xhssfworkbook to xssfworkbook while generating excel it was working fine. But xssfworkbook is not faster for streaming data. If I took same excel and again try to save file also it will not through program. Kindly help us some solution with this. Thanks, Warm regards, Shivakumar Senoir Software developer
