John,
I think what is happening has to do with your column names.
I had to create a specific XLS report to make sure everything turned out
the way I wanted.
You can also do this
GATEWAY EXPORT XLS +
MyFileName.XLS +
SELECT +
ListofColumns +
FROM MyTableName +
WHERE MyWhereClause +
OPTION COL_NAMES ON +
|SHOW_PROGRESS ON +
|MESSAGES OFF +
|BLANK_IF_ZERO ON +
|ACTION OPENVIEW
RETURN
Jan
----- Original Message -----
From: "John Engwer" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Tuesday, September 30, 2008 7:37 AM
Subject: [RBASE-L] - Extra columns in XLS spreadsheet
I am creating a one sheet XLS spreadsheet and I am getting a blank column
after each data column. All of the data is there.
Here is my print command:
PRINT mailer_xls_out OPTION XLS +
|FILENAME C:\OSSA\MAILER\MAILER.XLS +
|SHOW_CANCEL_DIALOG OFF +
|CELL_ATTR ON +
|INCLUDE_RICH_TEXT OFF +
|RICHTEXT_ENCODING_TYPE IMAGE +
|LINE_SPACE ACTUAL +
|ONE_SHEET_PER_PAGE OFF |OPEN ON
How can I eliminate the blank columns?
John
