Excel Export and Import

[gokulin]

Hi All,

I am writing an ASP.NET application in C# (an Application integrated and communicates with MS CRM) with Excel Export and Import options.

The user of the system exports data from the system as Excel spreadsheet, makes changes to spreadsheet and imports it into the system again.

My problem is: Export goes well. But when I try to import the spreadsheet, it gives out errors while reading the cell values. The error message is not clear or specific.
Can someone help me out?

[gokulin]

Hey guys!

Found out something weird.

I export the file and save it on my desktop. Then I save the same file in a different name using 'Save As' option. Then I import the file and it seems to work fine. What happens during 'Save As'......

Had anyone encountered such problem with excel export and import??

[kenobewan]

Please paste the error message anyway. Sounds like you are having a problem with the import file location and that is why your project is having no trouble locating a file locally. Recheck the import part of the code especially the path.