Let me read the article regarding "Names in
Formula", and see what you are trying to accomplish.
My time and schedule permitting, I'll provide you
with the answer you are looking for.
Remember, nothing is impossible!
Razzak
At 09:12 AM 5/3/2018, Stefan Maldet wrote:
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.
