Office
<<  Using Common Features of Microsoft Office 2003 Интеграция Microsoft Access 2003 с приложениями MS Office  >>
Solution Development Using the 2007 Microsoft Office System Open XML
Solution Development Using the 2007 Microsoft Office System Open XML
Solution Development Using the 2007 Microsoft Office System Open XML
Solution Development Using the 2007 Microsoft Office System Open XML
Agenda
Agenda
Office Open XML Formats
Office Open XML Formats
Office Open XML Formats
Office Open XML Formats
The Role of XML with Documents
The Role of XML with Documents
Open XML Formats Architecture
Open XML Formats Architecture
Components of the New Formats
Components of the New Formats
Exploring the Office Open XML Formats
Exploring the Office Open XML Formats
Design Strategies
Design Strategies
WordprocessingML
WordprocessingML
SpreadsheetML
SpreadsheetML
PresentationML
PresentationML
The Role of XML Reference and Custom-defined Schemas
The Role of XML Reference and Custom-defined Schemas
The Role of XML Reference and Custom-defined Schemas
The Role of XML Reference and Custom-defined Schemas
The Role of XML Reference and Custom-defined Schemas
The Role of XML Reference and Custom-defined Schemas
Tools for Accessing Data In Office Open XML files
Tools for Accessing Data In Office Open XML files
System
System
System
System
System
System
System
System
New community formed to help bring developers together Currently
New community formed to help bring developers together Currently
Developing with the Formats
Developing with the Formats
Developing with the Formats
Developing with the Formats
Sample Solution Scenarios
Sample Solution Scenarios
Programmatically swapping styles in a Word 2007 Document
Programmatically swapping styles in a Word 2007 Document
Resources
Resources
Solution Development Using the 2007 Microsoft Office System Open XML
Solution Development Using the 2007 Microsoft Office System Open XML
© 2006 Microsoft Corporation
© 2006 Microsoft Corporation

Презентация: «Solution Development Using the 2007 Microsoft Office System Open XML File Formats». Автор: Brian Jones. Файл: «Solution Development Using the 2007 Microsoft Office System Open XML File Formats.ppt». Размер zip-архива: 875 КБ.

Solution Development Using the 2007 Microsoft Office System Open XML File Formats

содержание презентации «Solution Development Using the 2007 Microsoft Office System Open XML File Formats.ppt»
СлайдТекст
1 Solution Development Using the 2007 Microsoft Office System Open XML
2 Solution Development Using the 2007 Microsoft Office System Open XML

Solution Development Using the 2007 Microsoft Office System Open XML

File Formats

Microsoft Corporation

3 Agenda

Agenda

Overview of the new formats Additional benefits of the new formats Role of XML in Office documents Structural details of the new formats Custom defined schema support File format benefits for developers Solution capabilities Demos throughout

4 Office Open XML Formats

Office Open XML Formats

New XML file formats for Microsoft Word, Excel and PowerPoint New formats will be the default file formats, w/ new file type extensions (.docx; .pptx; .xlsx) Fully 100% compatible with existing formats Open, transparent format improves interoperability XML - Transparent, XML format enables new integration scenarios for documents and LOB systems ZIP container - allows for standard compression on all files without user effort Licensing - Removed need for license by providing a Covenant that says we won’t enforce IP against folks implementing the format (100% royalty free) Standardization Ecma International - created TC45 to fully document the Open XML formats Members include: Apple, Barclays Capital, BP, the British Library, Essilor, Intel Corporation, NextPage Inc., Statoil ASA and Toshiba Current spec is already over 2000 pages

5 Office Open XML Formats

Office Open XML Formats

Added Benefits: compact and robust ZIP container allows for standard compression on all files without user effort (Dramatic file size improvements) Significantly more robust files to help minimize data loss Backward Compatible: Microsoft Office 2000, Microsoft Office XP, Microsoft Office 2003 Patches for compatibility available by launch Open, edit and save new formats Legacy support: Current Microsoft Office 97-2003 binary file formats supported Support for XML formats from Microsoft Office 2003, Microsoft Office XP continued Developers: Endless potential for developers Build solutions to read, write, and modify Microsoft Office files (without the need to run Microsoft Office APIs)

6 The Role of XML with Documents

The Role of XML with Documents

