Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Enable Total Row with writeDataTable #464

Open
sch56 opened this issue Feb 26, 2024 · 1 comment
Open

Enable Total Row with writeDataTable #464

sch56 opened this issue Feb 26, 2024 · 1 comment
Labels

Comments

@sch56
Copy link

sch56 commented Feb 26, 2024

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

Copy link

github-actions bot commented Mar 1, 2025

This issue is stale because it has been open 365 days with no activity. Remove stale label or comment or this will be closed in 7 days.

@github-actions github-actions bot added the Stale label Mar 1, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant