[ADO Excel]如何使用ADO检索Excel工作表名称和一些信息 [英] [ADO Excel] How to use ADO retrieve Excel Worksheet name and some information
问题描述
我想检索Excel工作表名称和工作表总数
检索Excel工作表名称和总计数sheet是Excel.Application,但不是AdoDb:
Dim mExcel作为新Excel.Application,wb作为Workbook,ws作为工作表,YrXlsFilNam作为字符串
YrXlsFilNam =" ...."
设置mExcel.workbooks.open(YrXlsFilNam)
debug.print wb.worksheets.count
wb.worksheets中的每个ws
debug.print ws。命名,点击下一个结果
I want to retrieve Excel worksheet name and total count of sheets
To retrieve Excel worksheet name and total count of sheets is by Excel.Application, but not by AdoDb:
Dim mExcel as new Excel.Application, wb as Workbook, ws as worksheet, YrXlsFilNam as string
YrXlsFilNam = "...."
set mExcel.workbooks.open(YrXlsFilNam)
debug.print wb.worksheets.count
for each ws in wb.worksheets
debug.print ws.name
next
这篇关于[ADO Excel]如何使用ADO检索Excel工作表名称和一些信息的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!