Export to Excel using TfrxBIFFExport looks messy

ccy

When using TfrxBIFFExport to export a fast report report. It will create many columns with variable width. The intention is to match the excel as close as it's actual look in FastReport.

By turn off WYSIWYG option, the columns has reduced and it looks much better in Excel and less messy.

However, without WYSIWYG option the excel worksheet still look messy compare to other report export filter. I figure out the TfrxBIFFExport trying to adjust the column width and that makes the output looks messy. Is there any option to prevent the worksheet's column width adjusted for the export filter?

gpi

No such option. Read User's manual

wrote:

15.7 Report Design considerations
The quality of the export output in any format is highly dependent on the quality of the original report design. FastReport can manipulate objects in a large number of ways during report creation. This has the advantage of fast development of reports and subsequent printing. Printed documents look just as previewed. This is the primary objective of the FastReport report engine. The downside of this development freedom is the complexity of exporting FastReport documents to different data formats, each of which has its own, sometimes complex, requirements and limitations. In this chapter, special design requirements for reports intended for export will be discussed.
Many formats use tabular data presentation, such as HTML, XLS, XML, RTF and CSV. In contrast to the freedom allowed in FastReport page design, when exporting to these formats the output cells created for these tables cannot intersect or be arranged in layers. Export filters, as a rule, take into account these requirements when objects are exported by FastReport, by the use of special algorithms dealing with intersections and the optimal placing of cells. At object intersections new columns and lines are created in the output table. This is necessary to enable FastReport to position objects exactly and to obtain the best correspondence with the original preview page. A large number of intersecting objects in a report design leads to a large number of additional columns and rows in the output table. This in turn can lead to the need for editing of the exported file in its own editor before suitable for further use.