All Questions
64 questions
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
0
votes
1
answer
89
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
0
answers
104
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
73
views
APACHE POI: How to add FORMULATEXT to POI at run-time?
I have an Excel File generated using Apache POI and I use FORMULATEXT in a cell; this is the formula I insert in the cell:
cell.setCellFormula("IF(P"+(row+1)+"<>\"\",MID(...
0
votes
0
answers
93
views
Using Apache POI lib I want to get date value from a cell that is FORMULA type - function doesn't read the date as desired
as the title says - currently I have a function that works well
excep when...
Following is the cell I want to get data from
="text" & TEXT(TODAY();"RRRR-MM-DD") & "...
- 1
0
votes
0
answers
138
views
How to combine multiple cell values in the MATCH function in excel using Apache POI
I am having an excel sheet with a set of formulas and I am using Apache POI to process and evaluate the formulas. Everything is working fine except one cell which has the match formula which combines ...
- 39
1
vote
0
answers
366
views
org.apache.poi.ss.formula.FormulaParseException: Too many arguments to function 'IF'. At most 3 were expected but got 5
I'm new to JXLS library. Inside Jx:each area, I am using IF statement in a cell, K36, which is referencing a cell J36: $[IF("${account.type}"="Cash Flow", J36, 0)]
when i run the ...
- 11
0
votes
1
answer
82
views
What is a method to read an excel cell with the currency format and coded with a formula using java?
I have a currency format cell which is numeric and its coded with a formula. I can read the formula, no problem. I tried with cell.getNumericCellValue(), but its reading it as 0.00. I've tried ...
0
votes
1
answer
459
views
When xlsx is output @ is added to the formula
I am using Apache POI to generate xlsx.
I need to count the unique number of rows(by cells) through the formula in xlsx
cell.setCellFormula("SUM(1/COUNTIF(I7:I200,I7:I200))");
but if you ...
- 133
0
votes
0
answers
432
views
Java - Excel Formula on an entire column - Apache POI
I need the same formula (H2-F2) on an entire column (H3-F3, H4-F4...) or atleast till 100, starting from J2, without creating a new row (already exists, gets the info from an existent excel file). Is ...
- 25
0
votes
1
answer
641
views
How to parse a full set of formula chain from an excel?
I have an excel file that has a complex calculation model, the performance of direct using apache POI is not acceptable to me. therefore I am thinking to extract the full set formula chain and parse ...
- 886
1
vote
0
answers
72
views
Detect checksum change of a file dynamically and trigger an api call
I need to trigger a job when there is a change in an excel sheet. Is there any elegant ways to detect the checksum change and to trigger an api call. I want to see is there a way to avoid periodical ...
- 1,066
0
votes
0
answers
58
views
write the data according to the name of the cell using java
I have a problem. If I have an excel template, can I customize a name or logo for the cell, and then write the data according to the name of the cell using java
- 1
0
votes
1
answer
511
views
How to use Array Spilling with Apache POI 5.1.0
Using Apache POI to generate excel files, is it possible to prevent Excel from adding the implicit intersection operator (@) inside formulas ?
For instance, using the following code, what I want to do ...
0
votes
1
answer
963
views
Apache POI - Formula to find maximum length of characters in a column
Hi All,
My objective was to find the maximum length of characters in a column. To achieve that I thought of using the below piece of code but it is not providing the expected result.
...
