5 messages · vikrant, milton ruser, Dieter Menne +2 more
i am unable to open a file which is saved as .xlsx format in R . The file contains approximately 1,50,000 rows. So I m not able to save it as csv file.Please suggest ways to open this file
View this message in context: http://n4.nabble.com/how-to-open-excel-2007-xlsx-file-in-R-tp1017273p1017273.html Sent from the R help mailing list archive at Nabble.com.
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20100119/0d56a874/attachment.pl>
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.
See http://wiki.r-project.org/rwiki/doku.php?id=tips:data-io:ms_windows Most of the methods there work with xls files only but a few work with xlsx.
i am unable to open a file which is saved as .xlsx format in R . The file contains approximately ?1,50,000 rows. So I m not able to save it as csv file.Please suggest ways to open this file -- View this message in context: http://n4.nabble.com/how-to-open-excel-2007-xlsx-file-in-R-tp1017273p1017273.html Sent from the R help mailing list archive at Nabble.com.
______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
RExcel mention in the link below can transfer data from Excel 2007 to R. But you have to be on Windows, and you probably have to have Excel 2007. it might work if you have Excel 2003 with the (free) compatibility package installed.
See http://wiki.r-project.org/rwiki/doku.php?id=tips:data-io:ms_windows Most of the methods there work with xls files only but a few work with xlsx. On Tue, Jan 19, 2010 at 12:15 AM, vikrant <vikrant.shimpi at tcs.com> wrote:
i am unable to open a file which is saved as .xlsx format in R . The file contains approximately 1,50,000 rows. So I m not able to save it as csv file.Please suggest ways to open this file -- View this message in context: http://n4.nabble.com/how-to-open-excel-2007-xlsx-file-in-R-tp1017273p1017273.html Sent from the R help mailing list archive at Nabble.com.
______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.