Apache POI, using both XSSF and HSSF

java apache apache-poi xssf hssf
Tim Tuckle picture Tim Tuckle · Nov 24, 2010 · Viewed 34.5k times · Source

I have a problem with Apache POI project.

I failed to use XSSF and HSSF in the "Same Java Class". Which jar should I download or which artifact should I get add into maven?

I want to handle both xls and xlsx files at the same time. When I get excel version error, I will change the XSSF to HSSF or HSSF to XSSF.

How can I do this?

Answer

evilReiko picture evilReiko · Nov 24, 2010

Instead of doing that, try using the new release of Apache POI 3.7, it has SS package which handles both HSSF and XSSF without worrying about type

Details here: http://poi.apache.org/spreadsheet/index.html

Related questions

Apache POI error loading XSSFWorkbook class

I'm trying to write a program that works with Excel docs, but the HSSF format is too small for my requirements. I'm attempting to move to XSSF, but I keep getting errors when trying to use it. I managed to …

Read More
Apache POI XSSF reading in excel files

I just have a quick question about how to read in an xlsx file using the XSSF format from Apache. Right now my code looks like this: InputStream fs = new FileInputStream(filename); // (1) XSSFWorkbook wb = new XSSFWorkbook(fs); // (2) XSSFSheet sheet = wb.…

Read More
How to get the position/index of a Sheet object in Java Apache POI

In a Java method I am using an Apache POI Sheet (from XSSFWorkbook). I can read the sheet name using getSheetName() method. But is there any way to find the sheet position in the workbook. I don't see any methods …

Read More