Thanks, sorry for bringing up a known issue. Christian
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, October 07, 2008 13:05 To: rcom-l@mailman.csd.univie.ac.at Subject: RE: [Rcom-l] Bug Report Hi Christian, I have also come across this problem. I know Erich is aware of this issue and he has advised me that this will be ammended in future releases of RExcel. In the meantime I suggest you use short filenames and worksheet names. Regards, Wayne -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Christian Prinoth Sent: 07 October 2008 11:29 To: R (D)COM and RExcel server related issues Subject: [Rcom-l] Bug Report Hi, the function ArrayFromSheet at a certain point uses the function Evaluate to read in an array. The problem is, in certain cases the variable ExcelDataRangeName may be so long that the whole string cmdString gets longer than the maximum allowed (I think 255), which means that the statement res = Evaluate(cmdString) always returns Error 2015. Maybe there should be some kind of safety check on this. Or maybe it is not necessary to include the workbook name in ExcelDataRangeName? In my case, ExcelDataRangeName is the following: '[Andamento Fattori luglio-ottobre 2008.xls]27-06-2008'!$C$2:$C$601 Thus ?len(cmdstring) returns 260 Cheers Christian DISCLAIMER: L'utilizzo non autorizzato del presente messaggio è vietato e potrebbe costituire reato. Le informazioni e le opinioni contenute in questo messaggio sono inviate dal mittente a proprio nome e non costituiscono una posizione ufficiale di Epsilon SGR. Questo messaggio e' confidenziale e se non e' a Lei indirizzato Le saremmo grati se, via e-mail, ne comunicasse l'errata ricezione al mittente. The information and opinions contained in this message do not constitute an official position of Epsilon SGR and are communicated by the sender in is own name. This message is confidential, if you are not the intended recipient, please notify the sender immediately. The information and opinions contained in this message do not constitute an official position of Epsilon SGR and are communicated by the sender in his own name. This message is confidential, if you are not the intended recipient, please notify the sender immediately. _______________________________________________ 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 DISCLAIMER: L'utilizzo non autorizzato del presente messaggio è vietato e potrebbe costituire reato. Le informazioni e le opinioni contenute in questo messaggio sono inviate dal mittente a proprio nome e non costituiscono una posizione ufficiale di Epsilon SGR. Questo messaggio e' confidenziale e se non e' a Lei indirizzato Le saremmo grati se, via e-mail, ne comunicasse l'errata ricezione al mittente. The information and opinions contained in this message do not constitute an official position of Epsilon SGR and are communicated by the sender in is own name. This message is confidential, if you are not the intended recipient, please notify the sender immediately. The information and opinions contained in this message do not constitute an official position of Epsilon SGR and are communicated by the sender in his own name. This message is confidential, if you are not the intended recipient, please notify the sender immediately. _______________________________________________ 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
