[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