poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Yegor Kozlov <yegor.koz...@dinom.ru>
Subject Re: How to deal with layout/sub-layout poi usage?
Date Thu, 19 Jul 2012 07:24:17 GMT
http://poi.apache.org/spreadsheet/quick-guide.html#MergedCells

On Wed, Jul 18, 2012 at 3:33 PM, dpmihai <dpmihai@yahoo.com> wrote:
> I want to generate an excel file with apache poi.
>
> I have a layout of type:
>
> |  C1  |  C2  |  C3  |
> |  C4  |  sub-layout |
> |  C5  |       C6      |
>
> where C are data cells and sub-layout is a dynamic layout like
>
> |  S1  |  S2  |  S3  |
> |       S4      |  S5  |
>
> with any possible number of rows and columns.
>
> For a simple excel generation where there is no sub-layout, the process is
> straight-forward:
>
> Create a HSSFWorkbook  , create a HSSFSheet and then the layout is read and
> a HSSFRow is created for every row, and then HSSFCell cells (with necessary
> merged regions if any)
>
> I see HSSFCell cannot contain a group (table) of cells. So what is the best
> way of writing an excel file starting from a layout&sublayout  structure?
>
>
>
>
>
> --
> View this message in context: http://apache-poi.1045710.n5.nabble.com/How-to-deal-with-layout-sub-layout-poi-usage-tp5710483.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
>

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


Mime
View raw message