Re: [R] Problem in reading Excel spreadsheets

2010-12-01 Thread Stephen Liu
Stephen L From: Ivan Calandra Cc: r-help@r-project.org Sent: Wed, December 1, 2010 6:57:12 PM Subject: Re: [R] Problem in reading Excel spreadsheets Hi again, There are also other packages to read and write xls files, including gdata (read), dataframe2xls and wr

Re: [R] Problem in reading Excel spreadsheets

2010-12-01 Thread Gabor Grothendieck
On Wed, Dec 1, 2010 at 2:56 AM, Stephen Liu wrote: > Hi folks, > > Win 7 64bit > R 2.12.0 32bit > > Problem in reading Excel spreadsheets > There are quite a few alternatives for reading Excel spreadsheets. They are listed here: http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows --

Re: [R] Problem in reading Excel spreadsheets

2010-12-01 Thread Ivan Calandra
oject.org *Sent:* Wed, December 1, 2010 5:05:40 PM *Subject:* Re: [R] Problem in reading Excel spreadsheets Hi, I don't know much about RODBC, but the package xlsReadWrite works pretty well for me for reading and writing xls files (and it doesn't need Perl or anything else to run). Ivan Le

Re: [R] Problem in reading Excel spreadsheets

2010-12-01 Thread Stephen Liu
ib() : currently only windows (32 bit) supported xls.getshlib only runs on 32 bit Windows. I must go back to 32 bit Win 7. B.R. Stephen L From: Ivan Calandra To: r-help@r-project.org Sent: Wed, December 1, 2010 5:05:40 PM Subject: Re: [R] Problem in reading Ex

Re: [R] Problem in reading Excel spreadsheets

2010-12-01 Thread Ivan Calandra
Hi, I don't know much about RODBC, but the package xlsReadWrite works pretty well for me for reading and writing xls files (and it doesn't need Perl or anything else to run). Ivan Le 12/1/2010 08:56, Stephen Liu a écrit : Hi folks, Win 7 64bit R 2.12.0 32bit Problem in reading Excel sprea

[R] Problem in reading Excel spreadsheets

2010-11-30 Thread Stephen Liu
Hi folks, Win 7 64bit R 2.12.0 32bit Problem in reading Excel spreadsheets (the text file, research_databaseI.xls, was download on Internet) > data=odbcConnectExcel(file.choose()) > sqlTables(data) TABLE_CAT TABLE_SCHEM 1 C:\\Users\\satimiswin7