excel_fig | R Documentation |
Turn a matrix of data into an SVG of how it might look in Excel
excel_fig( mat, file = NULL, cellwidth = 80, cellheight = 26, textsize = 16, fig_width = NULL, fig_height = NULL, border = "#CECECE", headcol = "#E9E9E9", headborder = "#969696", headtextcol = "#626262", textcol = "black", row_names = FALSE, col_names = TRUE, hilitcells = NULL, hilitcolor = "#F0DCDB", lwd = 1, direct2svg = FALSE, mar = rep(0.1, 4) )
mat |
A matrix |
file |
Optional file name (must have extension .svg, .png, .jpg, or .pdf) |
cellwidth |
Width of each cell, in pixels |
cellheight |
Height of each cell, in pixels |
textsize |
Size for text (if |
fig_width |
Width of figure, in pixels (if NULL, taken from |
fig_height |
Height of figure, in pixels (if NULL, taken from |
border |
Color of border of cells for the body of the matrix |
headcol |
Background color of cells on the top and left border |
headborder |
Color of border of cells on the top and left border |
headtextcol |
Color of text in cells on the top and left border |
textcol |
Color of text in cells in body of the matrix |
row_names |
If TRUE, and row names are present, include them as a first column |
col_names |
If TRUE, and column names are present, include them as a first row |
hilitcells |
Optional character vector of cells to highlight, like |
hilitcolor |
Color to highlight cells, a vector of length 1 or the same length as |
lwd |
Line width for rectangles |
direct2svg |
If TRUE, rather than R graphics, just print an SVG directly with |
mar |
Plot margins, passed to |
df <- data.frame(id= c(101, 102, 103), sex= c("M", "F", "M"), weight=c(22.3, 15.8, 19.7), stringsAsFactors=FALSE) excel_fig(df, col_names=TRUE)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.