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

Are you able to attach your Excel spreadsheet, so that I can have a quick look?

I think your Excel data seems to have a carriage return.

Log.Message() method will not display multiple lines.

If you try the code example from Excel.Open Method, and inspect the variable values in debug mode, it will contain the full value.

Also, avoid many Excel.Open methods like you have done - unless you are just showing an example of the issue.

Can you hover your mouse of the message, it should show a tooltip containing the entire string.

Do you expect that the variable should be able to store that value with the carriage return ?  We're trying to get the return value to compare it.

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));

Here is another file that shows the data.  

Using the same code as you have written, all the text is shown. I can see from the tooltip, that there is a carriage return in some of your cells.

Also, formula bar shows having carriage return in your data

And some cells don't

What version of TestComplete are you using?

Again, the read is read correctly

What version of TestComplete are you using?

Try to use ODBC to connect to Microsoft Office Excel data, using the connection string e.g. “Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file” - as I don't know what Excel.Open() method uses.

Now I'm getting this,

I'll try and figure out what the issue is.

ODBC doesn't require a license. It's a standard application programming interface (API) for accessing database management systems

Your spreadsheet uses Custom XML formatting, and using Excel.Open() method will not read the data correctly, as it's used for older spreadsheets i.e. .xls files. However, you can use the Excel COM server Excel.Application to correctly read the data instead as shown below.