Gt: Export table as excel

Created on 1 Apr 2019 · 9Comments · Source: rstudio/gt

Feature request: Would it be possible and in the scope of this package to create an as_excel() function to export a gt table to excel?

[3] Advanced [3] High [2] Medium ★ Enhancement

Source

shannonpileggi

👍19

Most helpful comment

That's great to hear! I'd want a function that converts the gt table to an excel spread sheet. And yes, I'd want to preserve the cell types as well.

Of particular interest to me: below is a screenshot of a standard deliverable for project teams with my employer, that I'd like to be able to fully replicate with R.

standard_excel_table

shannonpileggi on 5 Apr 2019

👍6

All 9 comments

Thanks for posting this feature request. It is definitely within scope and this dovetails nicely with the feature request for Word table outputs. If the code generation required for these two things is similar enough, then this would be part of the same sub-project. That said, it may take awhile to begin work on this.

One question, do you want a function to take a data frame / tibble and simply create that in a new Excel document? Do you want all the footnotes and the header elements to be part of the Excel output? One thing we lose when doing all of the gt formatting is the cell type (everything gets converted to character) although I'm thinking that we want to preserve cell types for this output format.

rich-iannone on 5 Apr 2019

👍5

That's great to hear! I'd want a function that converts the gt table to an excel spread sheet. And yes, I'd want to preserve the cell types as well.

Of particular interest to me: below is a screenshot of a standard deliverable for project teams with my employer, that I'd like to be able to fully replicate with R.

standard_excel_table

shannonpileggi on 5 Apr 2019

👍6

Thanks for this amazing package! I too would really find an export to excel highly useful for converting these incredible gt_tables to publication/submission ready tables (often, journals request tables in excel format).

berghe01 on 14 Nov 2019

👍4

I just want to add myself to the list of users that would love to see Excel export functionality. Would save researchers like myself a huge amount of time prepping tables prior to submitting to a scientific journal. dplyr, tidyr and friends can only get you so far, and whenever you change something, well, you know how the story goes...

jacobjchristensen on 12 Apr 2020

Agree with this, the ability to save tables to excel would be very helpful. As a government statistician it is common to release _multiple_ tables in a single excel document, as users are most comfortable with excel. An example is attached.
Tables.xlsx