[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