All Questions
6,202 questions
0
votes
0
answers
88
views
Java implementation that matches Excel's YIELD() function results
How can I implement a function in Java that performs the exact same calculation as Excel's YIELD function ( the docs). I looked at the specification of the YIELD function and tried to implement it ...
0
votes
0
answers
58
views
How to replicate Excel's YIELD (RENDEMENT.TITRE) function in Java? [closed]
I'm trying to replicate the Excel YIELD() function (French: RENDEMENT.TITRE()) in Java, which calculates the yield to maturity of a bond given:
settlement and maturity dates,
coupon rate,
price,
...
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
0
votes
1
answer
49
views
File using Office XML Schema no longer reliably opened by Excel
For many years I have been exporting HTML tables from my web app and downloading them as XSLX so that they will be opened by Excel.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "...
- 13.5k
-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
0
votes
1
answer
25
views
Setting up a fallback action in Drools
Is there any way of setting up a fallback action on Drools that would get triggered if no rules were matched?
The use-case would be to execute an action to keep the flow going if the fact didn’t ...
- 389
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
1
answer
55
views
Tika Lib detects wrong media type of Excel generated with Aspose Lib
I use Aspose.cells (com.aspose:aspose-cells:24.12) to generate an Excel (.xlsx) file.
...
var outputStream = new ByteArrayOutputStream();
var workbook = new Workbook(inputStream);
workbook.save(...
- 419
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 (...
