Forum Discussion

iamraj09's avatar
iamraj09
Contributor
10 years ago
Solved

How to read and write on the same excel file simultaneously

Hello Everyone,   Right now, I am working on few test cases... where it reads the data from an excel and update the results on to the excel file.    Requirement is: It should read the test input...
  • mes6073's avatar
    10 years ago

    I think you need to use the 'SaveAs' method passing in the name of the existing Excel workbook.

    Book["SaveAs"]("c://temp//sample//TEST.xls");