Fun with Excel
Frankly, this is starting to look like a bug but I didn't want to jump the gun. I'm using a spreadsheet that has input and expected outputs in their respective columns. I'm taking the results ...
Forum Discussion
Hi,
Robert is right. If you get IDispatch as the value type, this represents the cell object. Use Excel.Cells(i, j+24).Value or .Text instead.
Also, it is a good practice to deal with cell properties which return its value instead of the cell itself. In most cases, the convertion can work automatically, and just 'Excel.Cells(...)' will work, but addressing the value explicitly is more reliable anyway.
Robert is right. If you get IDispatch as the value type, this represents the cell object. Use Excel.Cells(i, j+24).Value or .Text instead.
Also, it is a good practice to deal with cell properties which return its value instead of the cell itself. In most cases, the convertion can work automatically, and just 'Excel.Cells(...)' will work, but addressing the value explicitly is more reliable anyway.
