Excel密码删除 [英] Excel password removal

问题描述

我们每天都会收到使用相同密码进行密码保护的Excel工作簿文件.我们知道这个密码.是否有实用程序或方法可以删除这些工作簿文件上的密码保护，而无需调用Excel.exe或Excel对象.我们的目标是使Excel脱离流程，并在VB.net中使用SpreadsheetGear.但是，SpreadsheetGear只能取消保护工作表，而不能取消保护工作簿.

We receive Excel workbook files every day which are password protected with the same password. We know this password. Is there a utility or method to remove password protection on these workbook files without invoking Excel.exe or the Excel object. Our goal is to take Excel out of the process and utilize SpreadsheetGear in VB.net. However, SpreadsheetGear can only unprotect worksheets not workbooks.

谢谢

推荐答案

它们是XLS还是XLSX文件?

Are they XLS or XLSX files?

对于XLSX，显然您可以使用RMS SDK来处理加密的XLSX存储格式. http://msdn.microsoft.com/en-us /library/aa767782(VS.85).aspx

for XLSX apparently you can use the RMS SDK to work with encrypted XLSX storage format. http://msdn.microsoft.com/en-us/library/aa767782(VS.85).aspx

尽管它只是一个几乎没有代码示例的规范，所以很幸运. 一旦访问了基础xml，就可以使用.net或java中的标准xml名称空间来处理文件.

Looking at it though its just a spec with almost no code samples so best of luck with that. once you have access to the underlying xml you can use standard xml namespace from .net or java to work with the file.

2003(XLS)格式，除非您使用支持编程访问(不知道任何特定产品)的第三方第三方供应商解决方案，否则您会走运.

2003 (XLS) format, unless you use a propietrary 3rd party vendor solution that supports programmatic access (not aware of any specific products) you are out of luck.

这篇关于Excel密码删除的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！