Commits

Antonio Alvarado Hernández committed 37360ba

my first attempt to read data from a BV's report

* created a function to read reviews from an Excel .XLS file downloaded
from the BV's workbench

Comments (0)

Files changed (1)

R/BazaarR/BazaarR.R

+# BazaarR.R - random stuff to work with BazaarVoice's reports
+
+require("RODBC", quietly)
+
+read.reviews <- function (filename) {
+    channel <- odbcConnectExcel(filename)
+    reviews <- sqlFetch(channel, "All Reviews Report")
+    close(channel)
+    return(reviews)
+}
+
+# EOF