Print dynamic values into XL Cell?

[Edi <ed...@yahoo.com>]

Hello EE( Excel Experts),

  I had 1 to 50 numbers

I want to display 

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?

Thanks


-- 
View this message in context: http://www.nabble.com/Print-dynamic-values-into-XL-Cell--tp16804678p16804678.html
Sent from the POI - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

Re: Print dynamic values into XL Cell?

[Andy Ch <an...@hotmail.com>]

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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org