v0.6.1

Release 0.6.1 brings some new features to a slowly but steadily maturing package. The release came a bit earlier than usual to support the next waldo release.

Functions that take columns as arguments should now accept spreadsheet ranges like "A:B". There may still be remaining functions that behave differently, but these should be reported as bugs. It is now possible to place images with dims just like rvg or mschart drawings (they now share the same code), and drawings get the ability to add offset vectors to fine tune their placement. It is now possible to skip hidden columns and rows in wb_to_df(). Support for third party packages that are derivatives of data frames has been improved. The last xy function argument has been deprecated in comment functions, and finally it it is possible to chain load() and to_df().

The release 0.6.1 is the eight openxlsx2 release which is available under CRAN. However, the package is not yet fully stable. Until the stable version 1.0 there may still be changes in the API. A look at the issue tracker and the NEWs is recommended in any case.

What's Changed

• Col range by @JanMarvin in #575
• [wb_add_image] add dims. closes #576 by @JanMarvin in #578
• [test] wb_add_plot() by @JanMarvin in #579
• [wb_to_df] add skipHiddenCols and skipHiddenRows by @JanMarvin in #580
• support writing tibbles. closes #581 by @JanMarvin in #582
• [test] improve test for waldo. closes #584 by @JanMarvin in #585
• [comments] add dims option and minor code cleanup by @JanMarvin in #586
• [wbWorkbook] provide wb$load() and wb$to_df() by @JanMarvin in #587
• Release 0.6.1 by @JanMarvin in #589

Full Changelog: v0.6...v0.6.1

v0.6

Release 0.6 is a maintenance release for a slowly but steadily maturing package. Besides the usual bug fixes, we remove some deprecated functions and make minor changes to the wb_styles functions. Also, feature requests have been fulfilled (reading empty named columns with skipEmptyCols/skipEmptyRows and dims argument in wb_clean_sheet()).

Style functions now accept numeric, integer or logical arguments where applicable. Previously only characters were accepted, now wb_add_font(size = 11) is as valid as wb_add_font(size = "11"). The upgrade vignette has been extended with some pipes examples in addition to the chains. Applicability for R versions < R 4.1.0 has been restored.

The release 0.6 is the seventh openxlsx2 release which is available under CRAN. However, the package is not yet fully stable. Until the stable version 1.0 there may still be changes in the API. A look at the issue tracker and the NEWs is recommended in any case.

What's Changed

• 552 write null by @jmbarbone in #553
• [wb_to_df] modify skipEmptyCols/skipEmptyRows. closes #554 by @JanMarvin in #555
• Type date conv by @JanMarvin in #551
• Cleanup deprecated by @JanMarvin in #548
• use as_xml_attr() in wb_styles functions. closes #557 by @JanMarvin in #558
• add dims argument to wb_clean_sheet(). closes #562 by @JanMarvin in #563
• extend examples for chains and pipes. closes #561 by @JanMarvin in #564
• add std namespace to isfinite. closes #565 by @JanMarvin in #567
• avoid dot functions of R > 3.4.0. closes #568 by @JanMarvin in #569
• release 0.6 by @JanMarvin in #572

Full Changelog: v0.5.1...v0.6

v0.5.1

Release 0.5.1 mainly brings improvements to the existing code as well as the usual bug fixes. A newly integrated feature is form controls. It is now possible to create radio buttons, dropdown menus and check boxes directly from openxlsx2.

Cell initialization has been improved, it is now possible to use nested groupings, and external links are now imported in the correct order. Date detection should now be better, and when filling merged cells, the content that is not in the selected dimensions is now taken into account. The biggest change was made to the internal relationship detection, which should now be smarter and behaves more like openxml relationships should work.

The integration of form controls, the faster cell initialization and the possibility of nested grouping were feature requests or resulted from discussion topics. Thank you for the suggestion and the interest in openxlsx2.

The release 0.5.1 is the sixth openxlsx2 release which is available under CRAN. However, the package is not yet fully stable. Until the stable version 1.0 there may still be changes in the API. A look at the issue tracker and the NEWs is recommended in any case.

What's Changed

