1

I'm trying to save a kableExtra table, but I only managed to do so by clicking on the "save" button above the image (png or jpeg), which is not ideal...this is my case

  • Ideally, I'd like to export it as a Word file (note that knitting to Word in r-markdown is NOT working)
  • I'd also like to be able to export to .png, but this option to save as pdf or png is working

If I try the same thing, I get:

packageVersion("kableExtra") 
[1] ‘1.3.4’

> library(webshot)
Warning message:
package ‘webshot’ was built under R version 4.1.3 

> dt <- mtcars[1:5, 1:6]
>  
> kableExtra::kbl(dt, caption="Table") %>%
+ kableExtra::kable_classic(full_width = F, html_font = "Cambria") %>% 
+ kableExtra::save_kable("my_latex_table.png") # altern

Could not load  c:%5CUsers%5Claris%5CAppData%5CLocal%5CTemp%5CRtmpm0UVE0%5Cmy_latex_table524420567fce.html
Error in webshot::webshot(file_temp_html, file, ...) : 
  webshot.js returned failure value: 1

Any ideas? Ideally, I'd like to be able to export to both .doc and .png

shafee
  • 15,566
  • 3
  • 19
  • 47
Larissa Cury
  • 806
  • 2
  • 11

1 Answers1

1

Update

It seems updating the {webshot} package solve this issue. After installing the {webshot} package again, Running the following code simply,

library(kableExtra)

dt <- mtcars[1:5, 1:6]

kbl(dt, caption="Table") %>%
kable_classic(full_width = F, html_font = "Cambria") %>% 
save_kable("my_latex_table.png")

indeed creates the my_latex_table.png in the working directory.

packageVersion("webshot")
#> [1] '0.5.4'

Old answer

It seems you are not alone facing this issue. There's an exactly same issue #707 regarding this erroneous behavior of {webshot} (Although the issue is currently closed with a suggested workaround).

I am just describing the suggested workaround from this issue #707 comment.

At first, save the table in a html file using save_kable which will create a html file in your working directory and then pass that html file in webshot::webshot() to get a screenshot of the table from that html file, which will create the png file in your working directory.

library(kableExtra)

dt <- mtcars[1:5, 1:6]

kbl(dt, caption="Table") %>%
kable_classic(full_width = F, html_font = "Cambria") %>% 
save_kable("my_latex_table.png")


webshot::webshot("my_latex_table.html", file = "my_latex_table.png",
                 selector = ".lightable-classic", expand = 20)
shafee
  • 15,566
  • 3
  • 19
  • 47
  • Yes! removing the package and installing it again worked, thank you! But, 2 questions: a) how can I change the size of the exported image? b) is there a way to plot is as a .doc (Word) editable file as well? I couldn't find it! @shafee – Larissa Cury Oct 07 '22 at 21:08
  • 2
    AFAIK, `kableExtra` doesn't work natively with docx output, if your goal is word output, I would recommend you to look into either `{flextable}` or `{huxtable}` pkgs. – shafee Oct 08 '22 at 08:30