Scenario

Example

Document Assembly Server-based or user-assisted construction of documents from archived content or database content

Content Reuse Much easier to move content between documents, including different document types

Content Tagging Add domain-specific metadata to document content to enable custom solutions

Document Interrogation Query document repositories based on custom data, content types or document metadata

Document Sanitization Remove unwanted content like comments or embedded code from your document when appropriate

Create sales reports from financial and forecast data stored in a CRM system

Apply content stored in Word documents to Web pages quickly and efficiently

Tag presentations using a specific taxonomy to improve knowledge management efficiency

Search for all documents containing a specific company name or sales contact

Remove all tracked changes and comments from a Word document before it is published

7 Open XML Formats Architecture

Open XML Formats Architecture

Developer view: Modular file

User view: Single file

File container

Document Parts Most parts are XML Each XML part is a discreet, compressed component Can add, extract and modify individual parts without using Office programs Corruption or absence of any part would not prohibit the file from being opened

Questionnaire.docx

Document properties

Comments

WordML/SpreadsheetML, etc.

Custom-defined XML

Images, video, sound

Embedded code/macros

Charts

8 Components of the New Formats

Components of the New Formats

Package – ZIP Container Part – The “files” inside the ZIP Content Types – Each part has a content type that is enforced on open Relationships – Any part that references another part must do so via a relationship

9 Exploring the Office Open XML Formats

Exploring the Office Open XML Formats

10 Design Strategies

Design Strategies

Don’t reinvent the wheel Utilizes the WordprocessingML 2003 file format constructs Developers familiar with WordprocessingML 2003 will find the formats very similar XML everywhere Any place where we don’t need binary (e.g. image storage), don’t have it Binary only where it’s an object we don’t ‘own’ Break out parts where it benefits developers and end users Example: Move comments into separate part (clear at the firewall) Example: Move style definitions into separate part (change the style sheet easily) Example: If one area of the document is corrupted, the rest of the document can still be recovered

11 WordprocessingML

WordprocessingML

Document

body

properties

A WordprocessingML file is a collection of multiple ‘subdocuments’, formally called stories: The main story Header(s) / Footer(s) Footnote(s) / Endnote(s) Subdocuments Frame(s) Comment(s)

comments

images

footnotes/endnotes

numberingDefinitions

headers/footers

styles

fontTable

customXML

12 SpreadsheetML

SpreadsheetML

Workbook

properties

styles

sharedStrings

calcChain

sheet1..N

sheet1..N

sheet1..N

sheet1..N

table

chart

sheet1..N

sheet1..N

sheet1..N

drawing

13 PresentationML

PresentationML

14 The Role of XML Reference and Custom-defined Schemas

The Role of XML Reference and Custom-defined Schemas

XML Reference Schemas Display-oriented (for example, Bold, Italics, Tables, Paragraphs, Styles) Open Document Format Enable Archival and File Formats Interoperability

Custom-defined Schemas Data-oriented (for example, Price, Invoice) Represents the business information stored in the document Enable System Integration

15 The Role of XML Reference and Custom-defined Schemas

The Role of XML Reference and Custom-defined Schemas

XML Reference Schemas Display-oriented (for example, Bold, Italics, Tables, Paragraphs, Styles) Open Document Format Enable Archival and File Formats Interoperability

<w:p> <w:r> <w:rPr><w:b /></w:rPr> <w:t>John Doe</w:t> </w:r> <w:r> <w:rPr><w:i /></w:rPr> <w:t>Health Agency</w:t> </w:r> </w:p>

16 The Role of XML Reference and Custom-defined Schemas

The Role of XML Reference and Custom-defined Schemas

Custom-defined Schemas Data-oriented (for example, Price, Invoice) Represents the business information stored in the document Enable System Integration

<ConferenceReport> <Date>3/24/2004</Date> <Attendees> <Attendee Name=“John Doe”> <Department> Health Agency </Department> <Potential> <Sales>100</Sales> <Growth>25%</Growth> … </Attendee>

17 Tools for Accessing Data In Office Open XML files

Tools for Accessing Data In Office Open XML files

