Hao Zhu | 73cf373 | 2018-05-11 17:50:05 -0400 | [diff] [blame] | 1 | #' Save kable to files |
| 2 | #' |
| 3 | #' @param x A piece of HTML code for tables, usually generated by kable and |
| 4 | #' kableExtra |
Hao Zhu | 7f8b684 | 2018-10-23 17:41:13 -0400 | [diff] [blame] | 5 | #' @param file save to files. If the input table is in HTML and the output file |
| 6 | #' ends with `.png`, `.pdf` and `.jpeg`, `webshot` will be used to do the |
Hao Zhu | 7039ecf | 2019-01-06 17:51:21 -0500 | [diff] [blame] | 7 | #' conversion. |
Hao Zhu | 73cf373 | 2018-05-11 17:50:05 -0400 | [diff] [blame] | 8 | #' @param bs_theme Which Bootstrap theme to use |
| 9 | #' @param self_contained Will the files be self-contained? |
Hao Zhu | 7039ecf | 2019-01-06 17:51:21 -0500 | [diff] [blame] | 10 | #' @param extra_dependencies Additional HTML dependencies. For example, |
| 11 | #' `list(` |
| 12 | #' @param ... Additional variables being passed to `webshot::webshot`. This |
| 13 | #' is for HTML only. |
| 14 | #' @param latex_header_includes A character vector of extra LaTeX header stuff. |
| 15 | #' Each element is a row. You can have things like |
| 16 | #' `c("\\\\usepackage{threeparttable}", "\\\\usepackage{icons}")` You could |
| 17 | #' probably add your language package here if you use non-English text in your |
| 18 | #' table, such as `\\\\usepackage[magyar]{babel}`. |
| 19 | #' @param keep_tex A T/F option to control if the latex file that is initially created |
| 20 | #' should be kept. Default is `FALSE`. |
Hao Zhu | ab67094 | 2020-08-19 15:35:35 -0400 | [diff] [blame] | 21 | #' @param density density argument passed to magick if needed. Default is 300. |
Jiaxiang Li | e4b24f2 | 2019-04-05 13:38:11 +0800 | [diff] [blame] | 22 | #' @examples |
| 23 | #' \dontrun{ |
| 24 | #' library(kableExtra) |
Hao Zhu | 73cf373 | 2018-05-11 17:50:05 -0400 | [diff] [blame] | 25 | #' |
Jiaxiang Li | e4b24f2 | 2019-04-05 13:38:11 +0800 | [diff] [blame] | 26 | #' kable(mtcars[1:5, ], "html") %>% |
| 27 | #' kable_styling("striped") %>% |
| 28 | #' row_spec(1, color = "red") %>% |
| 29 | #' save_kable("inst/test.pdf") |
| 30 | #' } |
Hao Zhu | 73cf373 | 2018-05-11 17:50:05 -0400 | [diff] [blame] | 31 | #' @export |
| 32 | save_kable <- function(x, file, |
Hao Zhu | 7039ecf | 2019-01-06 17:51:21 -0500 | [diff] [blame] | 33 | bs_theme = "simplex", self_contained = TRUE, |
| 34 | extra_dependencies = NULL, ..., |
Hao Zhu | ab67094 | 2020-08-19 15:35:35 -0400 | [diff] [blame] | 35 | latex_header_includes = NULL, keep_tex = FALSE, |
| 36 | density = 300) { |
Vincent Arel-Bundock | 75ecb62 | 2020-10-11 17:47:07 -0400 | [diff] [blame] | 37 | |
| 38 | if (!is.null(attr(x, "format"))) { |
| 39 | |
| 40 | # latex |
| 41 | if (attr(x, "format") == "latex") { |
| 42 | return(save_kable_latex(x, file, latex_header_includes, keep_tex, density)) |
| 43 | |
| 44 | # markdown |
| 45 | } else if (attr(x, "format") == "pipe") { |
| 46 | |
| 47 | # good file extension: write to file |
| 48 | if (tools::file_ext(file) %in% c("txt", "md", "markdown", "Rmd")) { |
| 49 | return(save_kable_markdown(x, file)) |
| 50 | |
| 51 | # bad file extension: warning + keep going to html writer |
| 52 | } else { |
| 53 | warning('`save_kable` can only save markdown tables to files with the following extensions: .txt, .md, .markdown, .Rmd. Since the supplied file name has a different extension, `save_kable` will try to use the HTML writer. This is likely to produce suboptimal results. To save images or other file formats, try supplying a LaTeX or HTML table to `save_kable`.') |
| 54 | } |
| 55 | |
| 56 | } |
| 57 | |
Hao Zhu | 7f8b684 | 2018-10-23 17:41:13 -0400 | [diff] [blame] | 58 | } |
Vincent Arel-Bundock | 75ecb62 | 2020-10-11 17:47:07 -0400 | [diff] [blame] | 59 | |
| 60 | # html |
Hao Zhu | 7039ecf | 2019-01-06 17:51:21 -0500 | [diff] [blame] | 61 | return(save_kable_html(x, file, bs_theme, self_contained, |
Hao Zhu | ab67094 | 2020-08-19 15:35:35 -0400 | [diff] [blame] | 62 | extra_dependencies, density, ...)) |
Hao Zhu | 7f8b684 | 2018-10-23 17:41:13 -0400 | [diff] [blame] | 63 | } |
| 64 | |
Vincent Arel-Bundock | 75ecb62 | 2020-10-11 17:47:07 -0400 | [diff] [blame] | 65 | |
| 66 | save_kable_markdown <- function(x, file, ...) { |
| 67 | out <- paste(x, collapse="\n") |
| 68 | writeLines(text=out, con=file) |
| 69 | return(invisible(file)) |
| 70 | } |
| 71 | |
| 72 | |
Hao Zhu | 7039ecf | 2019-01-06 17:51:21 -0500 | [diff] [blame] | 73 | save_kable_html <- function(x, file, bs_theme, self_contained, |
Hao Zhu | ab67094 | 2020-08-19 15:35:35 -0400 | [diff] [blame] | 74 | extra_dependencies, density, ...) { |
Hao Zhu | 7039ecf | 2019-01-06 17:51:21 -0500 | [diff] [blame] | 75 | dependencies <- list( |
Hao Zhu | 73cf373 | 2018-05-11 17:50:05 -0400 | [diff] [blame] | 76 | rmarkdown::html_dependency_jquery(), |
| 77 | rmarkdown::html_dependency_bootstrap(theme = bs_theme), |
Hao Zhu | ab67094 | 2020-08-19 15:35:35 -0400 | [diff] [blame] | 78 | html_dependency_lightable(), |
Hao Zhu | 73cf373 | 2018-05-11 17:50:05 -0400 | [diff] [blame] | 79 | html_dependency_kePrint() |
| 80 | ) |
Hao Zhu | 7039ecf | 2019-01-06 17:51:21 -0500 | [diff] [blame] | 81 | if (!is.null(extra_dependencies)) { |
| 82 | dependencies <- append(dependencies, extra_dependencies) |
| 83 | } |
| 84 | |
Hao Zhu | 46a42a1 | 2019-01-22 00:11:11 -0500 | [diff] [blame] | 85 | html_header <- htmltools::tags$head(dependencies) |
Hao Zhu | 73cf373 | 2018-05-11 17:50:05 -0400 | [diff] [blame] | 86 | html_table <- htmltools::HTML(as.character(x)) |
| 87 | html_result <- htmltools::tagList(html_header, html_table) |
Hao Zhu | 7f8b684 | 2018-10-23 17:41:13 -0400 | [diff] [blame] | 88 | |
ghaarsma | 8e786ad | 2019-02-16 21:28:01 -0600 | [diff] [blame] | 89 | |
| 90 | # Check if we are generating an image and use webshot to do that |
Hao Zhu | 7f8b684 | 2018-10-23 17:41:13 -0400 | [diff] [blame] | 91 | if (tools::file_ext(file) %in% c("png", "jpg", "jpeg", "pdf")) { |
ghaarsma | 8e786ad | 2019-02-16 21:28:01 -0600 | [diff] [blame] | 92 | file_temp_html <- tempfile(pattern = tools::file_path_sans_ext(file), tmpdir = '.', fileext = ".html") |
| 93 | |
| 94 | file.create(file_temp_html) |
| 95 | file_temp_html <- normalizePath(file_temp_html) |
| 96 | file.create(file) |
| 97 | file <- normalizePath(file) |
| 98 | |
| 99 | # Generate a random temp lib directory. The sub is to remove any back or forward slash at the beginning of the temp_dir |
| 100 | temp_dir <- sub(pattern = '^[\\\\/]{1,2}', replacement = '', tempfile(pattern = 'lib', tmpdir = '' , fileext = '')) |
| 101 | htmltools::save_html(html_result, file = file_temp_html, libdir = temp_dir) |
| 102 | |
| 103 | result <- webshot::webshot(file_temp_html, file, ...) |
| 104 | if (is.null(result)) { |
| 105 | # A webshot could not be created. Delete newly created files and issue msg |
| 106 | file.remove(file) |
| 107 | file.remove(file_temp_html) |
| 108 | message('save_kable could not create image with webshot package. Please check for any webshot messages') |
Hao Zhu | f1873a4 | 2019-01-07 15:57:01 -0500 | [diff] [blame] | 109 | } else { |
ghaarsma | 8e786ad | 2019-02-16 21:28:01 -0600 | [diff] [blame] | 110 | if (tools::file_ext(file) == "pdf") { |
| 111 | message("Note that HTML color may not be displayed on PDF properly.") |
| 112 | } |
| 113 | # Remove temp html file and temp lib directory |
| 114 | file.remove(file_temp_html) |
| 115 | unlink(file.path(dirname(file_temp_html), temp_dir), recursive = TRUE) |
| 116 | |
| 117 | if (requireNamespace("magick", quietly = TRUE)) { |
Hao Zhu | ab67094 | 2020-08-19 15:35:35 -0400 | [diff] [blame] | 118 | img_rework <- magick::image_read(file, density = density) |
ghaarsma | 8e786ad | 2019-02-16 21:28:01 -0600 | [diff] [blame] | 119 | img_rework <- magick::image_trim(img_rework) |
| 120 | img_info <- magick::image_info(img_rework) |
Hao Zhu | ab67094 | 2020-08-19 15:35:35 -0400 | [diff] [blame] | 121 | magick::image_write(img_rework, file, density = density) |
ghaarsma | 8e786ad | 2019-02-16 21:28:01 -0600 | [diff] [blame] | 122 | attr(file, "info") <- img_info |
| 123 | } else { |
| 124 | message("save_kable will have the best result with magick installed. ") |
| 125 | } |
Hao Zhu | f1873a4 | 2019-01-07 15:57:01 -0500 | [diff] [blame] | 126 | } |
ghaarsma | 8e786ad | 2019-02-16 21:28:01 -0600 | [diff] [blame] | 127 | |
Hao Zhu | 7f8b684 | 2018-10-23 17:41:13 -0400 | [diff] [blame] | 128 | } else { |
Hao Zhu | f1873a4 | 2019-01-07 15:57:01 -0500 | [diff] [blame] | 129 | file.create(file) |
| 130 | file <- normalizePath(file) |
ghaarsma | 8e786ad | 2019-02-16 21:28:01 -0600 | [diff] [blame] | 131 | |
Hao Zhu | 7f8b684 | 2018-10-23 17:41:13 -0400 | [diff] [blame] | 132 | if (self_contained) { |
ghaarsma | 8e786ad | 2019-02-16 21:28:01 -0600 | [diff] [blame] | 133 | # Generate a random temp lib directory. The sub is to remove any back or forward slash at the beginning of the temp_dir |
| 134 | temp_dir <- sub(pattern = '^[\\\\/]{1,2}', replacement = '', tempfile(pattern = 'lib', tmpdir = '' , fileext = '')) |
| 135 | htmltools::save_html(html_result, file = file, libdir = temp_dir) |
| 136 | #remove_html_doc(file) |
Hao Zhu | 7f8b684 | 2018-10-23 17:41:13 -0400 | [diff] [blame] | 137 | rmarkdown::pandoc_self_contained_html(file, file) |
ghaarsma | 8e786ad | 2019-02-16 21:28:01 -0600 | [diff] [blame] | 138 | unlink(file.path(dirname(file), temp_dir), recursive = TRUE) |
| 139 | } else { |
| 140 | # Simply use the htmltools::save_html to write out the files. Dependencies go to the standard lib folder |
| 141 | htmltools::save_html(html_result, file = file) |
Hao Zhu | 7f8b684 | 2018-10-23 17:41:13 -0400 | [diff] [blame] | 142 | } |
Hao Zhu | 73cf373 | 2018-05-11 17:50:05 -0400 | [diff] [blame] | 143 | } |
Hao Zhu | d851693 | 2019-01-06 18:56:47 -0500 | [diff] [blame] | 144 | |
Hao Zhu | f1873a4 | 2019-01-07 15:57:01 -0500 | [diff] [blame] | 145 | return(invisible(file)) |
Hao Zhu | 73cf373 | 2018-05-11 17:50:05 -0400 | [diff] [blame] | 146 | } |
Hao Zhu | 7f8b684 | 2018-10-23 17:41:13 -0400 | [diff] [blame] | 147 | |
Hao Zhu | 46a42a1 | 2019-01-22 00:11:11 -0500 | [diff] [blame] | 148 | remove_html_doc <- function(x){ |
| 149 | out <- paste(readLines(x)[-1], collapse = "\n") |
| 150 | writeLines(out, x) |
| 151 | } |
| 152 | |
Hao Zhu | ab67094 | 2020-08-19 15:35:35 -0400 | [diff] [blame] | 153 | save_kable_latex <- function(x, file, latex_header_includes, keep_tex, density) { |
Vincent Arel-Bundock | 97166b3 | 2020-08-26 11:42:23 -0400 | [diff] [blame] | 154 | |
| 155 | # if file extension is .tex, write to file, return the table as an |
| 156 | # invisible string, and do nothing else |
| 157 | if (tools::file_ext(file) == "tex") { |
| 158 | writeLines(x, file, useBytes = T) |
| 159 | return(invisible(x)) |
| 160 | } |
| 161 | |
Hao Zhu | 7039ecf | 2019-01-06 17:51:21 -0500 | [diff] [blame] | 162 | temp_tex <- c( |
| 163 | "\\documentclass[border=1mm, preview]{standalone}", |
| 164 | "\\usepackage[active,tightpage]{preview}", |
| 165 | "\\usepackage{varwidth}", |
| 166 | "\\usepackage{amssymb, amsmath}", |
| 167 | "\\usepackage{ifxetex,ifluatex}", |
| 168 | "\\usepackage{fixltx2e}", |
| 169 | "\\usepackage{polyglossia}", |
Hao Zhu | 7039ecf | 2019-01-06 17:51:21 -0500 | [diff] [blame] | 170 | latex_pkg_list(), |
| 171 | "\\usepackage{graphicx}", |
Hao Zhu | 7039ecf | 2019-01-06 17:51:21 -0500 | [diff] [blame] | 172 | "\\usepackage{xltxtra,xunicode}", |
Hao Zhu | eac7b03 | 2020-08-19 14:07:03 -0400 | [diff] [blame] | 173 | "\\usepackage{xcolor}", |
Hao Zhu | 7039ecf | 2019-01-06 17:51:21 -0500 | [diff] [blame] | 174 | latex_header_includes, |
| 175 | "\\begin{document}", |
| 176 | solve_enc(x), |
| 177 | "\\end{document}" |
| 178 | ) |
| 179 | temp_tex <- paste(temp_tex, collapse = "\n") |
Hao Zhu | 7f8b684 | 2018-10-23 17:41:13 -0400 | [diff] [blame] | 180 | |
Hao Zhu | d851693 | 2019-01-06 18:56:47 -0500 | [diff] [blame] | 181 | temp_tex_file <- paste0(tools::file_path_sans_ext(file), ".tex") |
Hao Zhu | 7039ecf | 2019-01-06 17:51:21 -0500 | [diff] [blame] | 182 | writeLines(temp_tex, temp_tex_file, useBytes = T) |
Hao Zhu | f1873a4 | 2019-01-07 15:57:01 -0500 | [diff] [blame] | 183 | temp_tex_file <- normalizePath(temp_tex_file) |
| 184 | file_no_ext <- tools::file_path_sans_ext(temp_tex_file) |
| 185 | |
| 186 | owd <- setwd(dirname(temp_tex_file)) |
| 187 | |
AC Craft | 7cea533 | 2020-04-19 16:01:07 -0400 | [diff] [blame] | 188 | system(paste0('xelatex -interaction=batchmode "', temp_tex_file,'"')) |
Hao Zhu | 7039ecf | 2019-01-06 17:51:21 -0500 | [diff] [blame] | 189 | if (!keep_tex) { |
Hao Zhu | f1873a4 | 2019-01-07 15:57:01 -0500 | [diff] [blame] | 190 | temp_file_delete <- paste0(file_no_ext, c(".tex", ".aux", ".log")) |
Hao Zhu | 7039ecf | 2019-01-06 17:51:21 -0500 | [diff] [blame] | 191 | unlink(temp_file_delete) |
| 192 | } |
| 193 | |
Hao Zhu | f1873a4 | 2019-01-07 15:57:01 -0500 | [diff] [blame] | 194 | table_img_info <- NULL |
Hao Zhu | d851693 | 2019-01-06 18:56:47 -0500 | [diff] [blame] | 195 | if (tools::file_ext(file) != "pdf") { |
| 196 | table_img_pdf <- try( |
Hao Zhu | f1873a4 | 2019-01-07 15:57:01 -0500 | [diff] [blame] | 197 | magick::image_read(paste0(file_no_ext, ".pdf"), |
Hao Zhu | ab67094 | 2020-08-19 15:35:35 -0400 | [diff] [blame] | 198 | density = density), silent = T) |
Bill Evans | 30b84f5 | 2020-09-11 09:54:58 -0700 | [diff] [blame] | 199 | if (inherits(table_img_pdf, "try-error")) { |
Hao Zhu | d851693 | 2019-01-06 18:56:47 -0500 | [diff] [blame] | 200 | stop("We hit an error when trying to use magick to read the generated ", |
Hao Zhu | 53e5961 | 2019-01-15 12:16:06 -0600 | [diff] [blame] | 201 | "PDF file. You may check your magick installation and try to ", |
| 202 | "use magick::image_read to read the PDF file manually. It's also ", |
| 203 | "possible that you didn't have ghostscript installed.") |
Hao Zhu | d851693 | 2019-01-06 18:56:47 -0500 | [diff] [blame] | 204 | } |
Hao Zhu | f1873a4 | 2019-01-07 15:57:01 -0500 | [diff] [blame] | 205 | unlink(paste0(file_no_ext, ".pdf")) |
Hao Zhu | d851693 | 2019-01-06 18:56:47 -0500 | [diff] [blame] | 206 | table_img <- magick::image_convert(table_img_pdf, |
| 207 | tools::file_ext(file)) |
Hao Zhu | f1873a4 | 2019-01-07 15:57:01 -0500 | [diff] [blame] | 208 | table_img_info <- magick::image_info(table_img) |
| 209 | magick::image_write(table_img, |
Hao Zhu | ab67094 | 2020-08-19 15:35:35 -0400 | [diff] [blame] | 210 | paste0(file_no_ext, ".", tools::file_ext(file)), |
| 211 | density = density) |
Hao Zhu | 7039ecf | 2019-01-06 17:51:21 -0500 | [diff] [blame] | 212 | } |
Hao Zhu | 7039ecf | 2019-01-06 17:51:21 -0500 | [diff] [blame] | 213 | |
Hao Zhu | f1873a4 | 2019-01-07 15:57:01 -0500 | [diff] [blame] | 214 | setwd(owd) |
| 215 | |
| 216 | out <- paste0(file_no_ext, ".", tools::file_ext(file)) |
| 217 | attr(out, "info") <- table_img_info |
| 218 | return(invisible(out)) |
Hao Zhu | 7f8b684 | 2018-10-23 17:41:13 -0400 | [diff] [blame] | 219 | } |