blob: 440a21eabc00bf8ad54d62818a219ff958d5fbc9 [file] [log] [blame]
Hao Zhu8902df82019-01-07 16:27:32 -05001---
2title: "Save Tables and Use them as Images"
3author: "Hao"
4date: "1/7/2019"
5output: html_document
6---
7
8Before `kableExtra` 1.0, we have a function called `kable_as_image`, which can transform a LaTeX tables to an image and include it in an rmarkdown document. Starting from `kableExtra` 1.0, we will split this function into two pieces: `save_kable` and `as_image`. `save_kable` will save any LaTeX and **HTML** tables to any format (`html`, `png`, `jpg`, `pdf` etc.). The output format will be defined by the file extension of the output file name. Here are a few examples.
9
10```{r, eval=FALSE}
11# not evaluating
12library(kableExtra)
13
14kable(mtcars[1:5, ], "html") %>%
15 kable_styling("striped") %>%
16 row_spec(1, color = "red") %>%
17 save_kable("inst/test.pdf")
18
19kable(mtcars, "latex") %>%
20 kable_styling(latex_options = "striped") %>%
21 save_kable("inst/test.png")
22```
23
Hao Zhu53e59612019-01-15 12:16:06 -060024# Feature Dependencies
25To get it work, you need to make sure you have the following things installed.
26```{r, eval = F}
27install.packages("magick")
28install.packages("webshot")
29webshot::install_phantomjs()
30```
31
32In the end, please make sure you can use `magick::read_image()` function properly for a PDF. On some system (not only windows), it's possible that GhostScript was not setup properly so even if you have `magick` installed, `magick::read_image()` still cannot read PDF properly. That said, although `save_kable` and `as_image` provide really attractive feature, they may not work on every computer.
33
Hao Zhu23ddaf32019-01-08 13:42:26 -050034# Turn your tables into images for cross-formating support
35`kableExtra` only supports `HTML` and `LaTeX`. One way to get it work with `Word` is to render the table `as_image`. This example below shows you how to render a LaTeX table in HTML document. Same rules applies when you use them in `rmarkdown::word_document`.
36
Hao Zhu8902df82019-01-07 16:27:32 -050037```{r}
38library(kableExtra)
39
40kable(mtcars, "latex", booktabs = T) %>%
41 kable_styling(latex_options = c("striped", "scale_down")) %>%
42 row_spec(1, color = "red") %>%
43 as_image()
44```
45
Hao Zhu7c39cba2019-01-08 15:29:33 -050046You can also specify either `width` or `height` of the image. The image will be scaled properly. The units are in inches.
Hao Zhu8902df82019-01-07 16:27:32 -050047
48```{r}
49kable(mtcars, "latex", booktabs = T) %>%
50 kable_styling(latex_options = c("striped", "scale_down")) %>%
51 row_spec(1, color = "red") %>%
52 as_image(width = 8)
53```
54
Hao Zhu7c39cba2019-01-08 15:29:33 -050055`as_image` also works for HTML tables. It means that you can also put in a bootstrap flavored table (image) in Word or PDF.
Hao Zhu53e59612019-01-15 12:16:06 -060056
Hao Zhu8902df82019-01-07 16:27:32 -050057```{r}
58kable(mtcars, "html") %>%
59 kable_styling("striped") %>%
60 row_spec(1, color = "red") %>%
Hao Zhu7c39cba2019-01-08 15:29:33 -050061 as_image(width = 4)
Hao Zhu8902df82019-01-07 16:27:32 -050062```
63
Hao Zhu7c39cba2019-01-08 15:29:33 -050064One problem with this method, especially if you are using it in `Word`, is that to the end, the product you made is a picture. Please let your readers know that they cannot select/edit the tables. :P