How to write to the SAME excel sheet using JXL API

2019-02-21 05:25发布

问题:

I have an excel sheet (located in classpath), which has scenarios to be read and executed.

Once they are executed, I should write back to the SAME excel sheet saying whether the scenario is PASS'ed or FAIL'ed.

How can this be accomplished?

(NOTE: I am able to read the excel).

回答1:

I guess the only way is to create a temporary file of the original file and read the temporary file. Do the validations. Open the original file for writing and display the error message. Finally delete the temporary file :-)