All Questions
Tagged with excel apache-poi
3,771
questions
0
votes
0
answers
22
views
excelWB.write(fileOut); gives IllegalArgumentException
I am trying to use an excel to write the into new file using Apache POI. This is the method code,
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import ...
-1
votes
0
answers
39
views
Thread execution inside aws lamda
I am having an lamda function that is calling for creating a excel.
When call hit first thing i am creating an entry in status table and returning status id as response
I have a poll api that can be ...
-1
votes
1
answer
105
views
java.io.IOException: Failed to read zip entry source when trying to open an Excel file with Apache POI
I am working on a Groovy project where I need to load an Excel file using Apache POI. The file is provided by a third party, and I encounter an issue when trying to open it directly. If I manually ...
1
vote
1
answer
79
views
Apache POI xlsx "We found a problem with some content in *.xlsx. Do you want us to try to recover it as much as we can" error due to XML parsing error
I am generating an .xlsx file using Apache POI 5.2.5, sending the byte array to the client side and downloading the file locally on the client's machine.
When trying to open the file, I'm getting &...
0
votes
1
answer
54
views
Image cropping for excel creation with apache POI
I am currently creating an Excel file using Apache POI. I already added images to one column correctly. But now I'd like to crop the images to only show the relevant part in the middle of the image. ...
0
votes
1
answer
79
views
Excel cell not updated correctly
I am using apache-poi to modify an excel cell (with setCellValue) and retrieve the value of cellM14 whose value depends on the modified cell.
When I manually open excel cellM14 is updated properly but ...
0
votes
0
answers
73
views
FormulaEvaluatorFormulaParseException Dotted range (full row or column) expression 'C.aRG' must have exactly 2 dots
I am using Apache.poi.xssf.usermodel.XSSF to read from an Excel file and evaluate the formulas using:
FormulaEvaluator evaluator = workbook.getCreationHelper().createFormulaEvaluator();
evaluator....
0
votes
0
answers
72
views
error of not being able to create a workbook for an excel file that contains comments in the sheet when using apache poi
I am using apache poi 3.11. When initializing the workbook of an excel file .xlsm containing comments, the error "org.apache.xmlBeans.xmlException: error: Subsequent sections cannot have content.&...
1
vote
1
answer
54
views
Excel Defined names and cell evaluation order causes unexpected behavior
I generate an excell sheet using Apache POI including 3 defined names used as the data for a graph.
This all works very nice except in a wierd edge case.
I have a column Categories where the user can ...
1
vote
1
answer
52
views
Read Date from excel and insert into PostgreSQL
I have problem while reading date from Excel file using Apache Poi.
I use the following:
FileInputStream inputStream = new FileInputStream(excelFilePath);
Workbook workbook = new XSSFWorkbook(...
0
votes
1
answer
60
views
POI: get formula for Row reference as named reference
So, I'm trying to get formula for row reference e.g. (=2:2 / =Sheet1!2:2 etc.) that is referenced via named range e.g. test_row
If I use getAddress method for cells it works correctly, but if I define ...
0
votes
1
answer
55
views
java apache poi close subtotal and the excel is corrupted
i use java apache poi to generate pivot table and when i use setOutline(false) to let the pivot table show in parallel form rather than in outline form, it will add subtotal row. That's weird. and ...
0
votes
1
answer
213
views
error : "Could not initalize class org.apache.poi.ooxml.POIXMLTypeLoader"
So I'm creating simple Java program to read .xlsx file.
Here the code :
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
private String TestWorkbook(File[] ...
0
votes
1
answer
262
views
JXLS not writing the variables in excel output file
I am new to JXLS and am trying to do their Hello World like in this tutorial but i get blank output instead of processed variables.
The Steps to get my situation:
Open a new java project with Maven
...
1
vote
1
answer
60
views
How to modify the data in excel built into ppt
enter image description here
There is a built-in excel in my ppt template. Now I want to use poi to modify the data in excel. I have tried many methods but it still doesn't work. Please help me.
...