Edi wrote:
>
> 1 to 10 in the first XL row
> 11 to 20 in the 2nd XL row
> ...
> ..
> 41 to 50 in the 5 th XL row.
> How?
>
Write a loop that iterates through the range (column<10, row<5) while
keeping a counter
that gets incremented on each cell.
I know what you might be thinking, you might be thinking that there is a
function like excel VBA
that does autofill over a selected range. Unfortunately with my limited poi
experience I have yet found such
functionality. I think it is not likely there will be any since poi works at
a record level instead of spreadsheet
level like Excel VBA.
Hope this helps
--
View this message in context:
http://www.nabble.com/Print-dynamic-values-into-XL-Cell--tp16804678p16807721.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]