JXL API (Java Excel API) is used for handling excel from different java applications. It is mostly used for selenium data-driven testing. Using this API ,users can read, write and update sheets in runtime.
Advantages of using JXL
- Users can read, write and modify data in Excel 95, 97, 2000, and 2003 spreadsheets.
- API methods are easy to understand.
- JXL APIs are capable of doing styling of cells, like shading, bordering, and colouring of cells.
Disadvantages of using JXL
.It does not support xlsx format.
. It does not support chart.
. It does not support password protection.
java jxl download link ->http://www.java2s.com/Code/Jar/j/Downloadjxljar.htm