Re: [RBASE-L] - gateway export to xlsx

2018-04-05 Thread A. Razzak Memon
Dan, Here's how ... Try the example below using the sample RRBYW19 database. -- Example -- Create XLSX file with Header, Footer, Style and Tab Name -- Author: A. Razzak Memon -- Date Created: April 5, 2018 -- Last Updated: IF (CVAL('DATABASE')) <> 'RRBYW19' OR (CVAL('DATABASE')) IS NULL THEN

RE: [RBASE-L] - gateway export to xlsx

2018-04-05 Thread Buddy Walker
Behalf Of Dan Goldberg Sent: Thursday, April 5, 2018 5:20 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - gateway export to xlsx I am using a command line export to xls like the sample. GATEWAY EXPORT XLS Customers_123.xls + SELECT + Company AS `Company Name`, + CustID AS `Custo

[RBASE-L] - gateway export to xlsx

2018-04-05 Thread Dan Goldberg
I am using a command line export to xls like the sample. GATEWAY EXPORT XLS Customers_123.xls + SELECT + Company AS `Company Name`, + CustID AS `Customer ID`, + CustAddress AS `Company Address`, + (CustCity+',') AS `City, State, and Zip Code` + FROM Customer ORDER by Company + OPTION