如何根据条件将数据从excel导入到UFT [英] How to import data from excel to UFT based on condition

问题描述

我有一个excel表，其中包含测试用例的数据，每个测试用例由列值分隔，表示脚本ID，而我只想加载脚本ID = 1的行。我们可以用DataTable.ImportSheet方法来实现这一点，因为这个方法导入所有的行都有脚本id = 2和3

我也尝试使用查询字符串，那是正常工作，但是我想通过DataTable.ImportSheet方法（项目约束）实现这一点。

感谢
阿曼

解决方案

您也可以手动创建数据表。

例如，

 设置myxl = createobject（excel.application）
 myxl.Application.Visible = true 
 myxl.Application.DisplayAlerts = false 
 myxl.Workbooks.Open DataSheetFilePath 
 set sheet = myxl.ActiveWorkbook.Worksheets（SheetName）
 Row = sheet.UsedRange.Rows.Count 
 Col = sheet.UsedRange.Columns .Count 
'先创建数据表
 Datatable.AddSheet（DataTableName）
设置ParameterTable = datatable.GetSheet（DataTableName）
'从Excel $ b $添加列b对于j = 1到Col 
 ParameterTable.AddPar ameter sheet.cells（1，j）.value，
 Next 
 
'开始在Excel中搜索
'假设ID列将为1 
 DataTableRow = 1 
对于i = 1到Row 
如果sheet.cells（i，1）.value = 1然后
'将行记录添加到datatable 
 ParameterTable.SetCurrentRow（DataTableRow）
对于j = 1到Col 
 ColName = sheet.cells（1，j）.value 
 Val = sheet.cells（i，j）.value 
 datatable.Value（ColName ，DataTableName）= Val 
 DataTableRow = DataTableRow + 1 
下一个
结束如果
下一个
  

I have an excel sheet which contain data for test cases and each test cases is separated by a column value say script ID and i want to load only row where script ID =1 . How we can achieve this with DataTable.ImportSheet method as this method import all the row having script id=2 and 3

I also try with query string and that is working fine , but i want to achieve this by DataTable.ImportSheet method (project constraints)

Thanks Aman

解决方案

You can also do it by creating data table first manually.

For example,

Set myxl = createobject("excel.application")
myxl.Application.Visible = true
myxl.Application.DisplayAlerts = false
myxl.Workbooks.Open DataSheetFilePath
set sheet = myxl.ActiveWorkbook.Worksheets("SheetName")
Row=sheet.UsedRange.Rows.Count
Col=sheet.UsedRange.Columns.Count
'Create Data table first
Datatable.AddSheet ("DataTableName")
Set ParameterTable = datatable.GetSheet("DataTableName")
'Add cols from Excel
For j = 1 To Col
    ParameterTable.AddParameter sheet.cells(1,j).value,""
Next

'Begin search in Excel
'Suppose the ID column will be 1
DataTableRow = 1
For i = 1 to Row
    If sheet.cells(i,1).value = 1 Then
        'Add row record to datatable
         ParameterTable.SetCurrentRow (DataTableRow)
         For j = 1 to Col
         ColName = sheet.cells(1,j).value
         Val = sheet.cells(i,j).value
         datatable.Value(ColName,"DataTableName") = Val
         DataTableRow = DataTableRow+1
         Next
    End If
Next

这篇关于如何根据条件将数据从excel导入到UFT的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！