Frank, given the inability to use Gateway in an EEP, if the functionality must be delivered in an EEP, could you format it via a report, then print that report, outputting to XLS?
I am only suggesting the possibility, as I have never done this, but it might offer you another avenue to a solution. P=1.0: Value <= $0.02, Steve in Memphis From: [email protected] [mailto:[email protected]] On Behalf Of A.G. IJntema Sent: Thursday, June 17, 2010 6:46am 06:46 To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Gateway Export in EEP Hi Frank, Your name looks Dutch maybe even Friesian. You can create an RGW at export by taking the first row at Select Format (gateway, export). The first option is Use Export wizard The you are able to create an export wizard and it can be saved as RGW. It took me also a while before I noticed this option The procedure can look like this GATEWAY EXPORT XLS <filename> + SELECT + <field1>, + <field2>, + ... <fieldn> + FROM <viewname> + WHERE <whereclause> + OPTION |SHOW_PROGRESS ON + |ACTION OPENVIEW + |SPECIFICATION_FILE_NAME <filename_rgw>.rgw However you cannot use this procedure in an EEP, because an EEP does not allow to make use of GATEWAY. Hope this helps Tony IJntema The Netherlands From: [email protected] [mailto:[email protected]] On Behalf Of frank van der Zwaag Sent: donderdag 17 juni 2010 13:22 To: RBASE-L Mailing List Subject: [RBASE-L] - Gateway Export in EEP Hi All, does anybody have a sample EEP script that I can use to export the data from a view into an xls spreadsheet using a pre-defined export format (rgw) file. Thanks
