how to open excel 2007 (.xlsx) file in R
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.