If the openxlsx
package is installed, Huxtables can be converted to
openxlsx::openxlsx()
Worbook objects, for use in Excel documents.
as_Workbook(ht, ...) # S3 method for huxtable as_Workbook( ht, Workbook = NULL, sheet = "Sheet 1", write_caption = TRUE, start_row = 1, start_col = 1, ... )
ht | A huxtable. |
---|---|
... | Not used. |
Workbook | An existing |
sheet | Name for the worksheet where the huxtable will be created. |
write_caption | If |
start_row, start_col | Number. Write data starting at the given row and column. |
An object of class Workbook
.
Use openxlsx::saveWorkbook()
to save the resulting object to an Excel file.
Properties are supported with the following exceptions:
Non-numeric column widths and row heights, table width and height.
Decimal padding.
Cell padding.
Table position.
Caption width.
Huxtable tries to guess appropriate widths and height for rows and columns; numeric width()
and
height()
are treated as scaling factors.
Contents are only stored as numbers if a whole column is "numeric", i.e. can
be converted by as.numeric()
). Otherwise, they are stored as text.
wb <- as_Workbook(jams) if (FALSE) { openxlsx::saveWorkbook(wb, "my-excel-file.xlsx") } # multiple sheets in a single workbook: wb <- openxlsx::createWorkbook() wb <- as_Workbook(jams, Workbook = wb, sheet = "sheet1") wb <- as_Workbook( hux("Another", "huxtable"), Workbook = wb, sheet = "sheet2")