Gunnar & Jan, I like to use the print report to create the spreadsheet because I can include a title block at the top of the spreadsheet. If I use the gateway function I lose the ability to do so. I hope I can find a way to make print report work properly. John
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Gunnar Ekblad Sent: Tuesday, September 30, 2008 11:01 AM To: RBASE-L Mailing List Subject: [RBASE-L] - SV: Extra columns in XLS spreadsheet John I am afraid I cant answer your question. But I can tell you how I do. When it comes to R:Base to Excel I use only 2 methods. Browse (normally a view) and export to xls or From excel I do an ODBC read from my R:Base Database to my predefined excel report. When it comes to print I never figured it out how to get it into excel the way I wanted. However I think PDF reports works great and that is the preferred format anyway. Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[EMAIL PROTECTED] För John Engwer Skickat: den 30 september 2008 16:38 Till: RBASE-L Mailing List Ämne: [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
