Skip to content

openxlsx 4.2.4
Compare
Choose a tag to compare
@ycphs ycphs released this 16 Jun 14:19
v4.2.4
add94bc

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)
Assets 2