SetExcelFile="E:\logininfo.xls"
Call datatable.AddSheet("login_check")
Call datatable.AddSheet("transferinfo")
Call datatable.ImportSheet(SetExcelFile,"login_check","login_check")
Call datatable.ImportSheet(SetExcelFile,"transferinfo","transferinfo")
'得到某个sheet的行数
sheetcount =DataTable.getsheet("login_check").GetRowCount
Reporter.ReportEvent 0,"sheetnumber" ,"there are "&sheetcount&" sheets in the sheet"