All Questions
6,211
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 ...
2
votes
1
answer
60
views
Algorithm for adjusting formula excel from original cell to destination cell
I am trying to parse formula in excel with 3 params: Formula, original cell address, destination cell address.
Example, with some rules:
Formula
Original Address
Destination Address
Result ...
-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
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
22
views
Create Workbook and Add Rows in MS Excel 365 using Java
I want to create a workbook in Excel 365 and write data in it with Java. I tried using HSSFWorkbook and XSSFWorkbook both, But getting below error while writing. How can I create a workbook and add ...
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
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 ...
-2
votes
1
answer
105
views
Convert PDF to Excel in Java Spring Boot 3.x + [closed]
I have a new task about Converting pdf file to Excel file using Spring Boot framework.
If any one suggest me the maven dependency and Code, It will be much help for me.
@PostMapping("/...
0
votes
0
answers
35
views
Is there a way to add format to a particular cell or a column of cells in jxls template?
I am trying to generate an excel report which requires the flight hours of flight trip to be displayed under a column called "FlightHours". I am using a JXLS template to generate the report. ...
0
votes
0
answers
40
views
Copying HTML table to clipboard to MS Excel
I write a program in Java that create an HTML Table when the user press a button on my Web application. At the end of the creation, the table is copied in the clipboard, and the user paste the ...
0
votes
0
answers
13
views
Java XSSFWorkbook giving wrong output of an excel
I have to read Data of an excel file.
I am using rest and there my output is fine but in the console of my IDE it looks really weird and I do not know how to change the format.
Here is a bit of the ...