Dataset into Excel

[Guest]

I have data in a dataset that the user wants in Excel. I can do it by
writing the data in one cell at a time but it's a bit slow. Is there a quick
way to do it?

TIA

 

[Lars Netzel]

Maybe you can convert the datagrid data to an array instead and then write
to the excel sheet using a range (C7:C81).

At least when reading from a range you get an array back so I asume it would
work the other way around, but I have noidea if this is slower or faster.

best regards/
Lars Netzel

 

[Cor Ligthert [MVP]]

Helen,

I hope that this link give you some ideas

http://support.microsoft.com/default.aspx?scid=kb;EN-US;306022

There are a lot of generics on Internet for this by the way based on the
ways described in this article.

I hope this helps,

Cor

 

[Ken Tucker [MVP]]

Hi,

Here is a method to save the dataset as an xml spreadsheet and
transform it into an xls. The title shows it is for asp.net but you can use
the methods with a windows forms application.

http://support.microsoft.com/default.aspx?scid=kb;en-us;319180

Ken

 

[Richard Dudley]

I've tried a number of ways, and hands down the best way I've found is the
library from Carlos Aguilar at
http://www.carlosag.net/Tools/ExcelXmlWriter/Default.aspx.