Excel SpreadSheet!!!

[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

 

[Nicholas Paldino [.NET/C# MVP]]

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.

 

[Guest]

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

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)

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