cancel
Showing results for 
Search instead for 
Did you mean: 

Excel read and write using DDT

SOLVED
Highlighted
Contributor

Excel read and write using DDT

Hi,

 

Can any one please provide complete code for excel reading and wrinting using testcomplete + Java Script.Since i am new to this tool dont know how to go ahead with this.

 

Regards,

Naveen

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Hero

Re: Excel read and write using DDT

I would start with the documentation: https://support.smartbear.com/testcomplete/docs/testing-with/advanced/working-with-external-data-sou...

 

And then let us know if you run into any roadblocks.


Thanks,
Carson

Click the Accept as Solution button if my answer has helped

View solution in original post

2 REPLIES 2
Highlighted
Community Hero

Re: Excel read and write using DDT

I would start with the documentation: https://support.smartbear.com/testcomplete/docs/testing-with/advanced/working-with-external-data-sou...

 

And then let us know if you run into any roadblocks.


Thanks,
Carson

Click the Accept as Solution button if my answer has helped

View solution in original post

Highlighted
Community Hero

Re: Excel read and write using DDT

Note that the DDT object only allows reading.  The assumption is that you are using the Excel sheet to read through data records to be used in processing a data driven test.  Any output to be written would need to be written to a separate copy of the file using Sys.OleObject('Excel.Application') as per the link @cunderw posted.


Robert Martin
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Vegas Thrill Rider
Extensions available
New Here?
Join us and watch the welcome video:
Announcements
Join TechCorner Challenge!
Want a fun and easy way to learn TestComplete? Try solving weekly TechCorner challenges and get into the Leaderboard!

Challenge Status

How to execute remote test and obtain results via Test Runner REST API

Participate!

Comparing content of HTML table with Excel file data

Participate!

Compare HTML table with Excel file and correct data in the file

Participate!

Retrieve Data from a Web Page

Participate!
Top Kudoed Authors