Where as Apache POI supports both Excel 2003 - xls and Excel 2007 - xlsx file formats. It only supports the old BIFF (binary) '.xls' format. You can also consider using Apache Poi Library to perform read and write operations with excel sheets because of its better documentation, more features, active development, and Excel 2007+ format support.Īs we know JXL doesn't support Excel 2007 '.xlsx' file format. In this article, we will discuss how to access workbook, sheet and a Cell using Jxl library Download jxl jar and add it to build path. Normally, to read a data in excel, first we should have access to workbook, sheet which we want to read as workbook contains multiple sheets and if you want to read a particular cell we need location of a Cell.
