How to use Excel file as datasource in a report

2016-07-11

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 should be placed on a separate sheet. The first line should have the column heads that are used as the names of the table fields.

1. Create Excel document with one table:2. Create a Windows Forms project;

3. Add the Report control on the form;

4. Double click on the added control. Skip the data source window. The report designer appears;

5. In the Report Designer create a new connection to the data source. Menu Data-> Add Data Source.

 

The data source wizard appears:

6. Create new connection string by using the button with the same name.

7. In the window of string connection creation choose the connection type – ODBC Connection.

 Switch the radio button “Use connection string”. Select the data source using button .

 

8. Here, select the tab "Computer data source".

9. Select “Excel Files” and click Ok.

In the opened window select the file .xls or .xlsx, which contains the data.

Close the wizard connection string by the button OK.

The connection string is as follows:

Dsn=Excel Files;dbq=C:\Users\Gromozeka\Documents\Visual Studio 2010\Projects\ExcelDataSource\ExcelDataSource\bin\Debug\Employee.xlsx;defaultdir=C:\Users\Gromozeka\Documents\Visual Studio 2010\Projects\ExcelDataSource\ExcelDataSource\bin\Debug;driverid=1046;maxbuffersize=2048;pagetimeout=5

10. In the data source wizard click Next. В мастере создания источника данных нажимаем Next. Go to the window of data selection.

Select desired tables. In our case Employee. And click Finish.

11. The new data source was added to the Data window.

12. Now we can create the report template. Drop all the fields onto the Data band.

 

Run the report:

So, you can use data from Excel files to automatization your accounting statements. A data source can contain a lot of tables. It depends on the amount of sheets in the spreadsheet.  Many companies still hold their accounts in excel format. And you can use it in your reports.

 

.NET FastReport Excel XLSX .NET FastReport Excel XLSX
February 20, 2025

Using Dot Matrix Printers for Printing Receipts

This article will explore how to integrate a dot matrix printer into the process of creating and outputting reports using FastReport .NET.
February 17, 2025

Adding New Users to FastReport Cloud

In the Business edition of the FastReport Cloud service, you can add users to a single workspace for simultaneous collaboration.
February 10, 2025

How to Try FastReport .NET WEB Before Purchase

By testing the WEB pack before purchasing, you can make an informed choice about whether FastReport is suitable for you.NET for your tasks.
Fast Reports
  • 800-985-8986 (English, US)
  • +31 97 01025-8466 (English, EU)
  • +49 30 56837-3928 (German, DE)
  • +55 19 98147-8148 (Portuguese, BR)
  • info@fast-report.com
  • 66 Canal Center Plaza, Ste 505, Alexandria, VA 22314

© 1998-2025 Fast Reports Inc.