Hello,I have one excel sheet.That contain 13 sheet,whenever i insert value inside the cell using open xml sdk 2.0 its open fine inside office 2010,but whenever i update this sheet using office 2010 its corrupted.This sheet is Work fine inside office 2007 for insert and update.i don't know what was the problem. ?Let me know
The problem could be certain namespaces used while creating the cell objects. Once you create the excel file using vs 2010, you can validate the Excel file using OpenXml 2.0 productivity tool. In few cases the tool does not give error messages. If so, please check out the namespace used. There are few namespaces which differ from office 2007 to office 2010. If you could share the excel file then it would be easy to figure out the problem.