Forum Discussion

abhishek813's avatar
abhishek813
Frequent Contributor
14 years ago

updating existing excel

Can anyone tell me how to update an existing excel file? I have code to read an existing excel file and code to write to a new file but i do not know enough groovy to combine the two and come up with a code that reads an excel and update it too..

can anyone help me with this?

-AB

5 Replies

Sort By
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    SmartBear Alumni (Retired)
    14 years ago
    Hello,

    The tools available in soapUI PRO for dealing with Excel files are the DataSource and DataSink TestSteps, which allow for reading from and writing to Excel files, in a loop based fashion. If these do not meet your needs, you can use Groovy to extend the functionality of soapUI by integrating a third party library which handles excel files, such as JExcel for example. For support on using a third party library, you will have to consult the documentation for that particular library. Good luck!

    Regards,
    Dain
    eviware.com
  • abhishek813's avatar
    abhishek813
    Frequent Contributor
    13 years ago
    Thanks Dain. I have made use of the JXL API and i can now successfully read and write to excel 97-2003.

    -Abhishek