471,354 Members | 1,191 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,354 software developers and data experts.

Getting data into Excel

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

Dec 9 '05 #1
4 1367
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 Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"JPSutor" <jp*****@yahoo.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
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

Dec 9 '05 #2
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.

Dec 9 '05 #3
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...b;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).
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"JPSutor" <jp*****@yahoo.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...
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.

Dec 9 '05 #4
Hi,

Did you at least searched for it?

http://www.google.com/search?hl=en&q=c%23+excel+export

c# excel export , the first page is FULL of examples (and guess what? they
are not from MS :) )
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"JPSutor" <jp*****@yahoo.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...
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.

Dec 9 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Ksenia Marasanova | last post: by
4 posts views Thread by Jean-Marie Delapierre | last post: by
1 post views Thread by Antonio. kim | last post: by
3 posts views Thread by Falcon | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.