Transcript Document
Microsoft® Office OpenXML
Jim Lyle
Data Analyst
The Sixth Form College Farnborough
Presented at the Sixth Form Colleges’ Forum
Information Systems Conference
9 June 2011
Microsoft® Office OpenXML
The Sixth Form College Farnborough
Introduction
Overview of OOXML
Demonstration of the new file format
Advantages of using OOXML
Tools needed to develop with OOXML
Demonstration (Course Review Sheets)
Microsoft® Office OpenXML
The Sixth Form College Farnborough
Overview of OOXML
Description
XML file format used to represent Office documents
XML mark-up for spreadsheets, word processing documents
and presentations
Zip archive containing XML files and sub-folders of XML files
Introduced in Microsoft Office 2007
binary
format
.doc
.ppt
.xls
Microsoft® Office OpenXML
.docx
.pptx
.xlsx
XML
format
The Sixth Form College Farnborough
Office OpenXML Demonstration
Contents of new file formats
Microsoft® Office OpenXML
The Sixth Form College Farnborough
Advantages of OOXML
Automate production of Office documents
Avoids the use of an application programming interface (api)
Can be used to create Office documents from scratch
Usually better to start from a template or pre-existing file
Microsoft® Office OpenXML
The Sixth Form College Farnborough
Tools for OOXML
Application Development
Visual Studio 2008 or 2010
• or Visual 2010 Express (free)
[www.microsoft.com/express/downloads/]
Open XML SDK 2.0 for Microsoft Office (free), includes:
• OOXML Software Development Kit (SDK) v2
• OOXML Toolkit
• Available from www.codeplex.com
Document Format Extensions (optional)
• Extensions to help with application development
• Free download from CodePlex web-site
Microsoft® Office OpenXML
The Sixth Form College Farnborough
Office OpenXML Demonstration
Curriculum Course Review Sheets
TASK
SOLUTION
Produce Curriculum
Review Sheets for:
Manually create an Excel
template with dummy
data and charts.
56 AS courses
55 A2 courses
111 x 6 = 666 charts
Short timescale
between Results Day
and Curriculum Reviews.
Consistent, authorised
set of data for review.
Microsoft® Office OpenXML
For each course, use an
OOXML application to:
• copy the workbook
• copy the sheet template
• get course data from
SQL Server
• insert the data into cells
• update each chart’s cell
references
• rename the worksheet
• add the sheet to the
workbook collection
The Sixth Form College Farnborough