Forum Discussion

Contributor

7 years ago

Solved

How to read Excel cell values in JavaScript

Hi, I'd like to read cell values from Excel using JavaScript. Once opening Excel via TestComplete, I tried the following without luck: currentCellValue = mysheet.Cells.Items(i,3).Value2...

Marsha_R
7 years ago
This link may be helpful:

https://support.smartbear.com/testcomplete/docs/testing-with/advanced/working-with-external-data-sources/excel/reading-data-with-ddt-drivers.html

Marsha_R

Champion Level 3

This link may be helpful:

https://support.smartbear.com/testcomplete/docs/testing-with/advanced/working-with-external-data-sources/excel/reading-data-with-ddt-drivers.html

BrandonH

Contributor

7 years ago

Thanks Marsha_R,

That helped and I'm able to use that to locate data within the Excel file.

Recent Discussions

Azure Devops Integration supports Testcomplete Base Fixed Dektop Module License
3 hours agoGane195
Devops integration support
3 hours agoGane195
TestComplete14.72 is not recognizing WinUI-3 objects
16 hours agoKiranGanji
testcomplete feature Intelligent Quality Add Ons
3 days agotshepo_jiki
Floating window **bleep** overlapping window takes longer time (~10 min) to click the button on it.
4 days agoscho1

Forum Discussion

How to read Excel cell values in JavaScript

Related Content

Excel-Write value

Read excel data/links in javascript test complete

How to write into excel file using Javascript?

JavaScript API for Excel sheet

JavaScript runtime error. ReferenceError: Excel is not defined

Recent Discussions

Azure Devops Integration supports Testcomplete Base Fixed Dektop Module License

Devops integration support

TestComplete14.72 is not recognizing WinUI-3 objects

testcomplete feature Intelligent Quality Add Ons

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