Sunday, February 26, 2012

Export to Excel exports HTML formatting too

Is there a way to control exporting only the data in a report and not the html with it?

By "HTML" I think you mean the layout of the report and the style information associated with each item.

The Excel Renderer is a layout renderer, which means it tries to maintain the closest visual fidelity possible to the report definition and other renderers (HTML, PDF). There isn't a way to export only data using the Excel rendering extension.

You might be able to use the CSV renderer for your data; CSV is a data-only renderer and can be opened in Excel.

No comments:

Post a Comment