Stepfan, Use may use the "AS" option to define names when creating XLS.
Here's how ... -- GATEWAY_EXPORT_XLS.RMD -- Start here CONNECT RRBYW19 SET ERROR MESSAGE 2077 OFF DELETE InvoiceHeader.xls SET ERROR MESSAGE 2077 ON GATEWAY EXPORT XLS InvoiceHeader.xls + SELECT TransID AS `Invoice No`, + TransDate AS `Invoice Date`, + NetAmount AS `Sub Total`, + Freight, Tax, + InvoiceTotal AS `Invoice Total` + FROM InvoiceHeader ORDER BY TransID + OPTION COL_NAMES ON + |HEADER_TEXT Customer Invoices + |FOOTER_TEXT Quarterly Report + |SHEET_NAME Invoices + |ACTION OPENVIEW RETURN -- End here See attached sample for your viewing pleasure. Hope that helps! Very Best R:egards, Razzak At 08:15 AM 5/3/2018, you wrote:
Hello together,Is there a way to use the Gateway Export xls command and define names, as I can do it in the namesmanager of the Excel file to get the result, as you can see in the following image?That would be really great … Thanks for your help, Best regards, Stefan
-- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php--- You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
InvoiceHeader.xls
Description: Binary data
