ycphs/openxlsx

Enable Total Row with writeDataTable

sch56 opened this issue · 0 comments

packageVersion('openxlsx')
[1] ‘4.2.5.2’

Excel has a set of Table Style Options
image

Most of these can be set with writeDataTable, but apparently not the 'Total Row' option.

It would be great to be able to include this, rather than having to insert a specially formatted row after a table.

An example of what this looks like when the Check box is ticked in Excel (last couple of rows of a table) with total row:
image