Getting data into Excel

  • Thread starter Thread starter JPSutor
  • Start date Start date
J

JPSutor

I need to know how to take data from a dataset and write it to an Excel
spreadsheet.
Please, Please , do not send me any MSFT examples. They, for the most
part, are useless
I'm just looking for a little code snippet example
 
JPSutor,

I don't know why you don't want the microsoft examples. They are
actually pretty good in terms of showing you how to create an instance of
the excel sheet, and doing exactly what you want. Once you have the
workbook open, its a matter of just setting the values in the right cells.

Have you checked out http://support.microsoft.com? There are a ton of
HOWTO articles dealing with how to use Excel from C#.

Hope this helps.
 
Nicholas,
If you could direct me to one or two examples that show me exactly what
I want to do I'd be greatful. So far I have not found any.
 
JPSutor,

Knowledge base article 302096, titled "How To Automate Excel with Visual
C# .NET to Fill or to Obtain Data in a Range by Using Arrays", located at
(watch for line wrap):

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

While arrays are being used to set the values, you can easily substitute
anything you wish for the array (a data set, perhaps, or some other source
of values).
 
Back
Top