Solved

Export dataset to excel using C# Windows Forms

Posted on 2008-10-02
3
1,092 Views
Last Modified: 2012-05-05
Hello,
II need to export data returned from sql stored procedure to excel and also do some formatting changes, change the column header names, sheet names, merge some cells etc. Also, the records in excel should be spread across multiple sheets, based on a column in the dataset.
I tried implementation using VSTO but realized its not suitable.
Any direction provided will be greatly appreciated.
0
Comment
Question by:haritha_204
3 Comments
 
LVL 26

Accepted Solution

by:
Anurag Thakur earned 250 total points
ID: 22626249
have a look at the question posted on EE previoulsy. It also points out to some codeproject links which might be helpful
http://www.experts-exchange.com/Programming/Programming_Languages/C_Sharp/Q_21234124.html

I think as your export to the excel will be customized, in that case you might need to do some extra coding for customization.
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Ivo
C# And Nullable Types Since 2.0 C# has Nullable(T) Generic Structure. The idea behind is to allow value type objects to have null values just like reference types have. This concerns scenarios where not all data sources have values (like a databa…
Introduction Hi all and welcome to my first article on Experts Exchange. A while ago, someone asked me if i could do some tutorials on object oriented programming. I decided to do them on C#. Now you may ask me, why's that? Well, one of the re…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question