Description Usage Arguments Value Note Examples
Write a XLSX file from a JSON string
1 2 |
json1 |
JSON string for the cells |
json2 |
JSON string for the images |
json3 |
JSON string for the passwords |
outfile |
name of output file |
overwrite |
logical, whether to overwrite 'outfile' if it exists |
dll |
logical, whether to use the DLL or the executable |
No returned value.
This function is rather for internal purpose. The user should use
hwriteXLSX
.
1 2 3 4 5 6 7 | colorMatrix <- matrix(grDevices::colours(), ncol=9)
f <- function(i, j){
cell(j, i, value = colorMatrix[i,j], color = colorMatrix[i,j])
}
sheet <- list(Colors = do.call(Vectorize(f), expand.grid(i=1:73, j=1:9)))
json <- jsonlite::toJSON(sheet, null="null", auto_unbox = TRUE)
json2xlsx(json, outfile="colors.xlsx")
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.