Open XML SDK 2.5 类库参考

liucqa

http://msdn.microsoft.com/zh-SG/library/gg278315  类库参考

http://msdn.microsoft.com/zh-cn/library/bb491088.aspx   How to

http://msdn.microsoft.com/zh-SG/library/bb507946  从 Open XML 包中获取工作表信息 (Open XML SDK)


http://www.microsoft.com/en-us/download/details.aspx?id=30425    Open XML SDK 2.5 for Microsoft Office   安装包

http://social.msdn.microsoft.com/forums/en-US/oxmlsdk/


C#和VB.net环境下编辑office文档的利器，无须office支持

liucqa

Open XML  SDK 2.5  for Microsoft Office

Welcome to the Open XML SDK 2.5 for Microsoft Office. The Open XML Formats is an ISO/IEC 29500 standard and open ECMA 376 standard. Microsoft Office 2007/2010/2013 documents, specifically Microsoft Office Word 2013, Microsoft Office Word® 2010, Microsoft Office Word® 2007, Microsoft Office Excel 2013, Microsoft Office Excel® 2010, Microsoft Office Excel® 2007, and Microsoft Office PowerPoint 2013, Microsoft Office PowerPoint® 2010, and Microsoft Office PowerPoint® 2007, use these file formats with some extensions. Open XML formats are useful for developers because they are an open standard and are based on well-known technologies: ZIP and XML. This SDK is built on top of the System.IO.Packaging API and provides strongly-typed part classes to manipulate Open XML documents. More supported is added specifically for Microsoft Office 2007 documents, Microsoft Office 2010 documents, and Microsoft Office 2013 documents. This SDK also leverages the .NET Language-Integrated Query (LINQ) technology to provide strongly-typed object access to the XML content inside the parts of Open XML documents.

1.     System Requirement

The system requirements for the SDK are:

-          Supported Operating Systems: Windows 8, Windows 7, Windows Server 2008 R2, Windows Server 2008 Service Pack 2, Windows Server 2003 Service Pack 2, Windows Vista Service Pack 2, and Windows XP Service Pack 3

-          .NET Framework 4.0

-          Up to 20 MB of available disk space

2.     Installation Instructions

To install the SDK:

-          Download and save OpenXMLSDKv25.msi to your computer and run it to start the setup wizard or click ‘Run’ on the download dialog box to initiate the Setup wizard.

-          Click through the wizard pages to install the SDK.

o   If .NET Framework 4.0 is not already installed on the computer, the Setup wizard asks you to install .NET Framework 4.0 first.

o   The default path of the SDK is %programfiles%\Open XML SDK\V2.5\. You can change the path.

-        Click through the wizard and click ‘Finish’ to complete the installation.

3.     Uninstalling the SDK

To uninstall the SDK, go to Control Panel and click Add or Remove Programs.

4.     Registry Key

The installation process will create two registry keys so Windows Control Panel and other applications could verify that the SDK 2.5 is installed. The following registry kes are created:

Key:  HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\v4.0.30319\AssemblyFoldersEx\OpenXmlApiV2.5
Default Value -- type REG_ZA; data is the installed path of the binary dll.
Note: for 64bit system, the actual key path could be: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v4.0.30319\AssemblyFoldersEx\OpenXmlApiV2.5
See MSDN article in accessing the registry key in 64bit system.

Key:  HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\OpenXmlSDK
Sub key: the version of the SDK being installed on the box, for example "4.0.4725.0"
Default Value -- type REG_ZA; data is the installed path of the binary dll.
Note: for 64bit system, the actual key path could be: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\OpenXmlSDK ; see MSDN article in accessing the registry key in 64bit system

5.     Content in the SDK

The SDK contains the following:

-          Readme.htm (this file)

-          API: (DocumentFormat.OpenXml.dll)

-          Intellisense: (DocumentFormat.OpenXML.xml)

6.  Other resources

You can join the MSDN Forum at  http://social.msdn.microsoft.com/forums/en-US/oxmlsdk/

wqfzqgk

这个里面有个工具，可以直接生成excel文件，也可以看到base64的vbaproject的流