Depending on the report structure(how the columns are laid out and the width of the columns), it is difficult at best to create an XLS file when printing from RBase if the report structure is not nicely laid out. This entails playing with the column positions on the report itself.
Jim's option is very viable and will work everytime. You could also try printing using a DIF format. It will print and be opened by XLS. You can then resave with and XLS extension. This may not work but I would try before creating the temporary. The only other option to get the information correctly is as Jim suggested. Gary From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, November 24, 2011 11:50 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Creating Excel FIles This is just not working for me: Create a report with columns across the form, no headings etc., plain text. data. (Even converted a note to text). Print the report which displays on screen, select file output and choose the Excel option. The Excel file generated is all messed up, has even two of the columns in the same cells and several not displayed at all. Tried lots of stuff but no luck. Thanks for any advice. Robert A.
