1286 search results for "excel"

Using R.Net in an Excel Add in

May 31, 2012
By

I thought I’d try out R.net and in doing so I have put together a very simple Excel 2007 add in that connects Excel to R. I’m using .Net 4.0 in Visual Studio 2010 pro with the latest commit of R.Net, … Continue reading →

Read more »

Excel Import into R without rJava

May 17, 2012
By

In my ongoing quest to webappify various R scripts I discovered that rApache cannot load any R packages that depend on rJava.  For several of the scripts that I've written that grab data out of MS Excel files, and therein use the xlsx package, thi...

Read more »

An embarrassing admission; Copy pasting tables with text containing spaces from Excel to R

May 11, 2012
By
An embarrassing admission; Copy pasting tables with text containing spaces from Excel to R

I can’t believe I didn’t learn how to do it earlier, but I never knew how to accurately copy tables from excel that had text with spaces in them, and paste into a data frame in R without generating confusion … Continue reading →

Read more »

See R integrated with QlikView, Jaspersoft, Excel, and mobile apps

May 9, 2012
By

In yesterday's webinar, Revolution Analytics CTO David Champagne demonstrated how to integrate statistical graphics and analytic computations created using R software with a variety of third-party applications. In each case Revolution R Enterprise Server is running as a compute server to the client application, with R scripts launched on each user interaction via the RevoDeployR Web Services API. David...

Read more »

PostgreSQL, Excel, R, and a Really Big Data Set!

April 19, 2012
By
PostgreSQL, Excel, R, and a Really Big Data Set!

At work I’ve started to work with the biggest data set I’ve ever seen!  First, let me qualify my use of the term “Big Data”.  The number of rows in the resultant data set (after much transformation and manipulation in … Continue reading →

Read more »

Calling Systematic Investor Toolbox from Excel using RExcel & VBA

April 9, 2012
By
Calling Systematic Investor Toolbox from Excel using RExcel & VBA

RExcel is a great tool to connect R and Microsoft Excel. With a press of a button, I can easily execute my R scripts and present output interactively in Excel. This easy integration allows non-R users to explore the power R language. As an example of this approach, I want to show how to create

Read more »

How to read an excel file (dot xls and dot xlsx) into a data frame with r

March 17, 2012
By
How to read an excel file (dot xls and dot xlsx) into a data frame with r

how to read an excel file (dot xls and dot xlsx) into a data frame with r

Read more »

Write data (frame) to Excel file using R package xlsx

February 12, 2012
By
Write data (frame) to Excel file using R package xlsx

Writing to Excel files comes up rather often, especially if you’re collaborating with non-OSS users. There are several options, but I like the xlsx package way of doing things. Authors use Java to write to Excel files, which are basically compressed XML files. Alright, let’s get cracking. First, let’s create some data. If you don’t

Read more »

an easy way to writing data.frame to Excel

November 16, 2011
By

you can write it aswrite.table(r.data.frame, "excel.file.xls", sep="\t", na="", row.names=F)which I can usually open in Excel just by clicking on it.Credit: http://tolstoy.newcastle.edu.au/R/help/05/04/3388.html

Read more »

Reading Excel data is easy with JGR and XLConnect

October 30, 2011
By

Despite the fact that Excel is the most widespread application for data manipulation and (perhaps) analysis, R's support for the xls and xlsx file formats has left a lot to be desired. Fortunately, the XLConnect package has been created to fill this void, and now JGR 1.7-8 includes integration with XLConnect package to load .xls

Read more »