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
