1253 search results for "excel"

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 »

Migrating from SPSS/Excel to R, Part 3: Preparing your Data

October 29, 2011
By
Migrating from SPSS/Excel to R, Part 3: Preparing your Data

In this post, I describe how to prepare your data for migrating between SPSS/Excel and R. This is the third …Continue reading »

Read more »

XLConnect – A platform-independent interface to Excel

August 31, 2011
By
XLConnect – A platform-independent interface to Excel

XLConnect is a comprehensive and platform-independent R package for manipulating Microsoft Excel files from within R. XLConnect differs from other related R packages in that it is completely cross-platform and as such runs under Windows, Unix/Linux and Mac (32- and 64-bit). Moreover, it … Continue reading →

Read more »

Migrating from SPSS/Excel to R, Part 2: Working with Packages

July 17, 2011
By
Migrating from SPSS/Excel to R, Part 2: Working with Packages

In this post, I cover an important aspect of using R that users of SPSS/Excel won’t be familiar with: working …Continue reading »

Read more »

Migrating from SPSS/Excel to R

July 10, 2011
By
Migrating from SPSS/Excel to R

In this post, I give an outline for those interested in migrating from using SPSS and Excel for data processing/analysis …Continue reading »

Read more »

Yet another way to use R in Excel for .NET programmer

July 6, 2011
By
Yet another way to use R in Excel for .NET programmer

I wrote the article whose title is "Another way to use R in Excel for .NET programmer" last night.In that article, We need to use IDE to write C# program.On ther other hand, Excel-DNA give us easier way to create XLL.Let me show you one ...

Read more »