ycphs / openxlsx

openxlsx - a fast way to read and write complex xslx files
https://ycphs.github.io/openxlsx/
Other
226 stars 75 forks source link

Enable Total Row with writeDataTable #464

Open sch56 opened 8 months ago

sch56 commented 8 months ago

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