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
0 answers

XSSF saving workbook

I am using XSSF to create a workbook and continually getting this error: Excel found unreadable content in 'thefile'.xlsx. Do you want to recover the contents of this workbook? If you trust the source of the workbook click Yes. Excel then obligingly…
Datadimension
  • 872
  • 1
  • 12
  • 31
0
votes
2 answers

Adding Link file using APACHE POI XSSF is not accepting directory address and showing java.net.URISyntaxException

I am trying to hyperlink a .png file in a cell content of any .xlsx file. Following is the part of code and it is showing java.net.URISyntaxException exception (seems because of slash used in the address). However changing…
Sankumarsingh
  • 9,889
  • 11
  • 50
  • 74
0
votes
0 answers

Is there any way to find the values of one cell based on the value of other cell in Apache POI

I have get an value of a cell in excel spread sheet based on the value of other cell. I have an XLSX in which one columns contains the city names and the other contain the state for that names. So, what I want to do is like find "Orange City" where…
TheRookierLearner
  • 3,643
  • 8
  • 35
  • 53
0
votes
0 answers

Apache-POI / XSSF - Read big file (5 MB)

I've a big file with 10000 rows... Opening it, lasts an eternity... After 10mins I stopped the programm... OPCPackage opcPackage = OPCPackage.open(item.getFilePath()); workbook = new XSSFWorkbook(opcPackage); sheet =…
prom85
  • 16,896
  • 17
  • 122
  • 242
0
votes
1 answer

XSSFCell Cell with period

I am using this library with Java and trying to parse an excel file. A few of my cells just have ... in them. When the parser hits this cell, it does not detect anything in it and continues on. It is a test cell and I am using the getStringValue.…
jrock2004
  • 3,229
  • 5
  • 40
  • 73
0
votes
1 answer

How do I get from .xlsx file to workbook using apache poi eventusermodel?

I need to work with both xls and xlsx. I got an outofmemory error when using xssf so I changed to sxssf and while that doesn't work I would like to change my code to use eventusermodel instead of ss usermodel. Unfortunately I do not understand very…
Marisa
  • 25
  • 7
0
votes
1 answer

Cannot implement xlsx file extension in apache POI

I cannot make an XSSF object in java with the apache POI. I have a list of file directories saved as an array of strings as "list[]". xls (HSSF) are working just fine with no errors. Using the following code: String s = list[i]; //line…
Nick
  • 85
  • 2
  • 5
  • 11
-1
votes
1 answer

Java Apache POI XSSFWorkbook saving column data as text instead of numeric

I have this piece of code which generates an excel file which looks something like this: public static void generateExcel(List results, String outputPath) throws NoSuchMethodException, InvocationTargetException, IllegalAccessException…
eazy
  • 5
  • 2
-1
votes
3 answers

Java multiple constructors with different data types, oke or not, and how to handle?

I have a class called 'Cell' in which I (think I) need multiple constructors The goal is to add the cell's later to an excel sheet, when adding to an excel sheet you need to add what type of data to set the excell-cell to and therefor I want to…
Mr.NeedHelpAlot
  • 29
  • 6
-1
votes
1 answer

NoClassDefFoundError while trying to create XSSFWorkbook()

I have been trying to very simply manipulate cells in a spreadsheet using poi, however every time I try to build my project it gives the same error. This occurs every time at this line here XSSFWorkbook workbook = new XSSFWorkbook(); Here are the…
Jordy van Dongen
  • 91
  • 2
  • 12
-1
votes
1 answer

Workbook in java to find all words in sheet starting with "$" in a xlsx file

I'm working on an excel sheet in which I have multiple columns, which holds multiple text values including variables starting with $. I'm writing a Java code using workbook to read xlsx files. Since I have never used it before, may someone tell me…
medgai
  • 82
  • 4
  • 13
-1
votes
1 answer

How to close XSSF file with out.close()?

I am trying to save and close an existing workbook that I am already successfully opening but for some reason cannot either save and close: //declarations etc here... try { InputStream ExcelFileToRead = new FileInputStream(file); …
Elvis
  • 21
  • 5
-1
votes
3 answers

XSSFWorkbook in java

I am using the XSSFWorkbook for reading the excel sheet data. When i entered the numbers with space after 10 digits and want to remove the space after numbers before saving. But trim(),replaceAll() - all these are not removing the spaces. How can i…
ramya
  • 1
  • 1
  • 1
  • 3
-1
votes
1 answer

Caused by: java.lang.NoSuchMethodError: No static method newFactory()

I'm building an Android application and facing a no static method exception when trying to read the XLSX files. Tried all possibilities like updating dependencies in app/build.gradle, but no avail. Kindly help me to resolve this issue. Exception…
pradeep janarthanan
  • 1
  • 2
-1
votes
1 answer

How to Validate the String and it's Value in excel through Java?

Am new to Java and I have challenge in validating the excel file.Please help me. I want to validate that 'Hyderabad' is the location Name and '1' is the location ID from excel(pls screenshot below)through JAVA .Am able to read all the cell…
Rahul
  • 759
  • 3
  • 21
  • 43
1 2 3
…
32
33