Code Samples from the Creating custom Word and Excel Documents using Open XML Format Presentation

by Van 12. June 2011 21:25

RichCC2011.zip (234.03 kb)

At last I am finally getting my code and slides out for the presentation I did at Richmond code camp XI “Creating custom Word and Excel Documents using Open XML Format”. Sorry this took so long but my life was disrupted when lighting hit the tree in front of my house. Another story for another day.

 

To get the libraries needed to run the attached code you must first go to:

http://www.microsoft.com/downloads/en/details.aspx?FamilyId=C6E744E5-36E9-45F5-8D8C-331DF206E0D0&displaylang=en

 

At this link you will get:

OpenXMLSDKv2.msi – will add the libraries needed

OpenXMLSDKTool.msi – will add a tool to help evaluating office documents.

 

When using the Open XDML Sdk you will also need to add the following references to your project:

DocumentFormat.OpenXml

WindosBase

 

Related links

Introducing the Office (2007) Open XML File Formats:

http://msdn.microsoft.com/en-us/library/aa338205.aspx

 

Open XML Developer Center

http://msdn.microsoft.com/en-us/office/bb265236.aspx

 

Openxmldeveloper.org

http://openxmldeveloper.org/default.aspx

 

Blogs on Open XML Format SDK:

Brian Jones & Zeyad Rajabi: Office Solutions:

http://blogs.msdn.com/b/brian_jones/

Eric White's Blog:

http://ericwhite.com/blog/

 

 

About Van

Van, a Senior Web Developer for Innervisions Software, Inc. since 1996, started programming Mainframes using COBOL, JCL for AT&T in 1979. While at AT&T, Van was part of many development teams that produced enterprise level applications and systems using CICS, IMS and other mainframe technologies. 

Van bought his first personal computer in 1982, an Apple II+, and started to write programs for home use in Applesoft (Basic Microsoft created for the Apple II) . 

Van first started working with Microsoft technologies using Access 1.0 and Visual Basic 3.0. In 2000, Van attended VS Live in Orlando where he was first exposed to .Net. He started programming .Net with Visual Studio .Net Beta 2. He became an Independent Consultant in 1996 and started Innervisions Software, Inc. 

In 2003 he wrote his first professional ASP.Net app. Since 2004 Van has been subcontracting on an IRS project using ASP.Net, VB.Net, and SQL Server.


He spends his spare time working on the web site for Prince William Special Olympics which was created using Dot Net Nuke.   Van is currently working on a Silverlight app for Prince William Special Olympics to manage their volunteers.


Van has a BA in Mathematics from Lehman College in New York City and a MS in Computer Science from George Washington University. Van holds MCP certifications in Visual Basic, Access, ASP.Net and SQL Server.

Month List

Page List