Forum Discussion

MatthewB's avatar
MatthewB
Occasional Contributor
12 months ago

Not able to grab data from Excel using TestComplete with wrapped text using Excel.Open("filename")..

We are using the Excel.Open("FileName").SheetByIndex(0).Cell("A",6).Value to grab data from excel.  The method works overall, but does not capture the wrapped text from Excel.  The result of the data...
Desktop Testing
A_Roskoshnyi's avatar
A_Roskoshnyi
Contributor

Try some modify your code:

var excel = Sys.OleObject("Excel.Application");
excel["Workbooks"].Open(path_to_excel_file);
excel["Sheets"](name_of_sheet).Select();

//Get value from cell with rowIndex = 6, columnIndex = 1
var text_from_cell = aqConvert.VarToStr(excel["Cells"](6,1));
MatthewB's avatar
MatthewB
Occasional Contributor
12 months ago

We are trying to not have Excel loaded onto the VM and use the Excel method from SmartBear.  We have already used the "Excel.Application" before and it was working.