how to export result to excel spreadsheet???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,
i have done all the neccessary calculation on .NET (windows form) and i want to export the result into excel spreadsheet.

May i know how to declare excel so that open my keali.xls workbook and i can export my result in there??......(i try something like : Dim objExcel as excel.application)
 
You can do it as COM Interop but that's a fair amount of work. Check out
this link http://www.kjmsolutions.com/datasetarray.htm, you'll find it
useful. The other alternative is to use Excel as a datasource and just
configure an adapter to write to it. In this instance, Kelly's code is
probably the choice I'd go with.

HTH,

Bill

--

W.G. Ryan, eMVP

http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/
http://www.devbuzz.com/content/zinc_personal_media_center_pg1.asp
keali_lim said:
hi,
i have done all the neccessary calculation on .NET (windows form) and i
Click to expand...
want to export the result into excel spreadsheet.
May i know how to declare excel so that open my keali.xls workbook and i
Click to expand...
can export my result in there??......(i try something like : Dim objExcel as
excel.application)
 
Back
Top