我可以使用C#OLEDB来访问具有密码的excel文件吗? [英] Can I use C# OLEDB to Access a excel file with password?

问题描述

我需要使用C#OLEDB来访问带有密码的远程服务器中的excel文件.

I need to use C# OLEDB to access an excel file with password in a remote server .
Is there any good idea for me?

推荐答案

在这里 [^ ].其中一些连接字符串可能对您有用.

Have a look here[^]. Some of these connection strings might be useful to you.

> Abhinav S
非常感谢！

我发现如果Excel工作簿受密码保护，则即使为连接字符串提供正确的密码，也无法打开它进行数据访问.如果尝试，则会收到以下错误消息:无法解密文件."

>Abhinav S
Thank you very much!

I found "If the Excel workbook is protected by a password, you cannot open it for data access, even by supplying the correct password with your connection string. If you try, you receive the following error message: "Could not decrypt file."

这篇关于我可以使用C#OLEDB来访问具有密码的excel文件吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！