????12 GetSheetCount????
?????????????????????????е????????????
????????DataTable.GetSheetCount
???????????????
?????????
?????????????? GetSheetCount ???????????????????е??????????????????д???檔
????sheetcount = DataTable.GetSheetCount
????Reporter.ReportEvent 0?? "????????"?? "?????????" & sheetcount & "?????????
????13 Import????
????????????????? Microsoft Excel ??????????????????
???????
???????????????????????????????????????????е???????????????????????????????????????????
???????????? Excel ???????????б?????????????????????????????????????Щ????????????????????????????????????
????????DataTable.Import(FileName)
????FileName ??????? ?????? Excel ???????·????
?????????
????????????滻??????????????????????????????е??????????
?????????????? Import ?????? flights.xls ????????????????
????DataTable.Import ("C:flights.xls")
????14 ImportSheet????
????????????????????????????????????????????????????????????е???????滻????????е??????????? SheetDest ????????
???????
???????????????е??б???????????????????е???????????????????????????????????
???????????????????????????滻?????????????
???????????? Excel ???????????????б?????????????????????????????????????Щ????????????????????????????????????
????????DataTable.ImportSheet(FileName?? SheetSource?? SheetDest)
????FileName ???????????е???????? Excel ???????·????
????SheetSource ???? ??????????????????????????????????? 1 ?????
????SheetDest ?????????????? SheetSource ?滻?????????????????????????? 1 ?????
?????????
?????????????? ImportSheet ?????? name.xls ???????????????????????????????е?Action1???????
????DataTable.ImportSheet "C: ame.xls" ??1 ??" Action1"
????DataTable.ImportSheet "C: ame.xls" ??1 ??" Global"
????Qtp?в?????Global?????????????????