saving data from gridview to word file

Question

0.00/5 (No votes)

See more:

Hi All,
Now i have a gridview that contains some of phone numbers and user name and i want to make a button to save that data into word file in the pc of user. How can i make this, please?
Thanks

Posted 12-Jan-11 8:35am

moon2011

Updated 12-Jan-11 8:43am

TweakBird

v2

Add a Solution

Comments

TweakBird 12-Jan-11 14:44pm

Can you post your tried sample code here. are you googled for it.?

moon2011 13-Jan-11 4:14am

Response.Clear();

Response.Buffer = true;

Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.doc");

Response.Charset = "";

Response.ContentType = "application/vnd.ms-word ";

StringWriter sw = new StringWriter();

HtmlTextWriter hw = new HtmlTextWriter(sw);

GridView1.AllowPaging = false;

GridView1.DataBind();

GridView1.RenderControl(hw);

Response.Output.Write(sw.ToString());

Response.Flush();

Response.End();

there is the code i tried , bur the problem is when i opened the file i found it empty and often it connot be opened because there was an error in encoding, any help, please?

2 solutions

Solution 2

If an Office 2007 version is okay, then using the Open XML Tool[^] is probably the most fun way to do it.

Basically, create the Word doc as you would like it to appear, then create the class that will generate it, looping through your data result and put the values in the appropriate place in the doc.

Not easy, but well worth the effort, especially if you want to spit out the result from a web server...which pretty much precludes using any sort of Office "automation".

Posted 12-Jan-11 8:56am

GenJerDan

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)

TweakBird · Accepted Answer · 2011-01-12T08:51:00

Solution 1

Hi,

Just am googled with 'export gridview to word' as keyword. I got 254K results. below URL is Second one, if you noticed Third result from CP.

Export-GridView-To-Word-Excel-PDF-CSV-Formats-in-ASP.Net[^]

My suggestion is: Please search it before asking the question.

Posted 12-Jan-11 8:51am

TweakBird

Comments

GenJerDan 12-Jan-11 15:40pm

While they (all the ones I checked, anyway) will work, they don't actually create a Word doc. They just "trick" Word or Excel into opening what you send it. That is probably fine in most cases...but not if you need a "real" doc for whetever reason (formatting, etc.).

moon2011 13-Jan-11 3:34am

thanks for your reply, but i searched for that i had an error occured in opening word file , and i asked for help by another code.
thanks

moon2011 16-Jan-11 4:39am

Thanks alot , i have solved it

TweakBird 16-Jan-11 4:46am

Welcome Monamoona!