Re: Format cells inside table

Hello Chris,
i should just "figure" how the Tabletyle was working.
I wanted to set the color when i added the "data".
But now i just create the data and the tableStyle in the same loop. So i
got what i wanted. :o)

Thanks for your help

tir. 25. aug. 2015 kl. 01.04 skrev Chris Else <[email protected]>:

> Hi Jakob,
>
> Using your example and the code at:
>
> http://www.blog.pythonlibrary.org/2010/09/21/reportlab-tables-creating-tables-in-pdfs-with-python/
>
> I have a solution that might work for you.
>
> Kind regards
>
> Chris
>
>
> from reportlab.lib import colors
> from reportlab.lib.pagesizes import letter
> from reportlab.platypus import SimpleDocTemplate, Table, TableStyle
>
> doc = SimpleDocTemplate("simple_table.pdf", pagesize=letter)
> # container for the 'Flowable' objects
> elements = []
>
> table_data = [['Firstname', 'Lastname', 'Points']]
> table_style = [('TEXTCOLOR', (0,0), (-1, -1), colors.black),
>   ('INNERGRID', (0,0), (-1,-1), 0.25, colors.black),
>   ('BOX', (0,0), (-1,-1), 0.25, colors.black)]
>
> data = [['Jakob', 'Moller', 5],
>   ['Anna', 'Moller', 10],
>   ['Another', 'Person', 1]]
>
> row_number = 1
>
> for forename, surname, points in data:
>   if points > 5:
>     cell_colour = colors.green
>   elif points < 5:
>     cell_colour = colors.red
>   else:
>     cell_colour = colors.yellow
>
>   table_data = table_data + [[forename, surname, str(points)]]
>   table_style = table_style + [('BACKGROUND', (0,row_number), (-1,
> row_number), cell_colour)]
>
>   row_number = row_number + 1
>
> t=Table(table_data)
> t.setStyle(TableStyle(table_style))
> elements.append(t)
> # write the document to disk
> doc.build(elements)
>
> On 18 August 2015 at 12:03, Andy Robinson <[email protected]> wrote:
>
>> Hi Jakob,
>>
>> That's true, it's based on positions.
>>
>> In Report Markup Language, we allow things like
>>   <td textColor="green">99</td>
>> but we implemented it by scanning the markup and generating extra
>> table style commands for that particular table as we parsed the input.
>>
>> Your best bet would be to write a function which looks at the data and
>> generates a new table style, based on the original one but adding
>> extra block commands to colour each cell that needs colouring.  It
>> could be quite short and reusable.  If it's not clear what to do, one
>> of us could try to help in the next few days.
>>
>> - Andy
>>
>>
>>
>>
>> On 18 August 2015 at 09:23, Jakob Damgaard Møller <[email protected]>
>> wrote:
>> > Hello, this is my first post to this list, so i hope i do it right.
>> >
>> > I try to create a table in reportlab.
>> >
>> > data = [
>> >   ['Firstname', 'Lastname', 'Points'],
>> >   ['Jakob', 'Møller', '5'],
>> >   ['Anna', 'Møller', '10'],
>> > etc...
>> > ]
>> >
>> > I want to format cell in colors based on result.
>> > F.ex:
>> > if points > 5:
>> >   cell_color = "green"
>> > elif point < 5:
>> >   cell_color = "red"
>> > else:
>> >   cell_color = "yellow"
>> >
>> > I have looked at this:
>> >
>> http://www.blog.pythonlibrary.org/2010/09/21/reportlab-tables-creating-tables-in-pdfs-with-python/
>> > But as i understand it, the color is defined on coordinates. Cant i
>> assign a
>> > color when i create "data" ?
>> >
>> > _______________________________________________
>> > reportlab-users mailing list
>> > [email protected]
>> > https://pairlist2.pair.net/mailman/listinfo/reportlab-users
>> >
>> _______________________________________________
>> reportlab-users mailing list
>> [email protected]
>> https://pairlist2.pair.net/mailman/listinfo/reportlab-users
>>
>
> _______________________________________________
> reportlab-users mailing list
> [email protected]
> https://pairlist2.pair.net/mailman/listinfo/reportlab-users
>