Click here to Skip to main content
Click here to Skip to main content
Go to top

MS Word 2003 XML Output

, 29 Feb 2004
Rate this:
Please Sign up or sign in to vote.
How to give a Word output without MS Office Web Components (OWC) on the server.

Perquisites

Word 2003 in client's PC.

Introduction

We generally give an HTML output to the browser to display results. Now we can give a Word output without MS Office Web Components (OWC) on the server.

Using the code

Any application, whether it is running on Microsoft or Java technologies, can stream out MS Word compatible XML. http://schemas.microsoft.com/office/word/2003/wordml schema needs to be used. Users can use Microsoft or Java technologies to give an output, by just following the XML Schema Reference.

I am using Customers table in the Northwind database. Below is a code-behind code in C# for generating Word document in XML. Remove any HTML tag from the aspx page, only the Page directive should be there.

using System; 
using System.Collections; 
using System.ComponentModel; 
using System.Data; 
using System.Data.SqlClient; 
using System.Web; 
using System.Text; 
using System.Web.SessionState; 
using System.Web.UI; 
using System.Web.UI.WebControls; 
using System.Web.UI.HtmlControls; 

namespace Word2003 
{ 
    /// <span class="code-SummaryComment"><summary> 
</span>
    /// Summary description for WebForm1. 
    /// <span class="code-SummaryComment"></summary> 
</span>
    public class WebForm1 : System.Web.UI.Page 
    { 
        // String Builder to hold the XML 
        StringBuilder sb = new StringBuilder(); 

        #region Web Form Designer generated code 
        override protected void OnInit(EventArgs e) 
        { 
            InitializeComponent(); 
            base.OnInit(e); 
            // SQL Query 
            string sqlQry="SELECT CustomerID, CompanyName, " + 
                   "ContactName, City from customers"; 

            //Connection String 
            string connStr = "server=10.4.12.13;" + 
                   "database=northwind;user id=sa;password=aprimo"; 

            // Define Connection 
            SqlConnection sqlConn = new SqlConnection(connStr);

            // Open Connection 
            sqlConn.Open(); 

            // Define SqlCommand 
            SqlCommand cmd = new SqlCommand(sqlQry,sqlConn); 

            // Define SqlDataReader 
            SqlDataReader dr=null; 

            // Execute Query and Populate Data Reader 
            dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); 

            // XML Header. Schema is must. 
            sb.Append("<?xml version=\"1.0\"?>"); 
            sb.Append("<w:wordDocument xmlns:w=\"http://schemas" + 
                      ".microsoft.com/office/word/2003/wordml\">"); 

            sb.Append("<w:body>"); 

            // Create Table and Column Headers 
            sb.Append<w:tbl>"); 
            sb.Append("<w:tr>"); 
            sb.Append("<w:tc><w:p><w:r><w:rPr>" + 
                "<w:b w:val=\"on\" /><w:t>"+
                dr.GetName(0).ToString()+
                "</w:t></w:rPr></w:r></w:p></w:tc>"); 
            sb.Append("<w:tc><w:p><w:r>" + 
                "<w:rPr><w:b w:val=\"on\" /><w:t>"+
                dr.GetName(1).ToString()+
                "</w:t></w:rPr></w:r></w:p></w:tc>"); 
            sb.Append("<w:tc><w:p><w:r><w:rPr>" + 
                "<w:b w:val=\"on\" /><w:t>"+
                dr.GetName(2).ToString()+
                "</w:t></w:rPr></w:r></w:p></w:tc>"); 
            sb.Append("<w:tc><w:p><w:r><w:rPr>" +
                "<w:b w:val=\"on\" /><w:t>"+
                dr.GetName(3).ToString()+
                "</w:t></w:rPr></w:r></w:p></w:tc>"); 

            sb.Append("</w:tr>"); 

            // Get Data 
            while (dr.Read()) 
            { 
                sb.Append("<w:tr>"); 
                sb.Append("<w:tc><w:p><w:r><w:t>"+
                   dr["CustomerID"].ToString()+
                   "</w:t></w:r></w:p></w:tc>"); 
                sb.Append("<w:tc><w:p><w:r><w:t>"+
                   dr["CompanyName"].ToString()+
                   "</w:t></w:r></w:p></w:tc>"); 
                sb.Append("<w:tc><w:p><w:r><w:t>"+
                   dr["ContactName"].ToString()+
                   "</w:t></w:r></w:p>/w:tc>

Conclusion

If Word 2003 is installed, then it will open up and display the data. If Word 2003 is not available on the client, XML will be displayed in the browser. Microsoft Office 2003 XML Reference Schemas are available for download here.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

Karthikg
Web Developer
India India
I am working as Technical Lead at Virtusa, Hyderabad, India. I have more than 6 yrs of experience on the Microsoft Web Platform. I have been working in and out DotNet Technology since Pre Beta Release. The articles are the outcome of the R&D I do in my freetime.

Comments and Discussions

 
Questionrecord with & Pinmemberrodchar8-Dec-06 5:54 
AnswerRe: record with & PinmemberCharles E. Wagner Jr.5-Jan-07 8:44 
GeneralConversion of ASP to MS Word PinmemberVishnu_vardhan18-Jun-05 8:00 
GeneralThank you for available Code Pinmembernattapat6-Jun-05 23:00 
GeneralGreat work PinmemberVenkat Eswaran21-Dec-04 19:36 
GeneralOn a theme PinsussAnonymous26-Apr-04 23:16 
QuestionWhat about Word 2002 ? PinmemberBraulio Díez22-Mar-04 0:51 
AnswerRe: What about Word 2002 ? PinmemberKarthikg22-Mar-04 1:53 
GeneralInteresting, thanks PinmemberSteven Campbell1-Mar-04 11:41 
GeneralWord 2003 xml PinmemberStephane Rodriguez.29-Feb-04 22:07 
GeneralRe: Word 2003 xml PinmemberAbdul (Rajib) Bahar26-Apr-04 11:53 
GeneralMS Word View 2003 Pinmembermarkpers12-Jan-05 21:39 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web04 | 2.8.140916.1 | Last Updated 1 Mar 2004
Article Copyright 2004 by Karthikg
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid