All Questions
83 questions
0
votes
0
answers
142
views
Binary excel file(.xlsb) is not opening or corrupted after creating using Apache POI in Spring boot
I'm trying to generate excel binary file(.xlsb) using Apache POI in the Spring boot. File successfully created. However, when I try to open the file, I receive the following error.
"Excel cannot ...
- 3
-5
votes
2
answers
4k
views
Update existing excel file in java using Fastexcel
I am new in fastexcel library in java. I want to update my existing excel file using Fastexcel library. but when I try to do it at that time It will clean all the data and create new File.
I am ...
-1
votes
1
answer
160
views
Apache poi multiple Doughnut Chart in XSSFClientAnchor
I am writing a code which creates multiple DoughnutChart in excel file.I can create multiple doughnut Chart and put them side by side using multiple anchore.
Now i have two issues
Values are not ...
- 83
2
votes
1
answer
640
views
Apache poi formula evaluation for range based
We're trying to evaluate xlsx formulas using poi in java maven project, but the output values are repetitive in case of a formula having a range or array.
Below is expected vs poi output :
Expected ...
- 23
0
votes
1
answer
138
views
I want to read excel and map columns to database columns or save the metadata of excel into database
If user upload similar excel with same headers I have to automatically read them based on the saved metadata. The technology stack is java, spring and mysql
I had designed database to store hearders ...
0
votes
1
answer
111
views
Correction importing excel in spring boot
I have tried this code to import an excel but it doesn't work. It always make the same error
Repository
public interface AjustageRepository extends JpaRepository<Ajustage, Long> {
@Query(&...
0
votes
1
answer
316
views
How do I handle empty cells while reading Excel with org.jxls in Spring Boot?
I am using the org.jxls library in a Spring Boot project to read an Excel file. The reading process is working fine, but when it encounters an empty cell, it throws an org.jxls.reader....
- 11
0
votes
1
answer
7k
views
java.net.SocketTimeoutException: Read timed out when reading Excel with Workbook
I'm trying to read an Excel with over 500.000 lines in my Spring Boot Application. The problem is that I get a java.net.SocketTimeoutException: Read timed out AFTER already having read all lines in. ...
- 35
0
votes
0
answers
126
views
I am using apache-poi in my spring boot project to build a excel sheet in which i am calculating sum using excel formula
I have applied formula on a cell to calculate sum of the doubles in cells of a row, I want the answer to be printed with symbol pound(GBP).
This is the formula:
Cell cellDynamic = row.createCell(59); ...
- 1
1
vote
0
answers
368
views
How to apply formatting to just one cell in Apache Poi in Spring Boot with Java
I am currently formatting a date in a cell, but this formatting is leaking to other cells, transforming some cells into dates, I wanted to know how to format only a single cell without affecting the ...
0
votes
1
answer
654
views
how to resize image width and height in excel using apache poi in java
I used picture.resize that not worked
If the picture size is big that it become large i want that picture fit into the excel cell
if picture is big that it will resize according to the cell i want a ...
0
votes
2
answers
2k
views
Writing large Excel in Java causing high CPU usage using apache-poi
Writing large data around 1/2 million records with 25 columns.
Using apache-poi streaming workbook to write data from list to excel file.
when tested locally it is giving high CPU spikes in local ...
- 59
0
votes
1
answer
640
views
how to get date cell value as it is from excel using apache poi (without formatting)
In my excel, I have date like :
but when reading it , it is printing as 11/30/22 , i.e it is printing in mm/dd/yy format but I need value as it is in excel cell, I tried different way but either it ...
- 103
0
votes
0
answers
1k
views
Create excel workbook from byte array of sub part of existing excel file
I would like to create a Apache POI excel workbook from the byte[] of partially read existing excel file. Please find the details as below
Download big excel file in multiple small parts from API. ...
- 1,123
0
votes
0
answers
468
views
Read huge data from Mongo db and exporting it to the excel
I have a requirement where I need to read the huge data from Mongo db collection and based on some conditions populate it to the excel sheet so that end user can download and see the data (Approx. ~ 1....
