export to word

Komila · August 2nd, 2006, 05:38 AM

hey i m creating a report, i want to export it to word.
as the data is coming from various schema's and data is dynamic so after one page is over it should have header and footer with pagebreak.
right now i m using a word object in vb.net but it is not allowing me to create a new application due to some access problem even though i have given full rights to everyone.

pl help i have to release my system....

thnks in advance

skajani · August 7th, 2006, 12:24 AM

Hi Komila,
I am exporting to pfd.this code will help u exporting to word
on buttton click i am exporting my data to pdf.

u just hv to change this things:-
Response.ContentType = "application/vnd.ms-word";
ExportToStream(CrystalDecisions.Shared.ExportForma tType.WordForWindows)

private void export_Click(object sender, System.EventArgs e)
        {

            // this is to give the log on info ...
            TableLogOnInfo logonInfo = new TableLogOnInfo();
            logonInfo = rpt.Database.Tables[0].LogOnInfo;
            logonInfo.ConnectionInfo.ServerName = "server";
            logonInfo.ConnectionInfo.DatabaseName = "shirazee";
            logonInfo.ConnectionInfo.UserID = "sa";
            logonInfo.ConnectionInfo.Password = "1234";
            rpt.Database.Tables[0].ApplyLogOnInfo(logonInfo);
            MemoryStream oStream; // using System.IO

            // this code is to export report to pfd
                oStream = (MemoryStream)

                rpt.ExportToStream(CrystalDecisions.Shared.ExportF ormatType.PortableDocFormat);
                Response.Clear();
                Response.Buffer= true;
                Response.ContentType = "application/pdf";
                Response.BinaryWrite(oStream.ToArray());
                Response.End();

        }

Komila · August 12th, 2006, 12:10 AM

thnks for reply skajani
can u tell me if i want to convert to pdf then wat i have to write. and my report is not crystal report. its just an aspx page.

n even i want to add header and footer to my that report after and before page break.
do u have any idea how to do that.?:(

john.glenn965 · July 19th, 2013, 04:39 AM

Hi Komila, you can also try this .NET Word component. Here is a simple hello world sample code how to create and write word file in C# which will contain Hello World text, Page Break and a page number in footer:

Code:

// Create a new empty document.
DocumentModel document = new DocumentModel();

// Add document content.
document.Sections.Add(
    new Section(document,
        new Paragraph(document,
            new Run(document, "Hello World"),
            new SpecialCharacter(document, SpecialCharacterType.PageBreak))));

// Add document footer with page number.
document.Sections[0].HeadersFooters.Add(
    new HeaderFooter(document, HeaderFooterType.FooterDefault,
        new Paragraph(document,
            new Run(document, "Page number: "),
            new Field(document, FieldType.Page))));

// Save the document to a file.
document.Save("\\Document.docx");

To add you can easily convert Word file to a PDF in C# just by saving the document with .pdf extension.