John, what I have had to do in the past is create a specific xls report. The xls report had to have the locations of columns adjusted in order to correctly lineup within the spreadsheet. Then number of columns and required spacing may change the size of page. Use what is necessary to print the report to the xls spreadsheet. The key is to line up the columns as to how they will fit in the Excel spreadsheet. I would recommend you use a very common font...example - Arial 10. You also can eliminate some of the lines that you would draw on a report for separation they won't transfer as you want.
Gary ----- Original Message ---- From: John Engwer <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Tuesday, September 30, 2008 9:37:50 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
