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
0
votes
1 answer

Unable to instantiate an object of XSSFWorkbook in Java servlet

I'm trying to work with XSSFWorkbook in my web application. I ran a sample application with XSSFWorkbook as a plain Java program (with public static void main(String args[])) - it runs fine - an excel sheet is generated. However, when I run the same…
Yogiraj Havinal
  • 13
  • 2
0
votes
2 answers

How can I free memory held by an XSSFWorkbook?

I have written some Java code that takes information from three spreadsheets and generates a large spreadsheet ( 10 columns, 26,950 rows ) on a machine with 4GB memory. It was crashing as it was generating the spreadsheet (out of memory), but by…
Simon
  • 3
  • 1
  • 3
0
votes
2 answers

get the column's header name

I have to read all the cells of any column with header name "ABCD". I can get the values iterated over to any row but am stuck with a situation to get the column header name. I can also get the column header name using the excel as database: String…
Kumar
  • 329
  • 2
  • 6
0
votes
1 answer

poi product function produces an unexpected floating point approximated value

I am using apache poi 3.10-FINAL version to read a couple of cell values and multiply. I am multiplying two cells, each with value 38.15 & 199.1, but the result is 7595.664999999999 instead of 7595.67 Is there a fix for this? is = new…
user915534
  • 39
  • 1
  • 4
0
votes
1 answer

SXSSFWorkbook (.xlsx file) can’t be viewed correctly on the mac

I had use XSSFWorkbook which was work fine in all device(even for MAC), But now i migrate on SXSSFWorkbook, So now i face one problem xlsx file not able to view on MAC In detail Question So how can i achieve this as like in XSSFWorkbook.
HybrisHelp
  • 5,518
  • 2
  • 27
  • 65
0
votes
4 answers

Displaying Date from Excel Sheet xlsx in Java

I have date saved as 24-Jun-13 in one of cell in Excel sheet(xlsx). While retriving it is showing me like 174-Jun-2013 The Code is String ret=""; if(c.getCellType()==Cell.CELL_TYPE_NUMERIC) { if(col==0) { …
Chaitanya
  • 81
  • 1
  • 1
  • 8
0
votes
1 answer

Adding Excel information to JTable, not creating new rows? (.xlsx) (JAVA)

I am using Apache POI and I am trying to pull information from a excel workbook (Understanding this is a .xlsx file, I am using XSSF from the POI.), and display it onto a JTable. However, I am seeing that this is not creating new columns. I have…
Redspart
  • 3
  • 1
  • 3
0
votes
1 answer

reading xlsx and import it

I am trying to create a class to read a XLSX file when I upload it to a website. I have the code to upload the file to the server. The file can be uploaded but it can't capture the data from the excel. May I know how do I solve or modify this code…
Cassie
  • 39
  • 11
0
votes
0 answers

Excel blank cells with XSSF POI

I'm trying to store dome data to an .xlsx excel file. The problem is that I can't write blank cells, even if I'm using row.createcell(). I get Null Pointer Excpetion errors, maybe it's because rows aren't initialized. Is there any way to initialize…
Emiliano Fraticelli
  • 39
  • 11
0
votes
1 answer

Unable to create Instance of XSSFWorkbook using poi-3.9 - crashing at runtime with no class def found error

While running the project/code that creates a XSSFWorkbook, the system is failing with no class definition found error for org.openxmlformats.schemas.spreadsheetml.x2006.main.CTFileRecoveryPr I have all the poi 3.9 jars and its pre-requisites jar…
Vikram
  • 21
  • 6
0
votes
1 answer

No exception in JAVA program when it reads xlsx file with XSSFWorkbook class in POI

I'm developing an eclipse based Java application. But I can't catch the exception. I want to read an excel file(.xlsx) using HSSF and XSSF simultaneously. But HSSF works properly otherwise XSSF doesn't. Here is my code. After wb = new…
user2223347
  • 1
  • 2
0
votes
4 answers

Apache POI in Java causes trouble (XSSFWorkbook)

I am actually trying to read an XLS file with Apache POI, but my code somehow doesn't work. IntelliJ tells me that, on line 28, creating the XSSFWorkbook causes the trouble. Would you have a brief look and maybe answer if you are in this? package…
Paulquappe
  • 144
  • 2
  • 6
  • 15
0
votes
1 answer

XSSFCell Style seems to be slow

I'm currently using apache POI to automatically tranfers data from xls file to xlsm file after some process. I have strong executing time constraint and the setters on XSSFCellStyle is very time consuming. In fact i have files with thousands of…
Wodric
  • 55
  • 3
  • 13
0
votes
1 answer

Use of XSSFWorkbook Sheet interface results in Java Null Pointer exception

I am trying to use the XSSFWorkbook from org.apache.poi.ss.usermodel to read an Excel file. For some reason I am getting a Null Pointer exception when I try to pull data from one of the Sheet methods. I am very new to Java programming, and it may be…
user3334428
  • 1
  • 1
0
votes
0 answers

Type of cached formula value - XSSF event

Is there an easy way (i.e. without evaluating the formula) to detect the type of the cached formula value. Here is an example of a formula cell element: CONCATENATE("3",".","5") 3.5 Here the type should be…
nakhli
  • 4,009
  • 5
  • 38
  • 61
1 2 3
…
32 33