Hi,
In our unit-tests we do the following a lot when we verify that
writing/reading the data keeps things at their expected state/place.
This writes the spreadsheet to a byte[] and then reads it back in as
new Workbook.
ByteArrayOutputStream baos = new ByteArrayOutputStream(4096);
Hi Dominik,
After digging down, Array Formulas are supported !!!
sheet.setArrayFormula() is what I was trying to implement.
Please change the Not yet supported in [1] to hint about that.
Thanks again,Ahmed
[1] http://poi.apache.org/spreadsheet/formula.html
From: Dominik Stadler
Thanks, Dominic.
That will probably work for me. I think the parsing only =seems= to take a
long time sometimes, but it's just the I/O.
On Wed, Jan 21, 2015 at 12:16 PM, Dominik Stadler dominik.stad...@gmx.at
wrote:
Hi,
In our unit-tests we do the following a lot when we verify that
2015-01-19 4:33 GMT+09:00 Dominik Stadler dominik.stad...@gmx.at:
you can probably use Sheet.shiftRows(int startRow, int endRow, int n)
to shift the rows down starting at the point of insertion and then
create a new row at the index that is then unpopulated.
Thank you very much. I'll try to