[R] Warning message in openxlsx
G.Maubach at weinwolf.de
G.Maubach at weinwolf.de
Tue Jun 14 16:12:04 CEST 2016
Hi All,
I get the warning message
Warning message:
In styles$font : partial match of 'font' to 'fonts'
when executing
> xls_workbook <- t_create_workbook()
> xls_sheetname <- "Kunden"
> xls_ds_to_save <- ds_merge1
> xls_filename <- paste0(data_created,
"_Merge1_BW-SAP-Kunden_cleaned.xlsx")
> t_add_sheet(workbook = xls_workbook,
+ sheetname = xls_sheetname,
+ dataset = xls_ds_to_save)
> t_write_xlsx(workbook = xls_workbook,
+ path = path_output,
+ filename = xls_filename,
+ overwrite = TRUE)
where t_create_workbook() is
return(createWorkbook())
and t_add_sheet() is
addWorksheet(workbook,
sheetName = sheetname)
writeDataTable(workbook,
sheet = sheetname,
x = dataset)
### writeDataTable writes data to a sheet an adds
### autofilter to the first line
if (freeze_row <= 1 | freeze_col <= 1) {
NULL # do nothing
}
else {
freezePane(workbook,
sheet = sheetname,
firstActiveRow = freeze_row,
firstActiveCol = freeze_col)
}
setColWidths(workbook,
sheet = sheetname,
cols = 1:ncol(dataset),
widths = "auto")
and t_write_xlsx is
saveWorkbook(workbook,
file = file.path(path, filename),
overwrite = overwrite)
I am woundring what "partial match of 'font' to 'fonts'" means cause I do
not call it in the functions calls. I use these calls a lot in my programs
but never got this message before.
What does this message mean? How can I avoid this message?
Kind regards
Georg Maubach
PS: You can find more information about the used functions by going to
https://sourceforge.net/projects/r-project-utilities/files/?source=navbar
.
More information about the R-help
mailing list