excel.link - 0.9.13

0.9.13 (07.07.2024)

• Fixes for future R version (thanks to Tomas Kalibera)

- R
Published by gdemin over 1 year ago

excel.link - 0.9.12

0.9.12 (16.01.2024)

• minor fixes

- R
Published by gdemin about 2 years ago

excel.link - 0.9.10

0.9.10 (26.10.2021)

• update for R4.2

- R
Published by gdemin over 4 years ago

excel.link - v0.9.8-1

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 RConnectionExamples.xlsm we use default version of R, not 32-bit version (issue #13)

- R
Published by gdemin almost 8 years ago

excel.link - v0.9.7

0.9.7 (30.04.2017)

• Add option to get full path to workbooks (https://github.com/gdemin/excel.link/issues/7)
• Now xl.workbook.open doesn't try to open already open workbook (https://github.com/gdemin/excel.link/issues/6)
• Add xl(*)n family of functions. They create new sheet before and then output data on it.
• Add very basic formatting support via xl.property
• Add xl.write method for 'etable' class from 'expss' package - https://gdemin.github.io/expss/

- R
Published by gdemin almost 9 years ago

excel.link - v0.9.5

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

- R
Published by gdemin over 9 years ago

excel.link -

0.9.3 (06.12.2015)

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

- R
Published by gdemin about 10 years ago

excel.link -

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

- R
Published by gdemin over 10 years ago

excel.link -

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

- R
Published by gdemin almost 11 years ago