• Cleanup drawings and vmlDrawings reference by @JanMarvin in #536
• allow nested grouping by @JanMarvin in #537
• cleanups in wb_load by @JanMarvin in #538
• add form control. closes #532 by @JanMarvin in #533
• improve fillMergedCells. closes #324 by @JanMarvin in #541
• additional cleanup from #536 by @JanMarvin in #542
• create initialize_cell function by @JanMarvin in #545
• try to avoid passing long xml strings to file.exists() by @JanMarvin in #543
• Improve wb to df by @JanMarvin in #547
• 473 na strings by @jmbarbone in #474
• release 0.5.1 by @JanMarvin in #549

Full Changelog: v0.5...v0.5.1

v0.5

Release 0.5 brings a number of changes and the usual bug fixes. In particular, we now use American English by default (aka color) from now on. However, we still support the British English colour. This change was introduced for consistency, previously we had both variants in different functions.

Among the changes, the following stand out: grouping has been improved, as well as reading escaped XML. We provide a new function wb_copy_cells() for copying (and transposing) cells, cell values or cell references in a workbook, and are now able to write both shared strings and inline strings (the previous standard). Shared strings are advantageous when you have many identical strings in a workbook. Writing data to the worksheet has been further improved and two new features have been introduced. 1) there is an experimental option openxlsx2.string_nums that changes the way strings containing numbers are written and 2) a new function has been added to the package. It is now possible to write pivot tables using wb_add_pivot_table(). These are evaluated once the workbook is opened in spreadsheet software. However, be aware that both were introduced recently and may still contain bugs and cause unexpected behavior. Be careful (make some more backups than usual) when using these functions and please give feedback if you do.

The release 0.5 is the fifth openxlsx2 release which is available under CRAN. However, the package is not yet fully stable. Until the stable version 1.0 there may still be changes in the API. A look at the issue tracker and the NEWs is recommended in any case.

What's Changed

• update gha. closes #482 by @JanMarvin in #487
• Fix minor typo by @JanMarvin in #488
• improve row and column grouping. closes #177 by @JanMarvin in #486
• [wb_add_data] Force when writing by @JanMarvin in #492
• Fix wb_load() with multiple sheetView sections. fixes #494 by @JanMarvin in #495
• fix typo in add_border by @JanMarvin in #496
• fix reading of xml escapes by @JanMarvin in #497
• Group depending on outlinePr by @JanMarvin in #491
• fix slicer and slicerCache loading. fixes #504 by @JanMarvin in #505
• fix tab selection by @JanMarvin in #506
• tabColour accepts wb_colour() by @JanMarvin in #500
• New cf by @JanMarvin in #493
• Colour color pt1 by @JanMarvin in #501
• Colour color pt2 by @JanMarvin in #502
• [wb_group_rows] fix copy & paste error. fixes #511 by @JanMarvin in #512
• Load pivot by @JanMarvin in #513
• provide wb_copy_cells. closes #282 by @JanMarvin in #515
• [wb_add_data] string_nums option. closes #503 by @JanMarvin in #516
• correct description. closes #483 by @JanMarvin in #517
• Write sst with inline_string = FALSE by @JanMarvin in #499
• Empty relship by @JanMarvin in #519
• [new feature] Add pivot table by @JanMarvin in #520
• safe speedups for add_data by @JanMarvin in #522
• Speedup add data pt4 by @JanMarvin in #525
• move R code to Rcpp function by @JanMarvin in #526
• move this out of the loop by @JanMarvin in #527
• release 0.5 by @JanMarvin in #529

Full Changelog: v0.4.1...v0.5

v0.4.1

Release 0.4.1 mainly contains bug fixes for problems found since release 0.4. A bug with broken XML specials has been fixed #467 and the calculation chain is now an optional feature #432. Options to use mschart output in openxlsx2 has been improved and it is now possible to add chart sheets! Examples for charts are now included via an openxlsx2 charts manual vignette.

The release 0.4.1 is the fourth openxlsx2 release which is available under CRAN. However, the package is not yet fully stable. Until the stable version 1.0 there may still be changes in the API. A look at the issue tracker and the NEWs is recommended in any case.

What's Changed

• fix add_drawing() sheet logic. closes #457 by @JanMarvin in #458
• add calc_chain argument to wb_load. closes #432 by @JanMarvin in #461
• Fix writing xml escaped characters. fixes #467 by @JanMarvin in #468
• fix freeze pane and support loading freezePane. closes #459 by @JanMarvin in #465
• improve wb_data(). closes #460 by @JanMarvin in #462
• Row hide by @JanMarvin in #475
• create chartsheets. closes 464 by @JanMarvin in #466
• Charts vignette by @JanMarvin in #478
• release 0.4.1 by @JanMarvin in #481

Full Changelog: v0.4...v0.4.1

v0.4

Release 0.4 brings again a number of improvements under the hood. For example, writing formatted cells has been improved, but work has also been done to add support for a number of different openxml functions. For example, support for calculation chains and connections has been improved, and form controls are now supported, as are chart extensions and custom properties. Work has also been done on the basics of many openxml functions. It is now possible to request output from right to left ("openxlsx2.rightToLeft") and printing options have been revised.

As a major new feature openxlsx2 now brings support for the external packages mschart and rvg. Thanks to @davidgohel for the packages and the quick review and release of mschart 0.4!

The inspiration for many of the new features came from issues and discussions on Github. Many thanks to @AnnePdM, @nicojx and @sjewo!

PS: As always, thanks to deepl :)

What's Changed

• fix implicit cast warning by @JanMarvin in #398
• [pugixml] update to release 1.13 by @JanMarvin in #400
• [wb_load] update vml file name. fixes #402 by @JanMarvin in #403
• [vignettes] fix a replace all mistake by @JanMarvin in #401
• [wb_load] read x namespace by @JanMarvin in #405
• add ... as argument for wb_to_df() wrappers by @JanMarvin in #381
• Skip empty sheet. fixes #409 by @JanMarvin in #413
• add further named region arguments by @JanMarvin in #386
• Fix sheetPr creation. fixes #416 by @JanMarvin in #417
• Doc custom by @JanMarvin in #418
• handle customXml folder by @JanMarvin in #419
• speedup numfmt assignment by @JanMarvin in #423
• Enforce fullCalcOnLoad. closes #427 by @JanMarvin in #428
• tweaks for dates. by @JanMarvin in #424
• Gh issue 429. fixes #429 by @JanMarvin in #430
• [wb_add_data] fix double escapes. fixes #435 by @JanMarvin in #436
• 378 wb save by @jmbarbone in #431
• [wb_load] avoid bailing with empty header by @JanMarvin in #438
• remove all.equal.wbWorkbook by @JanMarvin in #434
• Fix fill merged cells by @sjewo in #441
• Cleanup by @JanMarvin in #442
• update or remove calculation chain. fixes #437 by @JanMarvin in #439
• [wb_load] support chartEX by @JanMarvin in #444
• Fix setting and removing row heights by @JanMarvin in #446
• implement formControl. closes #206 by @JanMarvin in #426
• Set sheetview by @JanMarvin in #399
• improve print options. closes #393 by @JanMarvin in #440
• [wbWorkbook] set_bookview by @JanMarvin in #410
• Minor cleanup by @JanMarvin in #450
• provide add_drawing() for {rvg} by @JanMarvin in #449
• Support {mschart} by @JanMarvin in #451
• release 0.4 by @JanMarvin in #453

New Contributors

• @sjewo made their first contribution in #441

Full Changelog: v0.3.1...v0.4

v0.3.1

Release 0.3.1 mainly contains bug fixes for problems found since release 0.3. A big thank you to everyone who reported issues! Among the fixed issues are the following: Writing data to worksheets has been improved. This should speed up writing large data frames onto worksheets #356 . It should be possible to use basic openxlsx2 workbooks with Powerquery #360. Data validation using lists is no longer relying on the x14 extension of openxml #347. Formulas no longer require xml encoding on the user side #384. A few style related issues have been closed: Styles were lost when writing on a existing workbook #359, hyperlink coloring was buggy #344 and some cell styles were behaving inconsistently #372.

The release 0.3.1 is the second openxlsx2 release which is available under CRAN. However, the package is not yet fully stable. Until the stable version 1.0 there may still be changes in the API. A look at the issue tracker and the NEWs is recommended in any case.

What's Changed

• update create_dxfs_style by @JanMarvin in #346
• [wb_add_data] encode formula by @JanMarvin in #351
• [wb_to_df] Show formula by @JanMarvin in #352
• change update_cell() logic. fixes #356 by @JanMarvin in #358
• simplify code by @JanMarvin in #361
• [wb_load] xml cleanup by @JanMarvin in #362
• fix partial match. closes #364 by @JanMarvin in #366
• remove deprecated. fixes #239 by @JanMarvin in #367
• [wb_add_data] unify hyperlink and numeric styling by @JanMarvin in #365
• Data validation list by @JanMarvin in #347
• Update pugi by @JanMarvin in #377
• [styles] avoid sample names. fixes #383 by @JanMarvin in #385
• Gh issue 360 by @JanMarvin in #363
• [add_data_table] improve rowNames. closes #354 by @JanMarvin in #375
• [(un)merge_cells] rm build cell merges by @JanMarvin in #390
• allow having hyperlinks in formulas by @JanMarvin in #388
• Lintr cleanups by @JanMarvin in #392
• [write_xlsx] remove keepNA from man page. closes #373 by @JanMarvin in #382
• [reland] cleanup column width and font size setting by @JanMarvin in #350
• release 0.3.1 by @JanMarvin in #395

Full Changelog: v0.3...v0.3.1

v0.3

Since the last release there have been a lot of smaller and bigger changes, besides the normal improvements and bug fixes. The biggest change was one that was not visible to the users. With release 0.3 openxlsx2 no longer automatically binds directories like drawings and vmlDrawings. Furthermore there were big improvements like sheets can be cloned, a new helper function for color selection (wb_colour()), a consistent behavior when reading worksheets, it is now possible to add sparklines from openxlsx2, copy cell styles and there was further work on vignettes.

The release 0.3 is the first openxlsx2 release which is available under CRAN. This makes it easier for users to get an impression of openxlsx2. However, the package is not yet fully stable. Until the stable version 1.0 there may still be changes in the API. A look at the issue tracker and the NEWs is recommended in any case.

What's Changed

• [R/tests] add style wrapper tests by @JanMarvin in #259
• [R/print] update print returns by @JanMarvin in #258
• [R/save] fix writing headerFooter. fixes #261 by @JanMarvin in #262
• Revert "[manual] check for ggplot2" by @JanMarvin in #260
• 246 data warn by @jmbarbone in #264
• [R/save] fix writing integers without colNames by @JanMarvin in #266
• [R/cf] cleanups and outsourcing by @JanMarvin in #268
• [vignettes] cf add a few images by @JanMarvin in #269
• cloneSheetStyle -> wb_clone_sheet_style by @JanMarvin in #233
• [tests] add data validation by @JanMarvin in #271
• [R/add_data_table] cleanup update_cell() by @JanMarvin in #275
• [R/update_cell_loop] further speedups by @JanMarvin in #276
• [R/pugi] provide xml_rm_child() by @JanMarvin in #273
• [pugi] print consistency and new format flags to indent attributes by @JanMarvin in #279
• improve random strings by @JanMarvin in #281
• implement add_sparklines() by @JanMarvin in #280
• [man] add family styles by @JanMarvin in #285
• [R/write] add dims argument to write by @JanMarvin in #236
• provide private workbook function do_cell_init() by @JanMarvin in #284
• add wb$add_style() and wrapper wb_add_style(). closes #287 by @JanMarvin in #288
• Allow creation of dxfs style w/o font and bg color. closes #291 by @JanMarvin in #293
• Dxf nofont by @JanMarvin in #290
• fix set_sheet_names by @JanMarvin in #295
• fix get_cell_styles by @JanMarvin in #296
• fix remove_worksheet by @JanMarvin in #297
• [R/save] use dir.exist(). closes #263 by @JanMarvin in #265
• improve NA handling #closes #300 by @JanMarvin in #301
• [R/dataValidation] Fixes #277. by @JanMarvin in #299
• More color options by @JanMarvin in #289
• Charts reading by @JanMarvin in #304
• Add r-universe to readme by @JanMarvin in #298
• allow writing data.table. closes #312 by @JanMarvin in #313
• fixes for clone_worksheet with tables, charts and drawings by @JanMarvin in #305
• wrap more results to keep encoding by @JanMarvin in #315
• fix reading charts. fixes #318 by @JanMarvin in #320
• Fix comments from loaded workbooks by @JanMarvin in #310
• Improve drawings by @JanMarvin in #323
• stop if sheet not found. closes 319 by @JanMarvin in #321
• align dims and rows & cols by @JanMarvin in #326
• No drawings dir by @JanMarvin in #311
• style picking by @JanMarvin in #306
• 329 sheet name by @jmbarbone in #331
• wbColor by @JanMarvin in #292
• wb_to_df gets startCol by @JanMarvin in #330
• add_comment/remove_comment. closes #309 by @JanMarvin in #336
• enable multiple ext in extLst by @JanMarvin in #338
• Begin a basic upgrade vignette by @JanMarvin in #337
• change default col size to 10 by @JanMarvin in #341
• Compress jpeg by @JanMarvin in #342
• bump version by @JanMarvin in #339

Full Changelog: v0.2.1...v0.3

v0.2.1

Since the first public release there have been many small and larger changes under the hood. Most notably, the handling of non-Unicode encodings in R versions prior to 4.2 has been improved, as has the handling of missing data when writing output files. Newly added are a few helper functions for working with style formatting. Also, a pretty cool new feature is that some of our internal functions now remember the last sheet you were working on, further improving the way you can work with data.

The full pull request log is below, but the full list of changes is even more extensive.

What's Changed

• read cell attributes cm, ph, and vm by @JanMarvin in #173
• [R/conditional_formatting] fix multiple databar entries per sheet by @JanMarvin in #174
• Update issue templates by @jmbarbone in #172
• Empty cell information by @JanMarvin in #178
• Wb to df cleanup by @JanMarvin in #180
• 170 open windows by @jmbarbone in #171
• Combine writes by @JanMarvin in #175
• [tests] styles read write test pt2 by @JanMarvin in #182
• [R/load] remove references to printerSettings.bin. Closes #184 by @JanMarvin in #185
• [c++/load] load file without row attribute by @JanMarvin in #187
• [c++/pugi] use parse_ws_pcdata. closes #188 by @JanMarvin in #189
• [R/load] fix duplicates in example file with missing r attributes by @JanMarvin in #190
• provide data_only mode for wb_load() by @JanMarvin in #181
• replace tables list object with data frame by @JanMarvin in #191
• [styles] Table styles read/write by @JanMarvin in #194
• Wrap std::string in Rcpp::String by @JanMarvin in #198
• Attempt to write UTF-8 from non UTF-8 systems. Did not test this by @JanMarvin in #199
• [R/load] guard against broken vml. closes #201 and #200 by @JanMarvin in #202
• [R/load&save] change slicer numbers. closes #203 by @JanMarvin in #205
• [R/save] check that comments are saved correctly by @JanMarvin in #209
• Encoding by @JanMarvin in #207
• update codecov.yml by @JanMarvin in #211
• update theme by @JanMarvin in #212
• 176 options by @jmbarbone in #210
• 165 sheet names by @jmbarbone in #179
• [R/get_named_region] add tables to get_named_region() by @JanMarvin in #193
• [R/add_border] add_border and wb_add_border by @JanMarvin in #220
• [R/add_fill] provide add_fill helper by @JanMarvin in #222
• [R/add_font] add font for cells by @JanMarvin in #228
• [R/add_numfmt] wb_add_numfmt and wb$add_numfmt by @JanMarvin in #229
• [R/add_cell_style] initial creation of add_cell_style. by @JanMarvin in #230
• 113 sheet funs by @jmbarbone in #183
• [R/wbWorkbook] remove createFontNode by @JanMarvin in #235
• remove wb_get_sheet_name by @JanMarvin in #240
• a helper column with the cell name. closes #251 by @JanMarvin in #242
• Encoding fixes by @JanMarvin in #243
• [c++] remove match from col_to_df() by @JanMarvin in #245
• re-enable oldrel-1 by @jmbarbone in #247
• [manual] check for ggplot2 by @JanMarvin in #248
• 214 conditional formatting by @jmbarbone in #227
• [R/write] update cell dups by @JanMarvin in #249
• [R/write] fixes for NA, NaN, and Inf. Closes #254 by @JanMarvin in #255
• [R/write] add na.strings argument to write functions by @JanMarvin in #256
• release 0.2.1 by @JanMarvin in #253

Full Changelog: v0.2.0...v0.2.1

v0.2.0

Initial public release

What's Changed

• Dataframe by @JanMarvin in #1
• Moves lookup tables by @jmbarbone in #7
• reindents lines by @jmbarbone in #8
• Update rc-cleanup by @jmbarbone in #12
• ReferenceClass cleanup by @jmbarbone in #14
• row_attr to dataframe. closes #16 by @JanMarvin in #17
• 15 clean r grep by @jmbarbone in #21
• 15 clean r length by @jmbarbone in #23
• provide col to df funcions by @JanMarvin in #25
• add new xml functions. closes #24 by @JanMarvin in #26
• [WIP] basic style operations by @JanMarvin in #10
• add covr by @JanMarvin in #29
• 16 roxygen (#19) by @jmbarbone in #28
• Clean loading by @JanMarvin in #30
• R6 classes by @jmbarbone in #47
• 15 clean r by @jmbarbone in #59
• Speedup saving by @JanMarvin in #63
• Quick fixes by @jmbarbone in #69
• use_pipe() by @jmbarbone in #74
• R6 classes - update for wrappers by @jmbarbone in #82
• 87 testthat by @jmbarbone in #100
• [R/writeData2] add hash_id for formats by @JanMarvin in #102
• [R/wbStyle] remove the remaining parts of wbStyle by @JanMarvin in #103
• Fontwidth by @JanMarvin in #109
• [vignettes] add a base to build on by @JanMarvin in #111
• [R/writeFormula] write array formula by @JanMarvin in #114
• [c++/openxlsx2_types] provide simpler types by @JanMarvin in #115
• [R/namedRegion] use getNamedRegion in wb_to_df and delteNamedRegion by @JanMarvin in #117
• explicitly use "sh" for shQuote() by @jmbarbone in #120
• [WIP] read xlsx with Chartsheet. closes #123 by @JanMarvin in #124
• [R/loadWorkbook] Fix reading external links by @JanMarvin in #125
• [R/drawings] Drawings id per sheet. closes #126 by @JanMarvin in #127
• [R/threadedComments] fix loading and saving xlsx with threadedComment. closes #131 by @JanMarvin in #132
• [R/protectWorkbook] add fileSharing to protectWorkbook. closes #130 by @JanMarvin in #133
• [R/loadWorkbook] remove isUnzipped option. closes #121 by @JanMarvin in #122
• [R/tests] initial test of styles by @JanMarvin in #134
• Delete deprecated.R by @JanMarvin in #136
• Update onUnload.R by @JanMarvin in #137
• 84 expect wrapper by @jmbarbone in #99
• 75 remove col wdiths by @jmbarbone in #139
• 75 remove col widths by @jmbarbone in #138
• [R/various] renaming functions pt1 by @JanMarvin in #140
• [R/various] renaming functions. pt2 by @JanMarvin in #143
• 75 modify base font by @jmbarbone in #141
• 75 set header footer by @jmbarbone in #144
• 75 colwidths by @jmbarbone in #112
• 75 add image plot by @jmbarbone in #145
• 75 page setup by @jmbarbone in #146
• 75 filters by @jmbarbone in #147
• 75 get tables by @jmbarbone in #148
• 75 grid lines by @jmbarbone in #149
• [R/various] renaming R functions pt3 by @JanMarvin in #155
• Rename functions pt4 by @JanMarvin in #156
• 75 order by @jmbarbone in #158
• 75 named regions by @jmbarbone in #159
• 75 data validation by @jmbarbone in #160
• 75 sheet visibility by @jmbarbone in #161
• 75 ungroup col row by @jmbarbone in #163
• 75 page break by @jmbarbone in #162
• 75 protect by @jmbarbone in #157
• 75 add data by @jmbarbone in #166
• [DESCRIPTION] Version bump. closes #150 by @JanMarvin in #151

New Contributors

• @JanMarvin made their first contribution in #1
• @jmbarbone made their first contribution in #7

Full Changelog: https://github.com/JanMarvin/openxlsx2/commits/v0.2.0