Is it possible to render gt tables in Power Point

Jannik · August 7, 2020, 10:28am

Dear Community,

I would like include a nicely formatted gt table in my power point presentation generated using rmarkdown.

I have my YAML to include:

Is there a way to render gt tables when knitting rmarkdown to powerpoint?

Thank you for your support

/Jannik

cderv · August 7, 2020, 3:16pm

the GT does not suppot PPTX output for the moment
You can give a in the Feature request

github.com/rstudio/gt

Support for .pptx output

opened 07:29PM - 07 Dec 18 UTC

npelikan

Difficulty: [3] Advanced Effort: [3] High Priority: [2] Medium Type: ★ Enhancement

Hi! Playing around with your package and the dev version of RStudio, I've notice…d that `gt` tables don't print with any formatting when output to .pptx, instead just printing raw text. Two solutions I can see, in ascending order of complexity: 1) Output the formatted table as an immutable image and 2) Output into a native .pptx tables Reprex: ````` --- title: "pptx_test" output: powerpoint_presentation --- ```{r setup, include=FALSE} library(gt) library(tidyverse) library(glue) ``` ## Slide with GT output ```{r cars, echo = FALSE} # Define the start and end dates for the data range start_date <- "2010-06-07" end_date <- "2010-06-14" # Create a gt table based on preprocessed # `sp500` table data sp500 %>% dplyr::filter(date >= start_date & date <= end_date) %>% dplyr::select(-adj_close) %>% dplyr::mutate(date = as.character(date)) %>% gt() %>% tab_header( title = "S&P 500", subtitle = glue::glue("{start_date} to {end_date}") ) %>% fmt_date( columns = vars(date), date_style = 3 ) %>% fmt_currency( columns = vars(open, high, low, close), currency = "USD" ) %>% fmt_number( columns = vars(volume), scale_by = 1 / 1E9, pattern = "{x}B" ) ``` `````

I would advice to use flextable for Office Output