1242 search results for "excel"

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 »

Another way to use R in Excel for .NET programmer

July 5, 2011
By
Another way to use R in Excel for .NET programmer

As you know, RExcel give us a way to combine R with Excel.But, It just bothering to install some COMs and maybe not be programming but excel manipulation!If you are a .NET programmer, there is another way to call R from Excel.I would like to ...

Read more »