Write value into excel
Hi, Can we write data into excel using DDT excel driver? Or Can data be written only by creating Excel object?
Forum Discussion
Code looks like this -
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"
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"