To export Excel Sheet with pivot table form grid view in asp.net

Question

0.00/5 (No votes)

See more:

Hi all..

I can export a excel sheet from a grid view.
But the customer is saying export excel sheet with pivot table.
Can anyone help me on this..
Thanks!

Posted 9-Apr-12 1:06am

Anderson8055

Add a Solution

Comments

tulasiram3975 9-Apr-12 7:11am

have you completed exporting excel sheet...

Anderson8055 20-Apr-12 6:32am

Ya!! I completed exporting it tulasiram

5 solutions

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)

Abhinav S · Accepted Answer · 2012-04-09T01:24:00

Solution 1

Here[^] is how you could Pivot data in a gridview.

Posted 9-Apr-12 1:24am

Abhinav S

Comments

Anderson8055 9-Apr-12 8:44am

Thanks for the reply...
I want to change the Excel sheet which i exported from grid view to pivot table...

Bilal Ahmed Lilla · Accepted Answer · 2012-04-18T20:53:00

Solution 4

see this link.

http://blogs.msdn.com/b/andreww/archive/2008/07/25/creating-a-pivottable-programmatically.aspx[^]

http://blogs.msdn.com/b/andreww/archive/2008/07/25/creating-a-pivottable-programmatically.aspx[^]

Posted 18-Apr-12 20:53pm

Bilal Ahmed Lilla

Updated 18-Apr-12 20:54pm

v2

Dharmenrda Kumar Singh · Accepted Answer · 2012-04-09T01:36:00

Solution 2

Check this link, Might be it will help you.
http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/d229badf-ecd0-4c0f-a987-1dc30d61374b/[^]

Posted 9-Apr-12 1:36am

Dharmenrda Kumar Singh

Comments

Anderson8055 9-Apr-12 8:42am

Thanks Dharmenrda but i want to use this code in asp.net.
Can u help me on this.???

Anderson8055 · Accepted Answer · 2012-04-18T20:50:00

Solution 3

Export Excel with pivot table cannot be generated directly but by copying the grid values to another grid and from that we cah generate pivot table

Posted 18-Apr-12 20:50pm

Anderson8055

Comments

Anderson8055 27-Apr-12 3:47am

If any one have any other suggestions on this please let me know.
Thanks!!

Pandvi · Accepted Answer · 2012-04-18T21:14:00

Solution 5

Hi, Here is an article on Codeproject that tell.Exporting Data to Excel[^] you can have a check

Posted 18-Apr-12 21:14pm

Pandvi