Fetch data from an open excel sheet into R?

Question

I am wondering is it possible to read an excel file that is currently open, and capture things you manually test into R?

I have an excel file opened (in Windows). In my excel, I have connected to a SSAS cube. And I do some manipulations using PivotTable Fields (like changing columns, rows, and filters) to understand the data. I would like to import some of the results I see in excel into R to create a report. (I mean without manually copy/paste the results into R or saving excel sheets to read them later). Is this a possible thing to do in R?

UPDATE

I was able to find an answer. Thanks to awesome package created by Andri Signorell.

library(DescTools)
fxls<-GetCurrXL()
tttt<-XLGetRange(header=TRUE)

Answer 1

I was able to find an answer. Thanks to awesome package created by Andri Signorell.

library(DescTools)
fxls<-GetCurrXL()
tttt<-XLGetRange(header=TRUE)

Answer 2

You can save the final excel spreadsheet as a csv file (comma separated). Then use read.csv("filename") in R and go from there. Alternatively, you can use read.table("filename",sep=",") which is the more general version of read.csv(). For tab separated files, use sep="\t" and so forth.

I will assume this blog post will be useful: http://www.r-bloggers.com/a-million-ways-to-connect-r-and-excel/

In the R console, you can type

?read.table

for more information on the arguments and uses of this function. You can just repeat the same call in R after Excel sheet changes have been saved.

Answer 3

Copy the values you are interested in (in a single spread sheet at a time) to clipboard.

Then

dat = read.table('clipboard', header = TRUE, sep = "\t")