Representation for tabular data in Excel export

2016-10-04

 One of the most demanded formats of report exporting is Excel file. It's the most popular format in accounting reporting. You can edit the report in Excel format using MS Excel tools further on. FastReport.Net provides the range of very interesting features of report export in Excel.

Let's look at the window of report export settings to Excel 2007:

 

So, we have the capability to export: all pages, current page, selected page.
Now let’s consider the export options:

• Wysiwyg - the precise location of the object after export, default true.
If turned off, the border will be very "rounded". Empty rows and columns will be excluded. All this greatly changes the appearance of the report. You may disable this option if the appearance of the report does not really matter.

Let us consider an example. Option Wysiwyg:

 

And now with disabled option:

 

Changed allocation of figures on the table columns.

• Page breaks - page breaks when printing in accordance with the report pages, enabled by default. Let us consider an example. In the first case shows the excel page document when printing with the option Page breaks:

 

In the second case shows the document with the disabled option Page breaks:

 

  • Data only - just triggers the export of data band, is disabled by default

Here’s how the document looks if the Data only property is disabled:

The report looks the same as when you build it in the designer. Now we will do the export with enabled option Data only:

As you can see just the bands with the data are displayed. There is no header, no footer.

• Seamless table - allows you to remove from the export the footer bands and the following header band. This is designed to excel table looked like a uniform, with no breaks in the pages.

The figure below shows a table broken by the band footer. Admit it, it’s not very convenient for an excel document.

 

Now let's see what the table looks like, if you enable the option Seamless table:

 

I want to say a few words about the development of reports. The report has a layered structure, and the Excel file - a tabular one. When exporting to Excel, FastReport converts layers into a table. If there is an intersection of cells in the report, the conversion algorithm may fail. Check the template to the intersection cells and the gaps between them, if you want to correct export to Excel.

.NET Export FastReport Excel .NET Export FastReport Excel
February 20, 2025

Using Dot Matrix Printers for Printing Receipts

This article will explore how to integrate a dot matrix printer into the process of creating and outputting reports using FastReport .NET.
February 17, 2025

Adding New Users to FastReport Cloud

In the Business edition of the FastReport Cloud service, you can add users to a single workspace for simultaneous collaboration.
February 10, 2025

How to Try FastReport .NET WEB Before Purchase

By testing the WEB pack before purchasing, you can make an informed choice about whether FastReport is suitable for you.NET for your tasks.
Fast Reports
  • 800-985-8986 (English, US)
  • +31 97 01025-8466 (English, EU)
  • +49 30 56837-3928 (German, DE)
  • +55 19 98147-8148 (Portuguese, BR)
  • info@fast-report.com
  • 66 Canal Center Plaza, Ste 505, Alexandria, VA 22314

© 1998-2025 Fast Reports Inc.