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
