Reading and Writting Excel File to Server.

Topics: Developer Forum, User Forum
Jul 25, 2008 at 7:38 AM

Hello All,

I am using ASP.NET 2005 (C#). I using Excel Package dll for reading and writting excel file.
I have to generate excel file and save to server. 
I m not able to read excel file giving error of "File contains corrupted data".
Also I have make some cells as readonly.
Finally whenever client opens that file in browser he can change the values in any cell which are not marked readonly and then on save button click event that file must be saved back to server.
Any suggestion.
Please help me. Thanks in advance.

Jul 31, 2008 at 7:51 PM
FYI, something simple can make the corrupt data thing happen. For example, the maximum length of a WorkSheet name is 30 characters. This kind of thing is not enforced when you create a spreadsheet with ExcelPackage as it is.
Aug 1, 2008 at 5:39 AM
Thanks BradRoberts. The problem was coming because I was having Excel 2003 now its not giving that error. But still I am not able to show that excel file on Browser and when client do any changes in  that excel it must be save back to server.

Please help me with this.

Thanks again...