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.
Dear V.K., 1. http://www.R-project.org/posting-guide.html<http://www.r-project.org/posting-guide.html> 2. it is - in general - good someone that write to the list identify your self. It is a polite way of participate of the list. bests milton On Tue, Jan 19, 2010 at 12:15 AM, vikrant <vikrant.shimpi@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@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<http://www.r-project.org/posting-guide.html> > and provide commented, minimal, self-contained, reproducible code. >[[alternative HTML version deleted]]
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.
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. >
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. On Jan 19, 2010, at 2:09 PM, Gabor Grothendieck wrote:> 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. >