OleDbConnection连接Excel时,Excel加了密码,请教连接字符串怎么写
发布网友
发布时间:2022-09-06 19:27
我来回答
共2个回答
热心网友
时间:2024-10-20 08:13
Microsoft.Jet.OLEDB.4.0不支持带密码的excel文件
http://support.microsoft.com/kb/257819
原文中写了
On the Connection tab, browse to your workbook file. Ignore the "User ID" and"Password" entries, because these do not apply to an Excel connection. (Youcannot open a password-protected Excel file as a data source. There is moreinformation on this topic later in this article.)
打开带密码的。你可以使用Workbooks.Open
http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.workbooks.open.aspx
热心网友
时间:2024-10-20 08:13
OleDb
连接加密excel代码提供