Excel Comment

Question

Is there anyway to read Excel Comments using the builtin TestComplete excel functions?

I have used Excel for years in my scripts but was hoping to switch to the built in functions to eliminate the need of installing Excel on our test PC's. We have a custom log file format we use for saving test results and we store the test run results in an Excel comment. Any way to do this with TestComplete excel functions?

I am pretty sure the answer is "No" but wanted to double check.

rraghvani · Answer

The simple answer is no. However you can&nbsp;retrieve it using Excel COM server&nbsp;using something similar to&nbsp;Sheet1.Range("A1").Comment.Text. You could install&nbsp;Microsoft 365 Access Runtime?

Forum Discussion

Excel Comment

1 Reply

Related Content

Excel-Write value

Excel: how do you change sheet name in Excel file

All comments in feature file printed to console

Excel Overlap Issue

Verify Frozen columns in Excel

Recent Discussions

TestComplete14.72 is not recognizing WinUI-3 objects

Floating window bleep overlapping window takes longer time (~10 min) to click the button on it.

Test case randomly fails with "parent object was not found"

Does TC have a .within() method similar to Cypress.io?

SessionCreator /Timeout option not firing EventControl_OnTimeout