Hi, First, sorry for my english.
I have the same problem in the Spain version of Excel. I do the next to solve¿? the problem: -In "Regional Configuration" of the "Control Panel" i put the language on "English (USA)" -I put, in the tab "Numbers", the comma as decimal and the point for miles ( and point comma as list). -I put, in the tab "Money", the comma as decimal and the point for miles. -In the Excel tab International from the menu Options, i put the same configuration the comma as decimal and the point for miles. Then the PutDataframe works Jose Luis Gilsanz Gomez Tasaciones Hipotecarias - Estadistica Atisreal España Maria de Molina,54 28006 Madrid Tel. +34 91 454 96 94 Fax +34 91 782 21 64 [EMAIL PROTECTED] www.atisreal.es - www.tasacionesh.es Tildes ortograficas omitidas intencionadamente por motivos de compatibilidad I opened the file (USEnglish Windows and USEnglish Excel) and it immediately worked. So I need more information in what happened in the French version of Excel and/or Windows. [EMAIL PROTECTED] wrote: > Hi Eric, > > Ive attached an example Excel file with the data that we were trying to read in using put.dataframe in the French locale. You will see that there are no date fields present. > > Regards > > Wayne > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Erich > Neuwirth > Sent: 07 April 2008 12:48 > To: R (D)COM and RExcel server related issues > Subject: Re: [Rcom-l] RExcel Language > > > PutDataframe essentially does a PutArray for each column (= variable) > of a dataframe. It does a lot opf strange things to detect dates. > So I need more information what the dataframe contained to see why > things went wrong. > > > > [EMAIL PROTECTED] wrote: >> Hi there, >> >> I recently deployed an RExcel spreasheet to a colleague based in France. >> We had trouble reading in data to R using "Rinterface.Putdataframe" >> command from VBA. >> After some investigation we realised that the trouble emerged from >> the fact that Excel was using comma's instead of a decimal point, as >> is the convention in France. >> >> We had more success by using "Rinterface.PutArray" and it seems to >> read in the numbers correctly. >> I guess the problem might occur because dataframes can expect >> non-numeric fields and there may be some confusion as to whether a >> value is a text value or a numeric value with a comma for a decimal >> point. >> >> Has anyone else encountered this problem? If so can anyone offer some >> advice on how to deal with this. >> >> We are using R 2.6.1 (French language) and the latest version of the >> R(D)Com. >> >> Regards, >> >> Wayne >> >> >> >> >> >> --------------------------------------------------------------------- >> ------------------- >> >> Wayne Jones >> Statistical Consultant >> Shell Global Solutions (UK) >> Shell Technology Centre Thornton, P.O. Box 1, Chester CH1 3SH, United >> Kingdom >> >> *Tel:* +44 (0) 151 373 5977* * >> *Fax:* +44 (0) 151 373 5384* * >> *Mobile:* +44 (0) 7896 536026 >> *Email:* [EMAIL PROTECTED] >> *Internet:*** www.shell.com/globalsolutions/statisticsandchemometrics >> >> /Shell Global Solutions (UK) is a division of Shell Research Limited >> which has its Registered Office at Shell Centre, London SE1 7NA and >> is registered in England & Wales with No.539964./ >> >> >> >> >> --------------------------------------------------------------------- >> --- >> >> _______________________________________________ >> Rcom-l mailing list >> Rcom-l@mailman.csd.univie.ac.at >> http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l >> More information (including a Wiki) at http://rcom.univie.ac.at > -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 _______________________________________________ Rcom-l mailing list Rcom-l@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at
