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?
Can we write data into excel using DDT excel driver? Or Can data be written only by creating Excel object?
Forum Discussion
3 Replies
- 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" - TanyaYatskovska
Alumni
- i was going to ask about google spreadsheets but found this
https://developers.google.com/google-apps/documents-list/#what_can_this_api_do
