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
3
votes
2 answers

XSSF/xlsx file from custom java mediator in wso2 esb

So I trying to create a xlsx file (xlsx is needed as it goes over 70,000 rows) and I keep getting the following error when I deploy to the wso2 esb however when I run the tests (in netbeans and during the mvn build process) it works perfectly. I am…
Jegsar
  • 501
  • 6
  • 22
3
votes
2 answers

Results address of empty cell in Excel sheet using XSSF

I am reading an Excel sheet using POI's XSSF . The Excel sheet has thousands of rows of user information like user name, address, age, department etc. I can read and write the Excel sheet successfully but i want to locate empty/null cell's address…
Arun
  • 851
  • 1
  • 9
  • 19
3
votes
2 answers

How to get filename of xlsx file with apache poi XSSF?

How to get filename of xlsx file with apache poi XSSF? case class XlsxSplitter(path: InputStream){ lazy val spreadSheet=load(path) def load(path: InputStream):SpreadSheet={ val wb = new XSSFWorkbook(path) ......... } } I could…
YoBre
  • 2,520
  • 5
  • 27
  • 37
3
votes
0 answers

Unable to set fill background color for certain cell using RGB value in apache POI

I'm using XSSF in Apache POI to generate Xlsx file. I imported org.apache.poi.xssf.usermodel.XSSFColor. My purpose is to set fill background color to RGB(141,180,226) for certain cell. I tried using XSSFColor bg=getXSSFColor("8DB4E2"); to get the…
Charlie Zeng
  • 131
  • 1
  • 3
  • 17
3
votes
0 answers

XSSF Workbook Sorting

Objective : Sort a selected column alphabetically from A to Z of an existing excel sheet Is there an inbuilt function for sorting a column A to Z (String type column) in XSSF POI API? I've tried searching but have not found any useful links. If…
Jeffrey Chen
  • 237
  • 1
  • 4
  • 17
2
votes
1 answer

Set page view mode in excel file using apache poi

Excel has different modes for viewing a sheet: Normal, Page Layout, Page Break Preview. (In excel 2010: in the view tab). The view mode is saved seperately for each sheet in a workbook and is restored when opened again. I am trying to find a way to…
EliK
  • 103
  • 1
  • 6
2
votes
1 answer

How to get excel cell color in java

I have an XSLX sheet in which few cells are having background color Green, few Red and rest are default(white). How to identify the cell color ? based on the cell color, i have to process the text in the cell. I am using apache poi. Cell cell =…
user301016
  • 2,207
  • 7
  • 36
  • 50
2
votes
1 answer

XSSFWorkbook error - Mostly missing some Jar or Dependencies

I am not using Maven, this is a standalone project where i provide the jars in Reference Libraries The error is thrown when the code is trying to initialize the workbook workbook = new XSSFWorkbook(); Error : ERROR StatusLogger Unable to create…
enemyofnone
  • 65
  • 9
2
votes
1 answer

What is causing my program to bog down when writing to XSSF Workbook?

Maybe "writing" wasn't the correct word since in this function, I am just setting the cells and then writing afterwards. I have a function that I have pin pointed to be the cause of it bogging down. When it gets to this function, it spends over 10…
mcool
  • 457
  • 4
  • 29
2
votes
0 answers

How to write in specific column based on header title in Excel using Apache POI?

I want to write data in a specific column based on the column header title and an attribute of the data to be written. For example, if I have 3 columns, first column with header title "aaa", second column with header title "bbb" and third column…
GFriends
  • 35
  • 5
2
votes
1 answer

Apache POI Format Table Not showing Total Row

i have a class to create formatted table using the code below : public class formatAsTable { public static void main(String[] args) throws FileNotFoundException, IOException { Workbook wb = new XSSFWorkbook(); …
Adeeb Mark
  • 131
  • 1
  • 8
2
votes
1 answer

How to Add negative value for DataBar in apache poi?

i used this code to create a databar : import org.apache.poi.ss.usermodel.*; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.apache.poi.xssf.usermodel.XSSFDataBarFormatting; import org.apache.poi.ss.util.CellRangeAddress; import…
Adeeb Mark
  • 131
  • 1
  • 8
2
votes
1 answer

Receiving Cannot get a NUMERIC value from a BOOLEAN cell when exporting XML map

I have a workbook with an XML mapping defined (I am using POI 4.1.2). A mapped cell contains a formula which evaluates to boolean: =AND(B70="";B71=""; B50="No") I try to export the XML mapping with the following code: // First ensure that all…
Abid
  • 565
  • 1
  • 5
  • 15
2
votes
4 answers

java.lang.IllegalAccessError: superclass access check failed: class org.apache.poi.openxml4j.util.ZipSecureFile

I tried to read and write excel files using org.apache.poi. I get the following exception when I try to access an xlsx file using XSSFWorkBook Exception in thread "main" java.lang.IllegalAccessError: superclass access check failed: class…
Roshana
  • 357
  • 1
  • 3
  • 17
2
votes
1 answer

How can I create an Excel table using NPOI XSSF

I have tried to create a table using NPOI 2.5.1 using the following code (trying to use examples from NPOI samples, and from the Apache POI code). It generates a file, but Excel finds a problem when opening it. Trying to recover removes the table…
user1251614
  • 529
  • 3
  • 11
1 2 3
…
32 33