Thanks Dennis, I currently am using the process that you suggest but I wanted to have the ability to create a better looking title block. Also, the zip code column, which is text, always ends up right justified when I create a CSV file. That is why I decided to use the RBASE report to XLS. Everything looks good, a nice title block and all of the data is there. The ONLY problem is the extra columns that it creates.
John From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis McGrath Sent: Tuesday, September 30, 2008 4:55 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Extra columns in XLS spreadsheet My personal preference is to create a clean CSV file and just launch it. The easiest way to accomplish this is to populate a temporary table with the prepared data Then you do something like this: SET EOF OFF SET NULL ' ' Output &vCSVfile WRI '"ColTitle1","ColTitle2","ColTitle3"' --Notice the above is using double quotes around the names, but single quotes around the whole string SET Quotes=NULL SET Quotes=" Unload data from temptable using all SET Quotes=NULL SET Quotes=' OUTPUT SCREEN SET EOF ON set null '-0-' LAUNCH &vCSVfile This creates a file which uses double quotes as the text delimiter. I have never had a problem with formatting. The user may want to adjust or format their columns to suit, but the data will always be consistent. Dennis McGrath _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Engwer Sent: Tuesday, September 30, 2008 2:54 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Extra columns in XLS spreadsheet I appears that the required cell width is not being recognized by Excel when the data is passed from a report. If the data is wider than the default cell width in Excel, then an extra column is inserted. If the data width is =< the default no extra column is not created. The Excel width automatically adjusts if you export the same data via the browse or gateway. John From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Engwer Sent: Tuesday, September 30, 2008 2:12 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Extra columns in XLS spreadsheet Thanks Gary and Sami, I am using Arial 10 and I have tried other fonts also. At this point, I have no title, no column names; just data in the report and I still get the extra columns. If I export the same data to XLS using browse, there are no extra columns. I can't think of anything else to do. Maybe the print to XLS is not working properly. I will play with it a little more before I give up. John From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Gary Wendike Sent: Tuesday, September 30, 2008 1:40 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Extra columns in XLS spreadsheet 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
