At 11:58 AM 7/23/2010, Dennis McGrath wrote:
R:BASE 7.6
GATEWAY EXPORT command XLS
What is the correct syntax to include column headers in the XLS
file.
I can do it with the gateway user interface but cannot seem to
get it to work with the command line command.
Here's how:
OPTION COL_NAMES ON
Example:
GATEWAY EXPORT XLS filename.xls SELECT ALL FROM tableviewname +
WHERE whereclause OPTION Col_NAMES ON
For complete list of OPTIONS, details and examples:
01. HELP GATEWAY | Export | XLS
02. R:Docs | Main Menu | Command Line GATEWAY EXPORT
03. R:Syntax: http://www.RSyntax.com/RBG90
Very Best R:egards,
Razzak.
