Forum Discussion

AnushaD's avatar
AnushaD
Occasional Contributor
3 years ago

How to write values back to excel that are generated in the web application for consecutive requests

Hello,   I am facing one complicated issue. Using TestComplete I would like to write back multiple values to excel file by processing consecutive requests without any manual intervention. For examp...
web testing
rraghvani's avatar
rraghvani
Champion Level 3

See Excel Object which has example code for reading and writing.

 

For example, you can create a function to read a value at position row and column, do the process, and then write back at position row and column (based on using the same spreadsheet)

AnushaD's avatar
AnushaD
Occasional Contributor
3 years ago

Hi Rraghavani,

 

I tried this way already but it didn't work for me. Need some more pre-sized code. 

 

Thanks.

  • rraghvani's avatar
    rraghvani
    Champion Level 3
    3 years ago

    Do you want to read and write to the same cell in the spreadsheet? Are you able to provide an example of what your spreadsheet data looks like, and what values to read and what values to write? What does your data loop look like?