如何使用oledb ...打开受密码保护的Excel文件? [英] How to open Password Protected Excel File using oledb...?

问题描述

我使用oledb连接与Excel File进行交互，但是当我当时使用受密码保护的Excel文件时，上述连接字符串不起作用..

请建议我进行连接，以帮助我打开受密码保护的Excel文件..

我的连接字符串...

I used a oledb connection for interation with Excel File, but when i used a password protected excel file at that time the above connection sting is not working..

please suggest me a connection sting that will help me to open a password protected excel file..

My Connection String...

conString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FilePath + ";Extended Properties=Excel 8.0";

推荐答案

此处是有关CP的文章，可帮助您解决此问题:

使用Visual Studio .NET自动化MS Excel [

Here is an article on CP which would help you out on this:

Automating MS Excel Using Visual Studio .NET[^]

这篇关于如何使用oledb ...打开受密码保护的Excel文件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！