关于获取 Excel 中Sheet名字

anetfish 2004-07-10 09:39:43

我的做法是这样的:
ComboBox2->Items->Add(tmpWorkBook.OlePropertyGet("Sheets", i).OlePropertyGet("Name"));

可是获得的Sheet名字全是"Sheet1,Sheet2...."之类,而实际上的Sheet名字已经改成别的,还请各位高手指教,谢谢.

...全文

180 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

ccrun.com 2004-07-12

打赏
举报

http://www.ccrun.com/doc/go.asp?id=529

jxhywdh 2004-07-12

打赏
举报

connstr="Provider=Microsoft.Jet.OLEDB.4.0;User ID=admin;Extended Properties=excel 8.0;Persist Security Info=False;Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=35;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;";

connstr=connstr+"Data Source="+Edit2->Text;

ADOConnection1->ConnectionString=connstr;
ADOConnection1->Connected=true;
//下而这句得到表名
ADOConnection1->GetTableNames(ComboBox1->Items,true);

anetfish 2004-07-11