easyrodbcexcel: Simple database interface for RODBC Excel.

Simple database interface for RODBC Excel. Package build on top of RODBC. Provides functions for reading, writing, listing and subsetting tables in Excel. Allows to retrieve, write and subset Excel files's spreadsheets in a similar way as data.frame's, using single square brackets db[,,,]. easyrodbcexcel internalise many database operations (otherwise tedious) such as rows and columns subsetting (no SQL needed) and connection and disconnection to / from databases.

AuthorJulien MOEYS <Julien.Moeys@mark.slu.se>
Date of publication2016-06-09 09:02:35
MaintainerJulien MOEYS <Julien.Moeys@mark.slu.se>
LicenseAGPL-3
Version0.7.7
http://easydb.r-forge.r-project.org/

View on R-Forge

Files in this package

easyrodbcexcel/DESCRIPTION
easyrodbcexcel/NAMESPACE
easyrodbcexcel/NEWS
easyrodbcexcel/R
easyrodbcexcel/R/easyrodbcexcel.R easyrodbcexcel/R/onAttach.R
easyrodbcexcel/inst
easyrodbcexcel/inst/SVN_VERSION
easyrodbcexcel/inst/soils.xls
easyrodbcexcel/inst/soils.xlsx
easyrodbcexcel/man
easyrodbcexcel/man/easyrodbcexcel-package.Rd easyrodbcexcel/man/edbColnames.RODBC_Excel.Rd easyrodbcexcel/man/edbDelete.RODBC_Excel.Rd easyrodbcexcel/man/edbDrop.RODBC_Excel.Rd easyrodbcexcel/man/edbNRow.RODBC_Excel.Rd easyrodbcexcel/man/edbNames.RODBC_Excel.Rd easyrodbcexcel/man/edbQuery.RODBC_Excel.Rd easyrodbcexcel/man/edbRead.RODBC_Excel.Rd easyrodbcexcel/man/edbWrite.RODBC_Excel.Rd easyrodbcexcel/man/z[.RODBC_Excel.Rd easyrodbcexcel/man/z[_-.RODBC_Excel.Rd
easyrodbcexcel/tests
easyrodbcexcel/tests/edbColnames.RODBC_Excel.R
easyrodbcexcel/tests/edbDelete.RODBC_Excel.R
easyrodbcexcel/tests/edbDrop.RODBC_Excel.R
easyrodbcexcel/tests/edbNames.RODBC_Excel.R
easyrodbcexcel/tests/edbQuery.RODBC_Excel.R
easyrodbcexcel/tests/edbRead.RODBC_Excel.R
easyrodbcexcel/tests/edbWrite.RODBC_Excel.R

Questions? Problems? Suggestions? or email at ian@mutexlabs.com.

All documentation is copyright its authors; we didn't write any of that.