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
1
vote
1 answer

Filter specific cellvalues from specific columns from excel file using apache poi?

So I have an excel file which looks something like this: What I want is to be able to load the excel file with apache poi where I can filter specific cellvalues from specific columns. for eg. I only want to get rows where for eg. the "Spuranzahl"…
plshm
  • 288
  • 3
  • 20
1
vote
0 answers

converting hssf worbook to xssf workbook not giving desired results

I have a java application which is used for converting hssf workbook to xssf wokbook.There are predefined templates for the workbook.let the workbook be E.I want to onvert it from E.xls to E.xlsx.I am able to do the conversion and the data is also…
Aishwara S
  • 33
  • 5
1
vote
1 answer

Handle #REF! cell from excel using apache poi

I need to handle #REF! cell from my excel, where ever I get #REF! I need to return 0 or Empty quotes to the datastructure. I tried doing this but I'm not able to succeed, here is the snippet:- if (valueCell.getCellType() == Cell.CELL_TYPE_FORMULA)…
Sudhanva c
  • 109
  • 3
  • 15
1
vote
0 answers

Get active cell using Apache POI

I'm using Apache POI to manipulate an Excel doc. I want to write a test to ensure that when the file is opened, it opens up to the first tab in the document and the cursor is set to the first cell (A1 or R1C1). I've read the following…
franklin
  • 1,800
  • 7
  • 32
  • 59
1
vote
2 answers

XSSFCell in Apache POI encodes certain character sequences as unicode character

XSSFCell seems to encode certain character sequences as unicode characters. How can I prevent this? Do I need to apply some kind of character escaping? e.g. cell.setCellValue("LUS_BO_WP_x24B8_AI"); // The cell value now is „LUS_BO_WPⒸAI" In Unicode…
Matthias Gerth
  • 91
  • 5
1
vote
3 answers

How can I set Date value into cell

Following is my code: String monthEndDate = "31-Dec-17"; SimpleDateFormat sdf = new SimpleDateFormat("dd-MMM-yy",java.util.Locale.ENGLISH); XSSFCell updateDateCell = sheet.getRow(rownumber).getCell(15); XSSFCellStyle cellStyle =…
im_mangesh
  • 177
  • 1
  • 1
  • 13
1
vote
1 answer

Unable to download xlsx from web service

I am trying to download xlsx file generated using Apache XSSF from RESTEasy based web service. I can download the file but when double clicked to open, it says file can not be openend: Below is the source code: Web service…
Akshay Lokur
  • 6,680
  • 13
  • 43
  • 62
1
vote
0 answers

Removing border of XSSFShape in Apache POI

I am using XSSF to draw shapes on a worksheet. Contrary to HSSF, XSSF draws these shapes with a border outline. While this is fine with some of my shapes, I don't want it with some of the other shapes. However, I have not found a way to disable the…
k88
  • 1,858
  • 2
  • 12
  • 33
1
vote
1 answer

XSSF Excel Named Styles

I'm currently using the Apache POI library to generate excel files in Java. Here's what I'm wondering: In excel, it's possible to create new cell styles which will be added to the workbook. These styles are reusable and can be selected from the…
DoonStar
  • 35
  • 5
1
vote
1 answer

Apache POI Copy row with formula n times

i have a sheet with 6 columns and like 50k rows. I would like to copy one row n times. For now I am doing like this: for (int i=0; i<=excel_max_row; i++) { row = sheet3.createRow((short) i); cell = row.createCell(0); …
ayasha
  • 1,221
  • 5
  • 27
  • 46
1
vote
1 answer

c# XSSFWorkbook Unreadable Content

I hope you can help me here. I'm having a few issues with XSSFWorkbook. It generates the file without problem but when i open in in Excel, i get the following warning: Excel found unreadable content in 'blah blah, blah.xlsx' Dou you want to recover…
AndyPoole
  • 77
  • 4
1
vote
0 answers

Java poi 3.16 XSSF pivot table - set filter for columns

I want to generate a pivot table and all of the columns should have the filter like shown in the picture. Is there anyway to activate it in poi for every col except last one because it is just a sum col? Ma current code to generate the pivot…
ninjaxelite
  • 1,139
  • 2
  • 20
  • 43
1
vote
1 answer

How to iterate over current row in an excel sheet using column name?

I need to parse over an excel sheet and retrieve values from each row to store it in database. Currently I am doing it based on the type of values that each cell holds. This is ok in the current case as I have to deal with only 2 columns. But I have…
eccentricCoder
  • 846
  • 1
  • 14
  • 35
1
vote
1 answer

Apache POI XSSF can't create an upward arrow

I am working on an Excel generated file with Apache POI. The file must be xlsx and not xls. I need to draw some arrows, but I can't draw an upward arrow. I use XSSFClientAnchor to create my arrow and specify row/col 1 and row/col…
Boutros Henriet Sco'
  • 11
  • 1
1
vote
2 answers

Class not found from dependency jar

In my project I use apache.poi libs to work with excel files. I have dependencies on: apache.poi.ooxml_3.15 apache.poi_3.15 apache.poi.ooxml_schemas_3.15 jars. So during compilation there are no problems. On runtime: import…
Bublik
  • 912
  • 5
  • 15
  • 30
1 2 3
…
32 33