The following code works from an EEP:
vfile_out - pre-defined Excel file name
vtab - pre-defined name for the Excel tab
==========================
SET VAR vcomm = ('GATEWAY EXPORT xls ' + .vfile_out +
+ 'SELECT labor_date,labor_hr_reg,labor_hr_ot,labor_hr_2times,labor_hr_all +
FROM temp_graph1 OPTION col_names ON +
|tab_name ' + .vtab + ' +
|show_progress ON +
|action openview')
&vcomm
==========================
Javier,
Javier Valencia, PE
913-829-0888 Office
913-915-3137 Cell
913-649-2904 Fax
[email protected]
________________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of frank van
der Zwaag
Sent: Thursday, June 17, 2010 6:22 AM
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
