Ask a Question

updating existing excel

abhishek813
Frequent Contributor

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
abhishekasthana.com
5 REPLIES 5
abhishek813
Frequent Contributor

Re: updating existing excel

no answer..!!?? this is the pro support forum isn't it?
abhishekasthana.com

Re: updating existing excel

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

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
abhishek813
Frequent Contributor

Re: updating existing excel

Thanks Dain. I have made use of the JXL API and i can now successfully read and write to excel 97-2003.

-Abhishek
abhishekasthana.com
Don
Contributor

Re: updating existing excel

If you can share how you accomplished this or share links that would be helpful.

 

Thanks

prashobkt
Contributor

Re: updating existing excel

check  StackOverflow link:

 

 http://stackoverflow.com/questions/9040647/groovy-and-poi-can-i-read-write-at-the-same-time
 

                                

 

/T3D
cancel
Showing results for 
Search instead for 
Did you mean: