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