Can someone tell me how to analyse data from a .xls file to perform a SPIA analysis? How do I have to load the data?
Asked
Active
Viewed 226 times
0
-
Do you mean and XLS file? as in Excel? – Derek Corcoran Jan 09 '17 at 15:50
-
Yes, I need to import a file but using "read.table" is retrieving me a lot of NA spaces – Sarah Decker Jan 09 '17 at 15:56
-
Save xls files as CSV, then us `read.csv`. – zx8754 Jan 09 '17 at 17:28
-
1Also note, Excel likes to convert some [gene names into dates](http://bmcbioinformatics.biomedcentral.com/articles/10.1186/1471-2105-5-80) – zx8754 Jan 09 '17 at 17:37
1 Answers
0
you can use the xlsx package:
require(xlsx)
read.xlsx("myfile.xlsx", sheetName = "Sheet1")
you have to tell which of your sheets you need to read.

Derek Corcoran
- 3,930
- 2
- 25
- 54