logo
small logo
  • Products
  • Buy
  • Support
  • Articles
  • Forgot password?
    • en
    • ru
    • pt
    • es
    • JP
    • ZH
  • Home
  • /
  • Articles
  • /
  • Representation for tabular data in Excel export
  • 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 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 make a report like Drill-Down

    September 4, 2019

    Reports with grouping are necessary for data analysis. But when there are a lot of

    read more
  • How to connect to MongoDB from the FastReport.Net report

    November 16, 2019

    First of all, you need to assemble a plug-in connector library to the database for

    read more
  • How to sort the data in the report FastReport.Net

    April 22, 2020

    Sorting data is one of the most important data processing tools. We can say, it

    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