[RBASE-L] - Printing Reports to Excel Questions

[Bill Eyring]

I have several questions regarding printing reports to an Excel file.
 
1. When I print a report to the screen or a printer the column headings and
data are aligned. When I print to an excel file the data columns become
offset to the column headings. How do I align the column headings with the
corresponding data columns ?
 
2. I use the following command to print a report to an Excel file;
 
  SET V VFILE='AgencyActivity.xls'
  print CLIsum +
    option XLS +
    |FILENAME .vfile +
    |all_text_in_general_format off +
    |cell_attr on +
    |include_images off +
    |include lines off +
    |line_space actual +
    |one_sheet_per_page off +
    |open on
 
everything prints as specified to the Excel file. However if I use;
 
print CLIsum +
  option XLS +
  open on
 
the Print Dialog appears the file type is set to PDF. How come and how do I
fix it ?
 
 
3. How do I create a specification file(Filename.RGW)  for Gateway Export ?
 
Many thanks. Any and all answers welcome.
 
 
 
Bill Eyring