Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
Hello All,

First I will explain what is my requirement and then I will explain what I have done so far and what are all the helps I need...

I have to export data from sql server to excel sheet. The excel sheet will be like a standard template. If I run my project, the data from SQL Server should be inserted into a new excel file which should use that template and it should be created and saved into a new location. Also, generally we will use first row as header. But in my requirement, the template will have two or three rows header. So, the data should be inserted automatically from the third/fourth empty row.

I have done exporting data from sql server database to normal excel sheet with first row as header. I have also done exporting data from different tables into different sheets of the same excel file.

Any body please help out for the template format, creation of new excel file while running project and two or three rows as header.

I am using SQL Server 2005 and Visual Studio 2005.

Please help out...Thanks in advance...
Posted 27-Sep-12 21:37pm

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 457
1 OriginalGriff 430
2 Shai Vashdi 240
3 Emre Ataseven 165
4 Peter Leow 146
0 Sergey Alexandrovich Kryukov 8,944
1 OriginalGriff 5,280
2 Peter Leow 3,985
3 Maciej Los 3,535
4 Abhinav S 3,218


Advertise | Privacy | Mobile
Web02 | 2.8.140415.2 | Last Updated 9 Nov 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid