Write to MS Excel DDT

Question

Set DT_Sheet = DDT.ExcelDriver(InputFilePath, "XYZ_DT", true)

While Not DT_Sheet.EOF()

DT_Sheet.Value("TestData") = "Test"

DT_Sheet.Next()

Wend

DDT.CloseDriver(DT_Sheet.Name)

I get an error message on line - DT_Sheet.Value("TestData") = "Test" "wrong number of arguments or invalid property assignments"

could someone pls hlp how to write value to MS Excel using DDT

joseph_michaud · Accepted Answer

Check out some examples at
&nbsp;
Write data to MS Excel
Is it possible to read data from an Excel sheet?
&nbsp;

tristaanogre · Answer

The DDT object and related drivers is for reading from the files, not for writing, as they are designed for driving tests based upon input from external data sources.

As noted above, you'll want to use other mechanisms for actually writing output to an Excel sheet.

Forum Discussion

Write to MS Excel DDT

2 Replies

Related Content

Excel-Write value

Excel read and write using DDT

Excel DDT

Fetch the row count in DDT driver

How to write into excel file using Javascript?

Recent Discussions

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

testcomplete feature Intelligent Quality Add Ons