Apache POI is a popular API that allows programmers to create, modify, and display MS Office files using Java programs. It is an open source library developed and distributed by Apache Software Foundation to design or modify Microsoft Office files using Java program. It contains classes and methods to decode the user input data or a file into MS Office documents
Using POI, one should be able to perform create, modify and display/read operations on following file formats
JXL is a third-party framework designed for Selenium that supports data driven automation on web browsers (auto-update of data on web browsers). However it is also used as a common support library for JExcel API because it has basic features to create, read, and write spreadsheets. The basic features are as follows:
• Generate Excel files
• Import data from workbooks and spreadsheets
• Obtain the total number of rows and columns
Note : JXL supports only .xls file format and it cannot handle large data volume.