logo
small logo
  • Products
  • Buy
  • Support
  • About
  • Customer panel Support
    • en
    • de
    • JP
    • ZH
  • Home
  • /
  • Articles
  • /
  • Excel
  • .NET
  • FastReport
  • CSV
  • Customization
  • Business Graphics
  • Export
  • RTF
  • Install
  • Designer
  • VCL
  • Lazarus
  • Delphi
  • MacOS
  • Mono
  • PDF
  • ASP.NET
  • WebReport
  • Data Source
  • WPF
  • Core
  • ZPL
  • Pages
  • SQL
  • Angular
  • React
  • Online Designer
  • Vue
  • JSON
  • Knockout
  • MVC
  • PHP
  • Excel
  • Firebird
  • Filtering
  • FastCube
  • OLAP
  • Converter
  • C#
  • MAPI
  • Email
  • VB6
  • Visual Studio
  • WCF
  • Linux
  • Windows
  • FMX
  • Report
  • FastQueryBuilder
  • Viewer
  • FastScript
  • Map
  • HTML
  • XLSX
  • Desktop
  • Barcode
  • QR Code
  • Printing
  • Interactivity
  • PostgreSQL
  • Cloud
  • Web Storage
  • Web API
  • ZUGFeRD
  • SVG
  • Libgdiplus
  • SSRS
  • Preview
  • Toolbar
  • Plugin
  • Script
  • Matrix
  • Open Source
  • WinForms
  • HTTPS
  • Word
  • Business card
  • DBA
  • ARM
  • Visual Basic
  • Upload
  • NuGet
  • Ubuntu
  • Academic
  • Blazor
  • SPA
  • ROSA Linux
  • JetBrains Rider
  • AltLinux
  • M. Alaev
  • S. Antonenko
  • G. Bagaevski
  • A. Begunov
  • A. Fediashov
  • D. Fedyashov
  • P. Ishenin
  • O. Kojnikov
  • K. Kornienko
  • A. Mandrykin
  • M. Philippenko
  • S. Plastun
  • A. Pushkareva
  • A. Syrykh
  • A. Tantzura
  • A. Tsyganenko
  • E. Voytenko
  • V. Yarovoy
  • D. Zubov

Excel

Plugin for importing data from .XLSX to FastReport .NET
March 16, 2022
Vladislav Yarovoy
.NETFastReportExcelDesignerPluginXLSX

With the release of FastReport .NET 2022.2, we added a plug-in to connect .XLSX files as a data source. To use it, you must first build the project: С:\Program Files (x86)\FastReports\FastReport.Net\Extras\Core\FastReport.Data\FastReport.Data.Excel After building the project, you will need to ...

COVID-19 When the report is too small for your data
October 13, 2020
Michael Philippenko
FastReportExcel

Do you store COVID-19 data in Excel? Can the report show not all data? Here - https://uk.news.yahoo.com/missing-coronavirus-tests-glitch-large-excel-spreadsheet-file-095054235.html - you can read a wonderful story about how almost 16,000 cases of Covid-19 infection were left out in the UK becaus...

Want to generate tables for a user - Excel or OpenOffice Calc?
October 8, 2020
Dmitriy Fedyashov
.NETExportFastReportExcelXLSX

Tables. For centuries, they have been used to present similar data for record-keeping, counting amounts, and data analysis. For a long time, tables have been a constant tool in accounting and statistics. And it was not until the end of the 20th century that they acquired a completely different quali...

How to export a report to Excel XML from Delphi / Lazarus
May 25, 2020
Michael Philippenko
VCLExportLazarusFastReportExcelDelphiXLSX

A developer has a huge choice of options when the task is to export to Excel from Delphi or Lazarus – it was partially described in the article “How to export a report to XLS Biff8 from Delphi” and there I also briefly explained why it is a bad choice. And what is a good choice, th...

How to create a file in Excel 97 (2000, XP) – XLS from Delphi / C++Builder / Lazarus?
May 18, 2020
Michael Philippenko
VCLExportLazarusFastReportExcelReportDelphi

Oh, it’s an eternal topic – creating an Excel spreadsheet from Delphi. Excel spreadsheets are one of the world’s standards today and for programs, even simple ones, it is frequently required to output the data as tables and transfer reports to the spreadsheet. One thing to notice i...

How to display report pages on separate sheets in Excel
October 14, 2019
Dmitriy Fedyashov
.NETExportFastReportExcel

Until recently, the export of multi-page reports in Excel format was done on one sheet. That is, all pages of the report were displayed on one sheet in Excel. Of course, this is not always convenient; it would be better to be able to display each page of the report on a separate sheet in an Excel do...

How to make wedding invitations from Excel
August 25, 2017
Dmitriy Fedyashov
.NETFastReportDesktopCSVExcel

Do you have a celebration on the occasion of the wedding? Do you need to print a lot of invitations? This can be quite a tedious task. Indeed, in each invitation will have to enter the names of the guests. In this article I will show you how to solve this problem with FastReport. We need to compile...

Downloading the report as an Excel document in MVC
August 13, 2017
Dmitriy Fedyashov
.NETFastReportASP.NETMVCExcel

Previously, we already examined an example of displaying a printing dialog of a report in HTML and PDF formats. The aim of this article is to show how to save reports in the desired format, providing an example of Excel. We use the MVC web application. There is a button, which is provided to save ...

Representation for tabular data in Excel export
October 4, 2016
Dmitriy Fedyashov
.NETExportFastReportExcel

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...

How to use Excel file as datasource in a report
July 11, 2016
Dmitriy Fedyashov
.NETFastReportExcelXLSX

Not everyone knows that FastReport .Net allows you to use files of a spreadsheet editor Excel as a data source. It can be both .xls and .xlsx files. In this article we will show how to create such a data source in the report. First of all - about the requirements for Excel documents. Each table sh...

Excel formulas in the BIFF export
August 25, 2011
Dmitriy Fedyashov
VCLExportFastReportExcel

Starting from FR VCL 4.11.15 the BIFF export can export formulas. For example, to export the formula SUM(A1:B2) put a TfrxMemoView on a report and write in it Code =SUM(A1:B2) The first character of the text must be the equality sign "=", and the rest of it - a correct Excel formula....

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