Export table as excel - Githubissues

shannonpileggi commented 5 years ago

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?

rich-iannone commented 5 years ago

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.

shannonpileggi commented 5 years ago

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.

berghe01 commented 4 years ago

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).

jacobjchristensen commented 4 years ago

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...

leebunce commented 4 years ago

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

ballengerj commented 4 years ago

I agree as well, as I'm now looking for an easy way to export the table to Excel and or Word for Incorporation into a report.

egoipse commented 4 years ago

Hi... Here's a +1 for the possibility of exporting gtables to Excel and Word...

rwaaijman commented 3 years ago

Indeed, many thanks for this great package!!

Also wondering if there are any updates on this issue? I would like to add gt tables to a tab in excel

sethct commented 3 years ago

Love this package and just wanted to add a +1 for excel exporting and whether this feature was implemented?

aito123 commented 3 years ago

Hello, if its not too late i also want to add a +1 for this as_excel function. By the way, is it possible to rescale a gt table in a pdf so that it feats all the horizontal page (it is a really wide table). Thanks!

mbedan commented 2 years ago

+1 for an Excel exporting capability

ruampimentel commented 2 years ago

I love this package! Thank you for working on this! Just want to add my +1 for this point. Any updates on this issue?

LoganCones commented 2 years ago

+1 on the exporting capabilities that would be great!

Shelmith-Kariuki commented 2 years ago

Hi ... thank you so much for this package. I am also hopeful that we can soon have a way to export our beautiful {gt} tables to excel. Thanks

aawaa commented 2 years ago

I am also looking to GT to Excel spreadsheet export! Thank you.

matanhakim commented 1 year ago

Amazing package, just started using it lately. I would like to join the requests, right now my solution is to knit the {gt} table as flex_table and to copy it by hand from MS Word to Excel. Thanks a lot for all of your work!