Import and Export ExcelSheet in DataGrid using C#

[Unnikrishnan]

Hi All,
How we can import & Export Excel sheet using C# for
Web Application?
I will apprecaite for your help.

Regards
Unni

[sandu]

you have two possibilities, one is to use a third party component that had reverse engineered the MS Excel format (which is not public) and extract the info you need and the second is to use MS Excel itself to opend the file and extract the data.

MS recomds to use a third party application, because Office 2003 and lower wasn't designed for server-side manipulation and for this you should wait Office 2007 version.

Personally I have done what you are asking here and I can explain if you still remain interested, but I tell you that is problematic and MS is right when it recomends not to use it server side.

[mintara]

you have two possibilities, one is to use a third party component that had reverse engineered the MS Excel format (which is not public) and extract the info you need and the second is to use MS Excel itself to opend the file and extract the data.

MS recomds to use a third party application, because Office 2003 and lower wasn't designed for server-side manipulation and for this you should wait Office 2007 version.

Personally I have done what you are asking here and I can explain if you still remain interested, but I tell you that is problematic and MS is right when it recomends not to use it server side.

I want to copy contents of excel and paste it on any VC++.net
component,
I tried using a data grid but paste does not work.
I tried adding a spreadsheet to my form but I am getting the following error
" file or assembly name axinterop.owc.dll or one of its dependencies was not found" .
I am using visual studio ++.net 2003 , version 7.1.3088, .net framework version
1.1.4322
and excel 2002.
Please help.
Thanks for your time.
Mintara