Multithreading in excel

[vishwas shenoy]

Hi, We use excel file to read and write our test data (data driven framework) in Selenium.

We use Apache POI to do this.

But as you all know, Apache POI library does not support multithreading(especially when writing the data). This is stopping us from using Selenium grid's multithreading capability. 

In our test script, we scrape data from the application and store it in excel for validating it later. so we do a lot of write operation to excel.

Storing in Java memory is not an option as we need this data to be shared with other stakeholders post validation. So we need to print it to excel.

Do we have any alternatives for POI library? People who use selenium grid, how do you overcome this issue if you are using excel for storing the data?

[⇜Krishnan Mahadevan⇝]

Selenium's grid capability and excel thread safety ? I dont quite understand the connection.

All said and done, there are many ways in which you can solve this problem. The easiest of them being Build a synchronized utility that ensures mutual exclusion of threads when it comes to read/write into excel.

Thanks & Regards
Krishnan Mahadevan

"All the desirable things in life are either illegal, expensive, fattening or in love with someone else!"
My Scribblings @ http://wakened-cognition.blogspot.com/

My Technical Scribblings @ https://rationaleemotions.com/

--
You received this message because you are subscribed to the Google Groups "Selenium Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to selenium-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/selenium-users/0c1cc9f0-4d2c-468d-a868-08f2f1ea370c%40googlegroups.com.