Top "Poi-hssf" questions

HSSF is the Apache POI project's Java API for manipulating Excel format files (.xls and .xlsx)

Adding border to a merged region in POI XSSF workbook

I'm using apache poi 3.7 and I need to put border to a range of cells or merged region. how can …

java apache-poi xssf poi-hssf
Creating excel sheet from template in Java, new versions of Excel

I found the following code to create a excel sheet from an existing template with formats and add data to …

excel apache-poi xssf poi-hssf excel-template
Delete an excel sheet using Apache POI

I have to delete a sheet from the Excel file. Here's my code snippet : FileInputStream fileStream = new FileInputStream(destFile); POIFSFileSystem …

java apache-poi poi-hssf
javac: package org.apache.poi.hssf.usermodel does not exist

I have a program attempting to use classes from the jakarta-poi-3.0.2.jar in my /usr/share/java directory: import org.…

java apache-poi poi-hssf
How to know number of sheets in a workbook?

I'm using hssf api for reading data from xls files. But is there any way to get the exact no. …

java excel apache-poi poi-hssf vba
java.lang.IllegalArgumentException: Your InputStream was neither an OLE2 stream, nor an OOXML stream

When I'm reading Excel file(.xls format), I keep getting an Exception : java.lang.IllegalArgumentException: Your Input Stream was neither …

java xls xssf poi-hssf
How can we read protected password excel file (.xls) with POI API

I've just learned POI and find the HSSF is very simple to read and create excel file (.xls). However, I …

apache-poi poi-hssf
HSSF POI : How to know if data in cell is of Type Date?

Currently i have my code as bean.setREPO_DATE(row.getCell(16).getDateCellValue()); it works fine if cell is formatted as …

java apache-poi poi-hssf
Exception in thread "main" java.lang.IllegalArgumentException: Sheet index (0) is out of range (0..-1)

i want to read the 2010 excel file in java using apache poi api ... but it gives me an error Exception …

java excel poi-hssf xssf
POI / Excel : applying formulas in a "relative" way

I'm using Apache's POI to manipulate Excel (.xls) files with Java. I'm trying to create a new cell whom content …

java excel apache-poi poi-hssf