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