0

I am automating a webpage using selenium (Java). There is a scenario where on a click of a button an excel sheet gets opened up. I want to edit that opened excel sheet using Apache POI(Java).

I tried to search and got 2 hits but 1st solution is using C# and 2nd did not have any solution.

1. Solution using C#

2. No Solution

Community
  • 1
  • 1
Devendra
  • 113
  • 4
  • 2
    As far as I know, POI does not interoperate with any excel-viewers - it "just" provides methods for reading/writing files in the relevant formats. – Hulk Jan 05 '17 at 08:24
  • 2
    It's not possible to [edit files locked by Office with POI](http://stackoverflow.com/questions/40524341). How about adding a test handler to your page, which is activated via some request parameter or test user-id, so the excel file is not opened but downloaded and you do the modifications on the unlocked file? – kiwiwings Jan 05 '17 at 08:35
  • 1
    What you seems to want is COM automation using ActiveX `Excel` components. This is what [JACOB](http://danadler.com/jacob/) is for for example. – Axel Richter Jan 05 '17 at 09:29

0 Answers0