Export Excel with Data Only Options

Excel (XLS) Data Only Export Options

When exporting to Excel without formatting, you have the following options:

  • The column width
  • If object formatting should be exported. If enabled, fonts and other formatting will be retained in the exported file
  • If images should be exported
  • If worksheet functions should be used for summaries
  • If the relative object positions should be maintained
  • If the column alignment should be maintained
  • If the report page headers and footers should be exported
  • If page headers should be simplified
  • If the group outlines should be displayed

Note, these settings work similar to the settings in the SAP Crystal Reports designer. If you are having problems configuring these settings, then check the settings you use when you export from the full version of the SAP Crystal Reports designer.