[R] how to open excel 2007 (.xlsx) file in R

Dieter Menne dieter.menne at menne-biomed.de
Tue Jan 19 09:14:34 CET 2010



vikrant wrote:
> 
> i am unable to open a file which is saved as .xlsx format in R . The file
> contains approximately  1,50,000 
> rows. 
> 

Use odbcConnectExcel2007 in package RODBC to read these data. 

>>So I m not able to save it as csv file. 

I do not understand why you want to use R to convert an xlsx file to csv.
Even if you are a command line aficionado, I recommend to use the features
of Excel to do this.

Dieter
-- 
View this message in context: http://n4.nabble.com/how-to-open-excel-2007-xlsx-file-in-R-tp1017273p1017327.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list