XML Editing System.XML ZIP Manipulation WinFX System.IO.Packaging Office Open XML Resource Kit Code Snippets - Beta 2 C# and VB.NET Validation Library Parses a file and reports on schema, relationship errors and warnings Serialization/Deserialization Library Flattens package into a single file for ease of development in simple construction scenarios WinFX – System.IO.Packaging

18 System

System

IO.Packaging API Functionality

Package PackagePart PackagePartCollection PackageRelationship PackageRelationshipCollection PackUriHelper

Create/Open packages Create and delete parts and relationships Read and write part streams Iterate through collections of parts and relationships

19 System

System

IO.Packaging.Package

Package class provides methods to create, enumerate and delete the following entities: Package Package Relationships PackageProperties Parts

Common Package Parts

Package Relationships

Core Properties

Thumbnail

Digital Signatures

Specific Format Parts

officeDocument

Part Rels

XML Part

XML Part

Etc…

Part Rels

XML Part

20 System

System

IO.Packaging.Relationship

Relationships tie the parts together Required to find parts (part names are not guaranteed) Iterate through RelationshipCollection by Type or ID Relationship Properties: ID Package RelationshipType SourceUri TargetMode TargetUri

21 System

System

IO.Packaging.PackagePart

Parts are the objects of data within the Package PackagePart provides support to create, enumerate and delete part relationships Get Part data as Stream PackagePart Properties: CompressionOption ContentType Package Uri

Common Package Parts

Package Relationships

Core Properties

Thumbnail

Digital Signatures

<w:body> - <w:p w:rsidR="001B7EF4" w:rsidRDefault="001B7EF4"> - <w:r> <w:t>The Quick Brown Fox jumped over the river.</w:t> </w:r> </w:p>…

<w:body> - <w:p w:rsidR="001B7EF4" w:rsidRDefault="001B7EF4"> - <w:r> <w:t>The Cow jumped over the moon.</w:t> </w:r> </w:p>…

Specific Format Parts

officeDocument

Part Rels

XML Part

XML Part

Etc…

Part Rels

XML Part

22 New community formed to help bring developers together Currently

New community formed to help bring developers together Currently

sponsored by almost 40 institutions from around the world Community and Web site for information exchange Code Snippets; Tools; Discussions Free of charge. Available to everyone that wants to participate and/or encourage development on all platforms. Be one of the first to join the community! http://openxmldeveloper.org

23 Developing with the Formats

Developing with the Formats

More Reliable Solutions Third-party tools were main cause of document corruptions Fully Documented Formats Freely available for download with a royalty free license Office file format schemas - Used to validate content for a given part Samples, samples, samples In the form of code “snippets” for easier use and integration into your Visual Studio Tools for the Microsoft Office System (VSTO) solutions WinFx Package APIs Access/maintain parts and relationships within a file Takes care of all ZIP level functionality

24 Developing with the Formats

Developing with the Formats

XPath Navigation within content XML DOM Manipulating content Office Open XML Resource Kit Tools for constructing and deconstructing the new file formats Design time Validation tool Parses a file and reports on schema, relationship errors and warnings Runtime serialization tool Flattens package into a single file for ease of development in simple construction scenarios

25 Sample Solution Scenarios

Sample Solution Scenarios

Data interoperability Content manipulation Content sharing and reuse Document assembly Document security Managing sensitive information Document styling Document profiling

26 Programmatically swapping styles in a Word 2007 Document

Programmatically swapping styles in a Word 2007 Document

27 Resources

Resources

Office Preview Site: http://www.microsoft.com/office/preview/ Brian Jones’s Blog: http://blogs.msdn.com/Brian_Jones/ Kevin Boske’s Blog: http://blogs.msdn.com/KevinBoske/ Office 2003 Reference Schema Information: http://www.microsoft.com/office/xml/

28 Solution Development Using the 2007 Microsoft Office System Open XML
29 © 2006 Microsoft Corporation

© 2006 Microsoft Corporation

All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

«Solution Development Using the 2007 Microsoft Office System Open XML File Formats»
http://900igr.net/prezentacija/informatika/solution-development-using-the-2007-microsoft-office-system-open-xml-file-formats-204686.html
cсылка на страницу

Office

25 презентаций о Office
Урок

Информатика

130 тем
Слайды
900igr.net > Презентации по информатике > Office > Solution Development Using the 2007 Microsoft Office System Open XML File Formats