Hi,
I am Not able to save any changes on same file. It will corrupt the file.
I have to save into different file.
I doing following things.
LoadOptions loadOptions = null;
FileStream excleFile= new FileStream(“C:\Book2.xls”, FileMode.Open);
loadOptions = new LoadOptions(LoadFormat.Auto);
Workbook workbook = new Workbook(fstream,loadOptions );
// adding new worksheet ,rename worksheet all other operations.
finally…
workbook.Save(excleFile, SaveFormat.Xlsx);
excleFile.Close();
It will save changes in file, but file become corrupted.
and next time when i open the file it will throws following error.
Cannot read that as a ZipFile
It works if I save as different file
e,g workbook.Save(“C:\Book3.xls”, SaveFormat.Xlsx);
Any suggestion would appreciated !!!