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

How to import both xls and xlsx files using java in spring mvc

In this method i used xssf class which is used to read xlsx file but we cant do it for xls file.for xls we need to have Hssf class .User can import any format there .My requirement,Is there any Class that can be used instead of xssf and hssf to…
Guvaliour
  • 397
  • 1
  • 5
  • 17
0
votes
1 answer

Cannot get a NUMERIC value from a STRING cell error

I have tried many SO answers on this regard but still I could not resolve. My java file is as follows: public class ReadExcelFileAndStore { public List getTheFileAsObject(String filePath){ List employeeList = new…
user9272054
0
votes
0 answers

Removed Records: Named range from /xl/workbook.xml part (Workbook) on opening file with named range

I've just started working with XSSF library in .xlsm files and pretty new in this. I'm facing an issue in .xlsm reading and writing. I'm getting the following message when trying to open the written file Removed Records: Named range from…
IshanAg24
  • 199
  • 2
  • 11
0
votes
0 answers

How much JVM memory is allocated to an object of XSSFWorkbook?

Sorry, I am a bit new to code development, and this may be a really nonsensical question, but I was just curious to know how much JVM memory is allocated to an object of XSSFWorkbook. I am developing a JSP-Servlet based application for which I am…
Gaurav Rangnekar
  • 11
0
votes
1 answer

java.lang.NoClassDefFoundError: org/apache/poi/POIXMLDocument

I am trying to read Excel using Apache POI which is deployed as bundle in Karaf. Used POI versions as per order: poi-3.11.jar poi-ooxml-3.11.jar poi-ooxml-schemas-3.11.jar feature.xml snippet(For wrapping the bundles in…
Arun
  • 131
  • 1
  • 4
  • 15
0
votes
1 answer

How to read data from excel file and create a graph using java or groovy

i'm trying to read data from excel and plot graph using java. I keep getting the below error: org.apache.poi.poifs.filesystem.OfficeXmlFileException: The supplied data appears to be in the Office 2007+ XML. You are calling the part of POI that…
syndy1989
  • 403
  • 10
  • 25
0
votes
1 answer

Apache POI error message displayed for RETURN_BLANK_AS_NULL

I have code for witting data in Excel file whenever cell founds empty. However when i type below code it gives error. : import java.io.FileInputStream; import java.io.FileOutputStream; import…
Ashwini
  • 1
  • 2
0
votes
0 answers

POI XSSF how to set text vertical top in the cell

Recently, I've met a problem on how to set the text into the vertical top using XSSF, I need to put the text in the top of one cell, but when I use cellStyle.setVerticalAlignment(CellStyle.VERTICAL_TOP); it always show the text in the middle…
yuan
  • 1
  • 2
0
votes
1 answer

How to add sheets to a new workbook based of array list

I am trying to create sheets in a new workbook using apache poi. However, I want the sheets created to be the name of studies in an arraylist. I don't know how many studies there are, or what they are beforehand. I am having trouble setting it up.…
mysizebarbi
  • 1
  • 5
0
votes
0 answers

Import Data from Excelsheet (XSSF) in Java

for my current project for university I am looking for help. I have a production programm which tells me how much of a current product I need to produce in a given timeframe (1 Year). Based on this production programm I calculated production…
Chris
  • 1
  • 1
0
votes
1 answer

Apache POI - Constraint on text length to be 8 OR 10

I would like to add the folloqing constraints to a column: text length should be of length 8 OR 10 all the digits should be number BUT the type of the column is string Do you think is possible? Here I have set the column to be string DataFormat…
ayasha
  • 1,221
  • 5
  • 27
  • 46
0
votes
2 answers

How to insert emoji in Excel file using POI-XSSF in Java

I am using below code, for inserting emojis into excel using apache POI-HSSF, Please let me know how can I insert emojis into .xlsx file using POI-XSSF in Java, Workbook workBook =new HSSFWorkbook(); Sheet createSheet =…
Thej
  • 191
  • 1
  • 6
  • 23
0
votes
0 answers

POI Date format (MM/dd/yyyy) doesn't match Excel's Date format

The date format created by POI can't be recognized by the system. My codes are listed below: CellStyle cellStyle = wb.createCellStyle(); CreationHelper createHelper = wb.getCreationHelper(); short dateFormat =…
Elton
  • 23
  • 7
0
votes
1 answer

POI XSSF : javax.xml.stream.FactoryConfigurationError: Provider com.bea.xml.stream.EventFactory not found - Error

I'm having this problem in a RCP Aplication. A little Introduccion. My App is build with Eclispe Indigo 32 bits. I have two projects, one is mainly a library container, and the other project is the main application, and it have a relation to the…
Nicolas400
  • 85
  • 15
0
votes
1 answer

In Apache POI, how to get 'colspan' value relative to over-flowing cell value?

I am currently using Apache POI to transform a spreadsheet to HTML. Though I am able to construct a decent HTML with commonly used API methods of POI. I am restrained in achieving a format for my requirement. It is possible for a cell value to…
Manoj
  • 149
  • 1
  • 3
  • 12
1 2 3
…
32 33