Hi,
At the moment I can recommend you to check related examples in jxls
distribution and see if it helps.
Custom processing support in jXLS is not that flexible and reliable as it
could be and needs to be reworked in future releases.
If it does not provide what you want you better use POI API directly to
post-process the generated workbook.
--
Leo
On Thu, Mar 15, 2012 at 3:45 PM, Jan Groth <asian...@gmx.de> wrote:
> Hi everyone,
>
> I need some custom formatting (If one field of a row has a certain value,
> I basically need to colour this field and some others of the same row.). I
> did a lot of try and error with Excel Conditional Formatting, till I found
> out from this mailing list that Conditional Formatting is not copied over
> from the excel template.
>
> Now I implemented a RowProcessor according to the example provided here:
> http://jxls.sourceforge.net/samples/dynamicstylesample.html
>
> Well, I see the processor method being called ( public void
> processRow(Row row, Map namedCells), and I am able to debug data in the row
> object during template procession. But what I observe doesn't seem to be
> consistent with your example:
>
> *>
> // check if processed row has a parent row
> if( row.getParentRow()!=null ){
> <*
> --> row.getParentRow() is always null, for each and every row of my
> template
>
> *>
> row.getRowCollections()
> <*
> --> is always empty, for each and every row of my template
>
> This is my template:
>
> [row 1] header
> [row 2] start outer loop (product)
> [row 3] show product data
> [row 4] start inner loop (product.customers)
> [row 5] show customer data
> [row 6] close inner loop
> [row 7] close outer loop
>
> Needless to say: The template works and I'm able to fill in all the data.
> It's just that I need to find a way to change the formatting if a product's
> customer is in a certain state.
>
> Would be great if someone could push me in the right direction...
>
> Cheers,
> Jan
>
>
>
>
> ------------------------------------------------------------------------------
> This SF email is sponsosred by:
> Try Windows Azure free for 90 days Click Here
> http://p.sf.net/sfu/sfd2d-msazure
> _______________________________________________
> jXLS-user mailing list
> jXLS-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jxls-user
>
>
------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure
_______________________________________________
jXLS-user mailing list
jXLS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jxls-user
