Stack Overflow
Stack Overflow

Questions tagged [xssf]

XSSF provides Java APIs to read / write Microsoft Excel 2007 (OOXML format .xlsx) files. This tag should be used for questions about accessing Excel 2007 files from Java applications. XSSF is managed under the Apache POI Project. Other tag to consider: [tag:apache-poi]

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.

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

Useful links

488 questions
11
votes
1 answer

Does POI XSSF still have crazy bad memory issues?

A couple years ago, I ran into issues where I was creating large excel files using jXLS and POI XSSF. If my memory is correct, I think XSSF would create something like 1GB+ temp files on the disk to create 10mb excel files. So I stopped using jXLS…
Bob Thule
  • 691
  • 9
  • 15
11
votes
4 answers

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 I to apply border to a merged region when the sheet and workbook type is XSSF. In HSSF type I use RegionUtil-/HSSFRegionutil, but if use the first…
Charlessmori
  • 217
  • 2
  • 3
  • 10
11
votes
2 answers

XSSFWorkbook takes a lot of time to load

I am using the following code: File file = new File("abc.xlsx"); InputStream st = new FileInputStream(file); XSSFWorkbook wb = new XSSFWorkbook(st); The xlsx file itself has 25,000 rows and each row has content in 500 columns. During debugging, I…
London guy
  • 27,522
  • 44
  • 121
  • 179
10
votes
8 answers

Get String value, when I read from excel with Date type (apache poi)

I have an xlsx file that I am reading with - Apache POI Library. For example, In some row, I have such cells values: 01-Sep-13 | 15136.00| Matt|...... My goal is: Read all cells in the rows as String values. But as I see, I can't read…
Sergii Lisnychyi
  • 477
  • 4
  • 10
  • 16
10
votes
3 answers

setting cell style not working

i'm working with apache poi and XLSX file. i use xssf classes to dynamically create a spreadsheet. i'd like to set cell's style in a for loop, but it doesn't seem to work...here's my code : for(int…
Medioman92
  • 581
  • 4
  • 10
  • 21
9
votes
2 answers

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 it and save it to a new file POIFSFileSystem fs = new POIFSFileSystem( new FileInputStream("template.xls")); HSSFWorkbook wb = new …
cma3982
  • 91
  • 1
  • 1
  • 3
9
votes
2 answers

XSSF POI is cell date

Is there a way to determine if cell is a date? I know about style.getDataFormatString() but that doesn't help me, because I can't determine if is formating is for date or not.
Zemzela
  • 3,060
  • 6
  • 23
  • 32
9
votes
3 answers

Java POI XSSF VLookup formula

I am trying to put simple VLookup formula in my ".xlsx" file using Java and Apache POI. This formula is having the external reference and that is NOT working for me. So to give you more details I am using poi and poi-ooxml version 3.13 and excel…
ManishChristian
  • 3,759
  • 3
  • 22
  • 50
9
votes
1 answer

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 an OLE 2 stream, nor an OOXML stream. I Go-ogled and found that if the input stream is not supporting reset or…
mee
  • 821
  • 5
  • 12
  • 28
8
votes
4 answers

Apache POI, using both XSSF and HSSF

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…
Tim Tuckle
  • 1,372
  • 7
  • 21
  • 31
8
votes
5 answers

NoSuchFieldError when reading Excel sheet in java

I've followed a simple guide to constructing a workbook using Apache POI XSSF. Following the same guide I was able to WRITE an Excel sheet, however when attempting to read from one, I'm receiving the error displayed after the code. Code: try { …
William Tolliver
  • 305
  • 1
  • 2
  • 16
8
votes
2 answers

Create new or clone XSSFCellStyle from another XSSFCellStyle (POI APACHE)

Requirement I need a new XSSFCellStyle because I have to change some stylings. Situation I only have a XSSFCellStyle - I don't have the XSSFCell it belongs to. Thus I also don't have access to the related XSSFSheet or XSSFWorkbook. What I already…
winklerrr
  • 13,026
  • 8
  • 71
  • 88
8
votes
2 answers

How to resolve the java.lang.VerifyError: org/apache/poi/xssf/usermodel/XSSFWorkbook?

I'm trying to read the xlsx file from asset folder. I received below exception, 05-16 10:12:05.613: E/AndroidRuntime(2915): FATAL EXCEPTION: main 05-16 10:12:05.613: E/AndroidRuntime(2915): java.lang.VerifyError:…
bharath
  • 14,283
  • 16
  • 57
  • 95
8
votes
1 answer

XSSF (POI) - Adding "formula" column to pivot table

I am using POI 3.12-beta1: org.apache.poi poi 3.12-beta1 org.apache.poi …
anonymous
  • 657
  • 1
  • 8
  • 21
8
votes
1 answer

Creating cell comments in apache poi (for .xlsx files) with show comments disabled

I am trying to create cells comments using apache poi. I am able to create the comments, but by default they are always displayed in excel. I have to manual right click on the cell and un-tick show comments to make them invisible(now they appear…
Paroksh Saxena
  • 213
  • 4
  • 7
1
2
3
…
32 33