Re: [R] Loading Excel file into Limma

From: Wensui Liu <liuwensui_at_gmail.com>
Date: Thu 12 Jan 2006 - 15:25:42 EST

no idea bout limma. but you could load excel data into R by using rodbc. here is a sample code and hope it helpful.

library(RODBC);

###########################################################
# 1. READ DATA FROM EXCEL INTO R #
###########################################################
xlsConnect<-odbcConnectExcel("C:\\temp\\demo.xls"); demo<-sqlFetch(xlsConnect, "Sheet1");
odbcClose(xlsConnect);
rm(demo);

On 12 Jan 2006 03:48:26 +0000, N. Goodacre <ng296@cam.ac.uk> wrote:
>
> Dear mailing group,
>
> This is my first time here. Glad to have this resource!
>
> I am currently trying to load an Excel file into R (limma package
> loaded)
> using the source(*name of directory*) command, but it cannot open the
> file.
> I renamed the file as .R and .RData, to no avail. The Excel data contains
> one gene name per row and about 100 data points per gene (columns).
>
> I am only used to loading preprepared microarray data with all the t's
> crossed and i's dotted, with the read.maimages command. Can anyone help me
> out with this silly-sounding "challenge"?
>
> Sincerely - in the truest sense -
>
> Norman Goodacre
>
> ______________________________________________
> R-help@stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide!
> http://www.R-project.org/posting-guide.html
>

--
WenSui Liu
(http://statcompute.blogspot.com)
Senior Decision Support Analyst
Health Policy and Clinical Effectiveness
Cincinnati Children Hospital Medical Center

	[[alternative HTML version deleted]]

______________________________________________
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
Received on Thu Jan 12 15:35:57 2006

This archive was generated by hypermail 2.1.8 : Thu 12 Jan 2006 - 18:23:16 EST