All Questions
3,296 questions
1
vote
1
answer
46
views
In Apache POI, how can I add borders to merged cells?
In Apache POI, how can I add borders to merged cells?
For example, in the following Java code, after calling generateExcel(), the code should merge 3 cells, write text "as" to the merged ...
- 671
1
vote
1
answer
86
views
Java Apache POI How to edit large excel file?
So I have no issues reading a large excel file that has over 100,000 records by doing this:
IOUtils.setByteArrayMaxOverride(1000000000);
My code to read the excel file:
try (FileInputStream fis = new ...
- 31
-1
votes
2
answers
103
views
How to load a large xlsx file with POI library?
I have a large .xlsx file (180 MB, containing 300K lines with 150 columns each) I need to perform some operations within. I am having problems with loading this file (OutOfMemoryError), as POI has a ...
- 2,050
0
votes
1
answer
79
views
How to efficiently write an Excel file at the same time when reading
I have Excel service that is responsible to parse, process and dump data into a database.
If there were failures while validating the Excel file, I am appending a new column named "Error Message&...
-1
votes
1
answer
142
views
Getting hyperlink from Excel spreadsheet with Apache POI
I am processing Excel spreadsheet in Java with Apache POI. Some columns in this spreadsheet contain hyperlinks to the documents stored on the web, which I need to extract. There are several different ...
- 1,152
1
vote
2
answers
68
views
Complex formula not working in Excel Data validation but works fine in value computation
I have an excel formula that I want to add as Data validation in my sheet but the validation breaks for all inputs. Formula:
AND(
LEN(
IFERROR(
LEFT(
INDIRECT(ADDRESS(ROW(), ...
- 65
1
vote
1
answer
129
views
Error in using Apache.poi for reading an excel sheet in Java, using VScode
I am a beginner in coding, and want to read an excel file (xlsx) using java. My IDE is VSCode and I'm not using maven or gradle.
I downloaded the zip file from the Apache website, poi-bin-5.2.3, and ...
- 13
0
votes
0
answers
36
views
How to update values in all the cells using Java and Apache POI? [duplicate]
I use Apache POI to change some values in cells in an Excel workbook. This workbook has integrated formulas in some cells. These formulas use values from cells where I change the value. But I don't ...
0
votes
0
answers
90
views
Avoid 'Number Stored as Text' Warning in Excel Using Apache POI While Writing Numeric Strings
I am working on a Java project where I need to generate an Excel file using Apache POI. One of the columns in the Excel file contains account numbers, which are numeric but need to be stored as text (...
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
2
votes
0
answers
82
views
How to check two Excel files for equality?
I'm using Apache POI to create Excel files.
I want to write a test that creates an Excel file and checks whether its contents are the same as the contents of the other Excel file.
First I thought ...
- 3,241
1
vote
0
answers
44
views
How to Ensure Date Cells in Excel Default to "Date" Format Instead of "Custom" When Generated with Apache POI?
I am generating an Excel file using Apache POI in Java, and I am formatting some cells to display dates. However, when I open the Excel file and inspect the cells, I notice that the formatted date ...
1
vote
1
answer
179
views
Parsing Excel files without Apache POI
I have some Excel files in my project which require the workbook to be opened and saved to trigger a formula refresh. I want to open the Excel files, trigger a formula refresh and then save them.
I ...
- 51
0
votes
1
answer
97
views
Java Apache POI to create Excel workbook not working (Linux)
I am running AlmaLinux Linux 8.10 (Cerulean Leopard)
Running the command java -version gives:
openjdk version "1.8.0_432"
OpenJDK Runtime Environment (build 1.8.0_432-b06)
OpenJDK 64-Bit ...
- 649