This is a good reminder for a problem I need to solve anyhow!
Christian Prinoth wrote: > 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 > > > ------------------------------------------------------------------------ > > > No virus found in this incoming message. > Checked by AVG - http://www.avg.com > Version: 8.0.173 / Virus Database: 270.7.6/1711 - Release Date: 10/6/2008 > 5:37 PM > -- 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