[R] odbcConnectExcel2007 creates corrupted files

I tried creating a .xlsx file using odbcConnectExcel2007 and adding a worksheet with sqlSave. This seems to work, I am even able to query the worksheet, but when I try opening the file in Excel I get the following message: "Excel cannot open the file 'test.xlx' because the file format or file e

Re: [R] odbcConnectExcel2007 connection error

You could try the other methods listed here to see if any of then work in this case: http://wiki.r-project.org/rwiki/doku.php?id=tips:data-io:ms_windows On Wed, Feb 3, 2010 at 12:46 AM, Liam Blanckenberg wrote: > Hi all, > > Apologies if I violate any posting etiquette - this is my first > submis

[R] odbcConnectExcel2007 connection error

Hi all, Apologies if I violate any posting etiquette - this is my first submission to the R mailing list. I regularly use 'odbcConnectExcel2007' (from package 'RODBC') to read data from named ranges in excel workbooks into R. I recently received the following error message when attempting to set u

Re: [R] odbcConnectExcel2007

On Tue, 28 Oct 2008, Agnolucci, Paolo wrote: Hi sorry if this is really basic but I am just starting on R. Can anyone point me at how to write R objects into Excel 2007 files. I have seen how to set up a connection to a file through odbcConnectExcel2007(xls.file, readOnly = FALSE, ...) but

Re: [R] odbcConnectExcel2007

Agnolucci, Paolo wrote: > > Hi > > > > sorry if this is really basic but I am just starting on R. > > > > Can anyone point me at how to write R objects into Excel 2007 files. I > have seen how to set up a connection to a file through > odbcConnectExcel2007(xls.file, readOnly = FALSE, ...

[R] odbcConnectExcel2007

Hi sorry if this is really basic but I am just starting on R. Can anyone point me at how to write R objects into Excel 2007 files. I have seen how to set up a connection to a file through odbcConnectExcel2007(xls.file, readOnly = FALSE, ...) but it doesn't say anything on how to write data