ExcelHome技术论坛

 找回密码
 免费注册

QQ登录

只需一步,快速开始

EH搜索     
EH云课堂-专业的职场技能充电站 Excel转在线管理系统,怎么做看这里 Excel服务器-会Excel,做管理系统 Excel Home精品图文教程库
Excel不给力? 何不试试FoxTable! Excel 2016函数公式学习大典 高效办公必会的Office实战技巧 免费下载Excel行业应用视频
300集Office 2010微视频教程 Tableau-数据可视化工具 精品推荐-800套精选PPT模板,点击获取 ExcelHome出品 - VBA代码宝免费下载
你的Excel 2010实战技巧学习锦囊 欲罢不能, 过目难忘的 Office 新界面 Excel VBA经典代码实践指南
查看: 4049|回复: 2

Open XML SDK 2.5 类库参考

[复制链接]

TA的精华主题

TA的得分主题

发表于 2013-4-14 14:24 | 显示全部楼层 |阅读模式
本帖已被收录到知识树中,索引项:其他专业开发
本帖最后由 liucqa 于 2013-4-14 14:37 编辑

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/b*****7946  从 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支持

TA的精华主题

TA的得分主题

 楼主| 发表于 2013-4-14 14:38 | 显示全部楼层
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/

TA的精华主题

TA的得分主题

发表于 2013-4-14 20:36 | 显示全部楼层
这个里面有个工具,可以直接生成excel文件,也可以看到base64的vbaproject的流
您需要登录后才可以回帖 登录 | 免费注册

本版积分规则

关闭

最新热点上一条 /1 下一条

关注官方微信,每天学会一个新技能

手机版|关于我们|联系我们|ExcelHome

GMT+8, 2019-8-26 15:18 , Processed in 0.069994 second(s), 13 queries , Gzip On, MemCache On.

Powered by Discuz! X3.4

© 1999-2020 Wooffice Inc.

   

沪公网安备 31011702000001号 沪ICP备11019229号

本论坛言论纯属发表者个人意见,任何违反国家相关法律的言论,本站将协助国家相关部门追究发言者责任!     本站特聘法律顾问:徐怀玉律师 李志群律师

快速回复 返回顶部 返回列表