odbc如何操作带密码的excel文件？

[pengxiao8]

CDatabase database;
CString sSql;
CString sItem1, sItem2;
CString sDriver;
CString sDsn;
CString sFile,sPath;


GetModuleFileName(NULL,sPath.GetBufferSetLength (MAX_PATH+1),MAX_PATH);
sPath.ReleaseBuffer ();
int nPos;
nPos=sPath.ReverseFind ('\\');
sPath=sPath.Left (nPos);

sFile = sPath + "\\Demo.xls";

sDriver = GetExcelDriver();
if (sDriver.IsEmpty())
{


return;
}

sDsn.Format("ODBC;DRIVER={%s};DSN='';DBQ=%s", sDriver, sFile);

TRY
{

database.Open(NULL, false, false, sDsn);

CRecordset recset(&database);


sSql = "SELECT Name, Age "
"FROM Exceldemo " ;
"ORDER BY Name ";


recset.Open(CRecordset::forwardOnly, sSql, CRecordset::readOnly);


while (!recset.IsEOF())
{

recset.GetFieldValue("Name", sItem1);
recset.GetFieldValue("Age", sItem2);


m_ExcelList.AddString( sItem1 + " --> "+sItem2 );


recset.MoveNext();
}


database.Close();

}
CATCH(CDBException, e)
{

AfxMessageBox("cuo wu: " + e->m_strError);
}
END_CATCH;


以上代码可以正常运行，但对有密码的文件不行，请问如何修改？

[kingstarer]

会不会跟操作数据库一样，要加上user和pass?

[pengxiao8]

User Id怎么写？

[CathySun118]

打开方式参考:
m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test.xls;User Id=***;Password"=***","","",adModeUnknown);

***改成你的用户名、密码

[内存泄漏]

好像没有办法操作有密码的,ACCESS可以,参考:

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."

http://www.connectionstrings.com/?carrier=excel

[scq2099yt]

打开excel时有一个参数是表示密码的

[waitforsomebody]

不是user和password，好像是有一个database password的属性，前两个属性置空就行，你可以试试

[内存泄漏]

是Database Password属性,没有用的,JET不支持,仅支持ACCESS..

如ACCESS访问有密码的可如下操作,但EXCEL不行:
m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=true;Data Source=Demo.mdb;Jet OLEDB:Database Password=tyz","","",adModeUnknown);

[n_yHHy_n]

学习