url: pptxhandler/table: pattern: /$YAMLURL/output.pptx handler: PPTXHandler kwargs: version: 2 source: $YAMLPATH/template.pptx data: sales: url: $YAMLPATH/sales.csv transform: > data.insert(3, 'Bar 2018', data['FY2018']) or data.insert(5, 'Bar 2017', data['FY2017']) or data.insert(6, 'Growth', data['FY2018'] / data['FY2017'] - 1) or data rules: - Sales Table: table: data: sales vertical-align: f'middle' font-size: f'11 pt' header-row: - Name - Indication - '
FY2018
' - "" - 'FY2017
' - "" - 'Growth
' text: Name: cell.val Indication: cell.val FY2018: f'{cell.val:,d}
' Bar 2018: f'' + ('█' * int(cell.val / 1000)) + '' FY2017: f'{cell.val:,d}
' Bar 2017: f'' + ('█' * int(cell.val / 1000)) + '' Growth: f'' width: Name: 1 Indication: 2.5 FY2018: 1 Bar 2018: 1.5 FY2017: 1 Bar 2017: 1.5 Growth: 1