When you import an excel file into QTP table, values stored in first row become column names in QTP table.
For example, if your spreadshed contains these values:
where cell (1,1) contains a1, cell (3,2) contains b3 etc,
then after importing this spreadsheet into the datatable you get:
where cell (1,1) contains value a2, cell (2,2) contains b3 etc.
Values from the first row in the excel spreadsheet are used as column names in QTP datatable.
For example, if your spreadshed contains these values:
Code:
+------+------+------+------+
| A | B | C | D |
+------+------+------+------+
| a1 | b1 | c1 | d1 |
| a2 | b2 | c2 | d2 |
| a3 | b3 | c3 | d3 |then after importing this spreadsheet into the datatable you get:
Code:
+------+------+------+------+
| a1 | b1 | c1 | d1 |
+------+------+------+------+
| a2 | b2 | c2 | d2 |
| a3 | b3 | c3 | d3 |Values from the first row in the excel spreadsheet are used as column names in QTP datatable.