Excel SpreadSheet!!!

  • Thread starter Thread starter Vai2000
  • Start date Start date
V

Vai2000

Hi All, Challenging situation. I have a Dataset need to populate excel
spreadsheet out of it. Hardway would be via automation calling Excel Object
then population cells etc...Is there some other way? I checked out a soln
over the web, very cool but its for WebForm..my problem is I have a console
app in c#

TIA
 
Vai2000,

If you have the code for the WebForm, it shouldn't be too hard to
extract the code that does the writing to the excel sheet.

However, I would use the Jet OleDb provider for Excel. You can use this
provider with the classes in the System.Data.OleDb namespace to create an
OleDbDataAdapter which will take the data set and make the updates.

Hope this helps.
 
Hi Vai

I think that you should read this KB article
http://support.microsoft.com/kb/306022
it discuss many possible alternative to export a Dataset into an Excel
spread sheet

Essam


Nicholas Paldino said:
Vai2000,

If you have the code for the WebForm, it shouldn't be too hard to
extract the code that does the writing to the excel sheet.

However, I would use the Jet OleDb provider for Excel. You can use this
provider with the classes in the System.Data.OleDb namespace to create an
OleDbDataAdapter which will take the data set and make the updates.

Hope this helps.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

Vai2000 said:
Hi All, Challenging situation. I have a Dataset need to populate excel
spreadsheet out of it. Hardway would be via automation calling Excel
Object
then population cells etc...Is there some other way? I checked out a soln
over the web, very cool but its for WebForm..my problem is I have a
console
app in c#

TIA
Click to expand...
Click to expand...
 
Back
Top