Releases: gdemin/excel.link
Releases · gdemin/excel.link
0.9.12
0.9.10
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 R_Connection_Examples.xlsm we use default version of R, not 32-bit version (issue #13)
v0.9.7
0.9.7 (30.04.2017)
- Add option to get full path to workbooks (#7)
- Now xl.workbook.open doesn't try to open already open workbook (#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/
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
v0.9.3
v0.9.1
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