logo
small logo
  • Products
  • Buy
  • Support
  • Articles
  • Customer panel Support
    • en
    • ru
    • pt
    • es
    • de
    • pl
    • JP
    • ZH
  • Home
  • /
  • Articles
  • /
  • Representation for tabular data in Excel export
  • How to make wedding invitations from Excel

    August 25, 2017

    Do you have a celebration on the occasion of the wedding? Do you need to

    read more
  • How to display report pages on separate sheets in Excel

    October 14, 2019

    Until recently, the export of multi-page reports in Excel format was done on one sheet.

    read more
  • How to connect to VistaDB

    November 15, 2019

    The Vista database will fall into the type of embedded databases. These databases differ from

    read more
  • How to disable printing reports and other items from the menu when viewing the report FastReport.Net

    February 29, 2020

    The main report viewing tool FastReport.Net is Viewer. This viewer has a rich toolkit for

    read more
  • How to make PDF on Raspberry PI with .NET Core

    May 26, 2020

    Raspberry PI is a miniature single-board computer with ARM processor. This microcomputer is often used

    read more

Representation for tabular data in Excel export

October 4, 2016

 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.

about product download buy
avatar
Dmitriy Fedyashov
Head of QA
.NET FastReport Excel

Add comment
logo
  • 800-985-8986 (English, US)
  • +4930568373928 (German)
  • +55 19 98147-8148 (Portuguese)
  • info@fast-report.com
  • 901 N Pitt Str #325 Alexandria VA 22314
  • Buy
  • Download
  • Documentation
  • Testimonials
  • How to uninstall
  • Ticket system
  • FAQ
  • Tutorial Video
  • Forum
  • Articles
  • Our News
  • Press about us
  • Resellers
  • Our team
  • Contact us

© 1998-2021 by Fast Reports Inc.

  • Privacy Policy