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.

Author
Julien MOEYS <Julien.Moeys@mark.slu.se>
Date of publication
2016-06-09 09:02:35
Maintainer
Julien MOEYS <Julien.Moeys@mark.slu.se>
License
AGPL-3
Version
0.7.7
URLs

View on R-Forge

Man pages

easyrodbcexcel-package
Simple database interface for RODBC Excel.
edbColnames.RODBC_Excel
Retrieve column names of a table in a MS Excel file...
edbDelete.RODBC_Excel
NOT SUPORTED FOR EXCEL. Delete all or some rows in a table in...
edbDrop.RODBC_Excel
Drop a table in a MS Excel file (referenced by 'edb').
edbNames.RODBC_Excel
Retrieve table names in a MS Excel file (referenced by...
edbNRow.RODBC_Excel
Retrieve the number of rows of a table in a database...
edbQuery.RODBC_Excel
Send and retrieve a query in an MS Excel database (referenced...
edbRead.RODBC_Excel
Read all or part of a table in a MS Excel file (referenced by...
edbWrite.RODBC_Excel
Write data in a MS Excel table in a database (referenced by...
z[_-.RODBC_Excel
"[<-" method for MS Excel files. Write data in a MS Excel...
z[.RODBC_Excel
"[" method for reading all or part of a table in a MS Excel...

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