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