Export data from a dataset to multiple sheet

Question

0.00/5 (No votes)

See more:

I have a single datatable in database where rows are greater than 65536,how can i save all my data in excel format but in multiple sheet.
example-
My datatable->dbo.MyTable where rows are about 1048676 and 7 columns.

So by C# program the rows starting from 1 to 65536 should save in sheet 1,then the remaiining rows again starting from 65537 to 131071 rows should save in sheet2 and So on till 1048676.

Posted 29-Aug-12 1:57am

StackQ

Add a Solution

Comments

I.explore.code 29-Aug-12 9:41am

I remember doing something similar not too long ago, what i used was OpenXML processing to create Excel(xlsx) file and using Part and Package classes in .NET to generate multiple sheets. So you split your dataset in two data tables one you write in Sheet 1 and other in sheet 2. It requires a bit of hacking around these things to get it right, took me around 3 days.

StackQ 30-Aug-12 0:20am

OK,but when u will solve this,plz help my by code.thnks..

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Killzone DeathMan · Answer 1 · 2012-08-29T03:51:00

Solution 1

Just use a sql query, something like this: 'SELECT * FROM TABLE LIMIT ' + i + ', 65536' where the variable 'i' is the flag.
First i = 0, then you do the sql query and do the export to excel, second i = 65536, and you do the export to excel, then i = 131072, and So on till 1048676!
I hope you undestand!

Posted 29-Aug-12 3:51am

Killzone DeathMan

Updated 29-Aug-12 4:23am

v2

Comments

StackQ 30-Aug-12 0:21am

can u guide me through code,bcoz i m a beginner.

Killzone DeathMan 2-Sep-12 15:12pm

This days I dont have time for writing code for you... sorry!