Conditional formatting and transposing a table for export/report

KNIME Extensions
1

Hello,

I have a table of data which I would like to conditionally format all the columns individually (change background colour depending on the value e.g. >4 = green, <4 = red in the first column, <5 = green and >5 = red in the 2nd column etc…) then export it ideally to a powerpoint type format. However the table must also be transposed.

I have tried several different methods:

  • Transposing the table, then using CSS editor, but the export seems to only work as javascript
  • Transposing the table then exporting to BIRT, but highlighting a table in BIRT only works on columns
  • Using XLS coloured writer to format the table and export it as a transposed table, which is OK for excel, but then I need to copy and paste it into slides.

If there any way to do this?

Thanks,
Sian

2

Hello @Sian_Evans1,

KNIME does not currently have much support for powerpoint, however if you are open to using python, you will be able to use the python-pptx library and directly create and format the table in a powerpoint file.

You will however need to provide the absolute path to the file, or handle it within the python script node.

Check out the documentation below on how to create and format tables:
https://python-pptx.readthedocs.io/en/latest/api/table.html#table-objects

Hope this helps,
TL

3 Likes