Stack Overflow
Stack Overflow

Questions tagged [poi-hssf]

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

The POI-HSSF tag is used for Apache POI Project's Java API for manipulating Excel format files (.xls and .xlsx).

HSSF is the POI Project's pure Java implementation of the Excel '97(-2007) file format. XSSF is the POI Project's pure Java implementation of the Excel 2007 OOXML (.xlsx) file format.

This tag should be used for questions around using and extending Apache POI HSSF.

More information on HSSF, the bug tracker and download links are available from http://poi.apache.org/spreadsheet/index.html

If you are starting with Apache POI, you may find the Busy Developer's link very useful: http://poi.apache.org/spreadsheet/quick-guide.html

165 questions
0
votes
0 answers

Excel Sheet reading (Particular cell)?

How to read certain text font (for specific subscript, superscript uppercase lowercase, italic bold etc.) in a particular cell's. (Not for complete cell, or not to set that format for complete cell)? like for Example: I have a cell in a spreadsheet…
pfflet
  • 1
  • 1
0
votes
2 answers

Does CELL_TYPE_BLANK works for hssf or xls files?

I wanna ask that does CELL_TYPE_BLANK works for hssf or xls file system? I knw it works for xlsx or XSSF but i'm having problem with xls?
v0ld3m0rt
  • 866
  • 3
  • 12
  • 47
0
votes
1 answer

HSSF. Clear the cell

sheet.setColumnWidth(13,(short)0); totally different row.removeCell(13); doesn't work too. What I should use for this goal?(delete cell)
Eldar
  • 13
  • 1
  • 8
0
votes
1 answer

Getting wrong output in xls/xlsx while converting it from csv

So i've changed a csv to xls/xlsx but i'm getting one character per cell. I've used pipe(|) as a delimiter in my csv. Here is one line from the…
v0ld3m0rt
  • 866
  • 3
  • 12
  • 47
0
votes
3 answers

Java. HSSF. Apache-poi. How to modificate code

My data is stored in a format(look down): [-] means a blank cell, on the right may be only 10 columns, after the space. Something like this: [string0] [-] [string1] [string2] [string3] .. [string10] [-] How to change this code for: 1)…
Eldar Nezametdinov
  • 1,917
  • 4
  • 21
  • 23
0
votes
1 answer

Date representation in csv file is to be changed

When i convert xls/xlsx to csv than in that csv file date is coming as Fri Nov 11 00:00:00 IST 1988. But i need yyyy-mm-dd format. What can i do in the following code: [code] row = (HSSFRow) rowIterator.next(); // For each…
v0ld3m0rt
  • 866
  • 3
  • 12
  • 47
0
votes
1 answer

get complete address of a file

i need to get the full address of a file which needs to be uploaded by the user using browse button. i tried getAbsolutePath, getAbsoluteFile, getCanonicalPath but they all are giving tomcat/bin location. i need the full path of the file which is to…
v0ld3m0rt
  • 866
  • 3
  • 12
  • 47
0
votes
1 answer

HSSFCell MissingCell Policy Issue

I am trying to read excel both(.xls and .xlsx) using java. I was able to read xlsx properly. But when I am reading xls file with the following code final HSSFCell cell = row.getCell(i, Row.RETURN_BLANK_AS_NULL); I am getting error…
Amar
  • 421
  • 1
  • 6
  • 17
0
votes
1 answer

[Java][POI]Insert EMF image into HSSFWorkbook

i'm trying to insert a EMF image into HSSFWorkbook(apache poi 3.9). But when i open the result document - i catch an error of content. I'm looking for solution of problem and found the letter on apache…
user2078222
  • 135
  • 10
0
votes
1 answer

Extracting charts from Excel documents using POI or HSSF?

I've got a bunch of Excel documents that have data on one sheet and a chart produced from the data on another sheet. I'd like to take those documents and produce a series of HTML pages from them. Using POI (or HSSF) know I can read the data from the…
hofo
  • 522
  • 1
  • 4
  • 16
0
votes
2 answers

Parsing number from excel using java

I have a code that will gather a number from excel file and store it into DB MySql. String P01_PickModul = row.getCell(13).getStringCellValue(); The problem is i can not gather the number with more decimal, for example 1.04166666666667 I set the…
Nataniel Depo
  • 1
0
votes
1 answer

How to get height and width of excel sheet"named index" area from HSSFWorkbook POI API

How to get height and width of excel sheet named range area from HSSFWorkbook POI API. I got one reference from google but not able to get height and width of named index area of excel sheet. Thanks in advance. Yes it's named range, and want height…
Vinayak
  • 155
  • 2
  • 2
  • 9
0
votes
1 answer

apache-poi inserting filename in header or footer

I'm using the apache poi library (poi-3.8-20120326.jar) How can I add the filename in the footer of an xls (hssf) document? My approach is the following: final static public String FILE_NAME = "&[File]"; public static void insertFilename(Sheet…
MemLeak
  • 4,456
  • 4
  • 45
  • 84
0
votes
1 answer

Insert a checkbox in an Excel sheet using Apache POI

I want to pragmatically insert a number of checkbox in different cells. I want to keep a reference for each one in order to read them later on after the user check or uncheck. Can I do that in Java POI ? if not what is other alternatives to do…
user1912404
  • 386
  • 4
  • 11
  • 26
0
votes
0 answers

How to get hold of an excel sheet by its name using Apache POI

I have a .xls file which is auto generated through some process. There is only 1 sheet(with a name) in the workbook. When i use the following code, it is not getting hold of the sheet HSSFSheet sheet = workbook.getSheetAt(0); But when i copy the…
Surya Chandra
  • 1,561
  • 5
  • 27
  • 42
1 2 3
…
10
11