openxlsx 4.2.4

Fixes

• write.xlsx() now successfully passes withFilter (#151)
• code clean up PR #168
• removal of unused variables PR #168

New features

• adds buildWorkbook() to generate a Workbook object from a (named) list or a data.frame (#192, #187)
  • this is now recommended rather than the write.xlsx(x, file) ; wb <- read.xlsx(file) functionality before
  • write.xlsx() is now a wrapper for wb <- buildWorkbook(x); saveWorkbook(x, file)
  • parameter checking from write.xlsx() >> buildWorkbook() are now held off until passed to writeData(), writeDataTable(), etc
  • row.names is now deprecated for writeData() and writeDataTable(); please use rowNames instead
• read.xlsx() now checks for the file extension .xlsx; previously it would throw an error when the file was .xls or .xlm files
• memory allocation improvements
• global options added for minWidth and maxWidth
• write.xlsx() >> buildWorkbook() can now handle colWidths passed as either a single element or a list()
• Added ability to change positioning of summary columns and rows.
  • These can be set with the summaryCol and summaryRow arguments in pageSetup().
• activeSheet allows to set and get the active (displayed) sheet of a worbook.
• Adds new global options for workbook formatting (#165; see ?op.openxlsx)