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]
1
vote
0answers
9 views
How to change font on XSSFTextBox
XSSFTextBox and XSSFRichTextField's
Edit see comment; Apache POI seems to be racist, black not supported? Red is?
Edit 2 : instead of using XSSFColor use constants in Font, they have Red and Black; ...
-3
votes
0answers
15 views
How to evaluate Correl function using Apache POI [closed]
I need to evaluate a cell which contains Correl function. Is there a way to achieve it using Apache POI? I have .xlsx spreadsheets.
0
votes
0answers
16 views
how to draw line using setShapeType in apache poi XSSF usermodel
I'm updating the code to use 3.8 poi, so I'm changing the code from HSSF to XSSF. I have setShapeType to OBJECT_TYPE_LINE in HSSF, how to change the setShapeType for XSSF usermodel.
I need to draw a ...
0
votes
0answers
24 views
apache poi XSSF Excel takes long time to open
I'm using Apache poi 3.8 for reading xlsx file, it does everything correctly, but finally while opening the xlsx file, it takes long time.
First it creates a blank excel sheet and after some 5 mins it ...
0
votes
0answers
75 views
java.lang.IllegalArgumentException: Your InputStream was neither an OLE2 stream, nor an OOXML stream
When I'm reading Excel file(.xls format), I keep getting an Exception, java.lang.IllegalArgumentException: Your Input Stream was neither an OLE 2 stream, nor an OOXML stream.
I Go-ogled and found that ...
2
votes
1answer
67 views
Why won't Apache POI OPCPackage close() method save/write contents to open writable file?
Using the following code, cell value changes made to my Excel Spreadsheet are not saved:
OPCPackage pkg = OPCPackage.open(inputFile);
XSSFWorkbook wb = new XSSFWorkbook(pkg);
ModifyWorkbook();
...
0
votes
0answers
27 views
Creating cell comments in apache poi (for .xlsx files) with show comments disabled
I am trying to create cells comments using apache poi. I am able to create the comments, but by default they are always displayed in excel. I have to manual right click on the cell and un-tick show ...
2
votes
1answer
39 views
How to check if date uses 1904 windowing with Apache POI XSSF eventmodel
I am writing a program that imports xlsx files with Apache POI eventmodel (SAX/XSSF). I am almost done, but I can't get the correct dates.
I am parsing a cell with date value
<c r="D1" s="1">
...
0
votes
0answers
211 views
writing to excel sheet through XSSF
My aim is to read from an excel sheet and to write into the same excel sheet using POI's XSSF classes. The reading part is quite easy. But while writing to the file without using WorkbookFactory, I've ...
0
votes
0answers
22 views
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, ...
0
votes
0answers
194 views
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 ...
2
votes
1answer
430 views
Excel Cell Format - XSSF Workbook
This is my code so far, it gets data from a query then exports it into an Excel document:
<cfscript>
oArray = CreateObject("java", "java.util.Arrays");
workbook = CreateObject("java", ...
0
votes
0answers
424 views
Getting Apache POI java.lang.IllegalStateException: Zip File is closed when trying to read a xlsx file
I am getting java.lang.IllegalStateException: Zip File is closed when i try to read a xlsx file. The code is being accessed from a spring based app. I am using apache poi 3.9. With apache POI 3.8 i ...
0
votes
0answers
156 views
Lock Insert Columns in POI Excel
I have a generated .xlsx file from my Java code using POI. the sheet consist of a table that is filled by the user and then imported to our databases. Within the border this table we could not afford ...
0
votes
1answer
623 views
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
...
