logo
small logo
  • Products
  • Buy
  • Support
  • About
  • Customer panel Support
    • en
    • de
    • JP
    • ZH
  • Home
  • /
  • Articles
  • /
  • Representation for tabular data in Excel export
  • Want to generate tables for a user - Excel or OpenOffice Calc?

    October 8, 2020

    Tables. For centuries, they have been used to present similar data for record-keeping, counting amounts,

    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
  • The Event of ExportParameters in WebReport.Report

    October 5, 2020

    In FastReport 2020.1 we have added the ability to change export parameters. To do this,

    read more
  • MS Word format vs. Open Document Text. Which is better?

    October 19, 2020

    Speaking of text editors, we immediately present coryphaeus as Microsoft Word, which for many years

    read more
  • Interactive forms in PDF export Fast Report .NET 2018

    January 17, 2018

    It's no secret that the PDF standard allows you to create fillable forms. That is,

    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 buy
avatar
Dmitriy Fedyashov
Technical Writer
Fast Reports Team: Dmitriy Fedyashov - Technical Writer at Fast Reports
.NET Export 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
  • FAQ
  • Tutorial Video
  • Forum
  • Support SLA
  • Articles
  • Our News
  • Press about us
  • Resellers
  • Extended licensing
  • Contact us

© 1998-2023 by Fast Reports Inc.

  • Privacy Policy

Trustpilot