openxlsx 4.1.1 ---------------------------------------------------------------- openxlsx 4.1.0 ---------------------------------------------------------------- NEW FEATURES * deleteNamedRegions to delete named region and optionally the worksheet data * set Workbook properties 'title', 'subject', 'category' BUG FIXES * pageSetup fails when passing in sheet by name * matching sheet names with special characters now works * skipEmptyCols being ignored by read.xlsx.Workbook * zero column data.frames would throw an error. * read.xlsx on files created using apache poi failed to match sheet name to xml file. * deleted table re-appearing after save & load. * newline characters in table names would corrupt file * datetime precision openxlsx 4.0.17 ---------------------------------------------------------------- NEW FEATURES * getNamedRegions returns sheet name and cell references along with the named regions. * borderStyle and borderColour can be vector to specify different values for each side * dataValidation type "list" * dataBar showValue, gradient and border can now be set through conditionalFormatting() * options("openxlsx.zipflags") to pass additional flags to zip application e.g. compression level * getTables() and removeTable() to show and remove Excel table objects * set column to 'hidden' with setColWidths() BUG FIXES * skipEmptyRows & skipEmptyCols was being ignored by read.xlsx * date detection basic_string error * multiple spaces in table column names were not being maintained thus corrupting the xlsx file. * openXL fail silently on relative paths * headerStyle failed when writing a list of length 1 using write.xlsx * detectDate for read.xlsx issues * some Excel column types causing existing styling to be removed * na.strings no longer ignored for read.xlsx.Workbook * partial dollar matches on 'font' and 'fill' fixed * maintain hidden columns and their custom widths in loadWorkbook() * overwriting cells with borders sometimes removed the border styling openxlsx 4.0.0 ---------------------------------------------------------------- NEW FEATURES * Reduced RAM usage and improved performance * maintain vbaProject, slicers, pivotTables on load * Read and load from URL BUG FIXES * Fix date time conversion accuracy issues. * Allow multibyte characters in names and comments. * Remove tolower() over style number formats to allow uppercase cell formatting * Stacking styles fixed. openxlsx 3.0.2 ---------------------------------------------------------------- NEW FEATURES * "between" type for conditional formatting values in some interval. * colWidths parameter added to write.xlsx for auto column widths. * freezePane parameter handling added to write.xlsx. * visible parameter to addWorksheet to hide worksheets. * sheetVisible function to get and assign worksheet visibility state "hidden"/"visible" * pageBreak function to add page breaks to worksheets. BUG FIXES * keepNA paramter added to write.xlsx. Passed to writeData/writeDataTable openxlsx 3.0.1 ---------------------------------------------------------------- NEW FEATURES * improved performance of read.xlsx and loadWorkbook * writeFormula funciton added to write cell formulas. Also columns with class "formula" are written as cell formulas similar how column classes determine cell styling * Functionality to write comments and maintain comments with loadWorkbook * check.names argument added read.xlsx to make syntactically valid variable names * loadWorkbook maintains cell indents * namedRegion parameter added to read.xlsx to read a named region. * getNamed regions to return names of named regions in a workbook * getSheetNames to get worksheet names within an xlsx file. BUG FIXES * convertToDateTime now handles NA values * read.xlsx rows bug fixed where non-consecutive cells were skipped. * convertToDate & convertToDateTime now handle NA values. * out of bounds worksheet fixed for libre office xlsx files. * loadWorkbook now maintains chartSheets openxlsx 2.4.0 ---------------------------------------------------------------- NEW FEATURES * stackable cell styling * getDateOrigin function to return the date origin used internally by the xlsx file to pass to convertToDate * Auto-detection of date cells. Cells that "look" like dates will be converted to dates when reading from file. * read.xlsx.Workbook to read from workbook objects * colIndex, rowIndex added to read.xlsx to only read specified rows and columns * Excel slicers now maintained by loadWorkbook * fill styles extended to support gradientFill BUG FIXES * Encoding fixed and multi-byte characters now supported. * read.xlsx now maintains multiple consecutive spaces and newline characters. * convertToDate & convertToDateTime now handle NA values. * multiple selected worksheet issue whioch preventing adding of new worksheets in Excel. * zoom parameter now limited to [10, 400] and documentation updated. * write.xlsx colnames parameter being assigned to rownames * Handling of NaN and Inf values in writeData openxlsx 2.1.3 ---------------------------------------------------------------- NEW FEATURES * conditionalFormatting type "databar" * asTable parameter to write.xlsx to writing using writeDataTable. * extended numFmt formatting to numeric rounding also added option("openxlsx.numFmt" = ...) for default number formatting of numeric columns * additional numFmt "comma" to format numerics with "," thousands separator * tableName parameter to writeDataTable to assign the table a name * headerStyle parameter to writeDataTable for additional column names styling * textRotation parameter to createStyle to rotate cell text * functions addFilter & removeFilter to add filters to columns * Headers & footers extended, can now be set with addWorksheet and setHeaderFooter. setHeader & setFooter deprecated. * "fitToWidth" and "fitToHeight" logicals in pageSetup. * "zoom" parameter in addWorksheet to set worksheet zoom level. * "withFilter"" parameter to writeDataTable and writeData to remove table filters * keepNa parameter to writeDataTable and writeData to write NA values as #N/A * auto column widths can now be set with width = "auto" VIGNETTE * section on write.xlsx in Introductory vignette BUG FIXES * Fix reading in of apostrophes * Styling blank cells no longer corrupts workbooks * read.xlsx now correctly reads sharedStrings with inline styling * sharedStrings now exact matches true/false to determine logical values from workbooks. * fomulas in column caused openxlsx to crash. This has been fixed. openxlsx 2.0.15 ---------------------------------------------------------------- NEW FEATURES * writeData now style based on column class the same as writeDataTable * Vignette "Formatting" for examples focussed on formatting * Customizable date formatting with createStyle and also through option("openxlsx.dateFormat" = ...) * Customizable POSIX formatting with createStyle and also through option("openxlsx.datetimeFormat" = ...) * Generalised conditionalFormat function to complex expressions and color scales. * writeData border type "all" to draw all borders and maintain column styling. * Deprecated "sheets" and replaced with "names" function * column class "scientific" to automatically style as scientific numbers * writeData now handles additional object classes: coxph, cox.zph, summary.coxph1 from Survival package BUG FIXES * Invalid XML characters in hyperlinks now replaced. * Encoding issues when writing data read in with read.xlsx * scientific notation resulting in corrupt workbooks fix * Multiple saves of Workbooks containing conditional formatting were corrupt. * Latin1 characters now write correctly. * logicals written as 0/1 instead of TRUE/FALSE openxlsx 2.0.1 ---------------------------------------------------------------- NEW FEATURES * write.xlsx function to write data directly to file via the writeData function with basic cell styling. * writeDataTable now styles columns of class 'Date', 'POSIXct', 'POSIXt', 'currency', 'accounting', 'percentage' as Excel formats Date, Date, Date, Currency, Accounting, Percentage respectively. * Data of class 'Date', 'POSIXct', 'POSIXt', 'currency', 'accounting' are converted to integers upon writing (as opposed to characters). * writeDataTable converts columns of class 'hyperlink' to hyperlinks. * logicals are converted to Excel booleans * hyperlinks in loaded workbooks are now maintained * borderStyle argument to createStyle to modify border line type. * borderStyle argument to writeData to modify border line type. * "worksheetOrder" function to shuffle order of worksheets when writing to file * openXL function to open an excel file or Workbook object BUG FIXES * conversion of numeric data to integer in read.xlsx fixed. * readWorkbook/read.xlsx should work now. Empty values are now padded with NA. Many other bugs fixed. * borders on single row and/or column data.frames now work. * readWorkbook/read.xlsx check for TRUE/FALSE values is now case-insensitive. * sheet names containing invalid xml charcters (&, <, >, ', ") now work when referencing by name and will not result in a corrupt workbook. * sheet names containing non-local characters can now be referenced by name. * Invalid factor level when missing values in writeData * saveWorkbook now accepts relative paths. * Non-local character encoding issues. * errors in vignette examples. * numbers with > 8 digits were rounded in writeData