Thanks for your fast response but this is not what I mean. Please have a look on this page http://www.excel-easy.com/examples/names-in-formulas.html The word name makes for a confusion in this case. I need to define and name a constant in my Excel file.
Best regards, Stefan -----Ursprüngliche Nachricht----- Von: [email protected] [mailto:[email protected]] Im Auftrag von A. Razzak Memon Gesendet: Donnerstag, 3. Mai 2018 15:06 An: [email protected] Betreff: Re: [RBASE-L] - Gateway XLS 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. -- 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.
