Excel.link Versions Save

Convenient Data Exchange between R and Microsoft Excel

0.9.12

4 months ago

0.9.12 (16.01.2024)

  • minor fixes

v0.9.10

2 years ago

0.9.10 (26.10.2021)

  • update for R4.2

v0.9.8-1

5 years ago

0.9.8-1 (23.05.2018)

  • Fix 'xl.read.file' - it reads hidden sheets incorrectly. Thanks for reporting to Katie McCarron.
  • Add functions 'xl.sheet.show'/'xl.sheet.hide'/'xl.sheet.visible' to manage sheets visibility (very hidden sheet is not supported)
  • Add argument 'write.res.password' for xl.workbook.open/xl.workbook.save/xl.read.file/xl.save.file for reading/writing Excel files with second password (issue #11)
  • Add new function: xl.sheet.name - for getting/setting active sheet name
  • Add new function: xl.sheet.duplicate (issue #14)
  • Now in R_Connection_Examples.xlsm we use default version of R, not 32-bit version (issue #13)

v0.9.7

7 years ago

0.9.7 (30.04.2017)

v0.9.5

7 years ago

0.9.5 (24.09.2016)

  • Fixes an issue with multibyte character encoding (fix from soeque1 https://github.com/soeque1)
  • Fixes an issue with two workbooks after xl.workbooks.add/xl.workbooks.open

v0.9.3

8 years ago

0.9.3 (06.12.2015)

  • Make Excel examples compatible with 64-bit Excel version.
  • Remove 'emf' format from current.graphics

v0.9.1

8 years ago

0.9.1 (14.07.2015)

  • Fix converstion of #NUM! and other Excel errors. Now they are converted to NaN.
  • Add basic datetime supports
  • Add abitility to name pictures in Excel - so it can be updated from R
  • xl.workbook.open/xl.read.file now can read files from URL
  • Add active bindings to Excel ranges

v0.8.1

9 years ago

0.8.1 (06.05.2015)

  • RDCOMClient integration
  • options(excel_hwnd) to get specific Excel instance

0.7.5 (25.04.2015)

  • RStudio compatibility fix
  • Switch to RDoxygen for documentation
  • Release on Github
  • Excel examples
  • Reading/writing password-protected files