Excel Files As Data Sources Using RSSBus ADO.NET Providers
Using the ADO.NET Data Provides from our partner company RSSBus, you can easily connect your applications to Google, QuickBooks, Salesforce.com and SAP. We fully integrated RSSBus support into TX Text Control Words, the Text Control Reporting template designer. All installed RSSBus data providers are automatically listed in the Select Data Source wizard. In this quick tutorial, you will learn how to use an Excel spreadsheet as a data source for a TX Text Control report using the RSSBus…
Using the ADO.NET Data Provides from our partner company RSSBus, you can easily connect your applications to Google, QuickBooks, Salesforce.com and SAP.
We fully integrated RSSBus support into TX Text Control Words, the Text Control Reporting template designer. All installed RSSBus data providers are automatically listed in the Select Data Source wizard.
In this quick tutorial, you will learn how to use an Excel spreadsheet as a data source for a TX Text Control report using the RSSBus ADO.NET Provider for Excel. In the same way as for Excel, all supported RSSBus ADO.NET or ODBC data providers can be used in TX Text Control.
-
Download and install the trial version of RSSBus ADO.NET Provider for Excel.
-
Start TX Text Control Words and click the Select Data Source button from the Mailings ribbon tab page.
-
In the opened dialog box, select RSSBus ADO.NET Provider for Excel and confirm with OK.
-
In the next dialog, find the Excel File property and insert your Excel file path as the value. We prepared a sample Excel file for your first tests. Confirm with OK.
-
Select Sheet1 from the Insert Merge Block drop-down button.
-
In the opened dialog box, select some table columns, check the checkbox Add table header row and confirm with OK.
-
The following merge block is inserted automatically:
-
Choose Preview Merge Fields from the Preview ribbon group and confirm the opened dialog with OK.
Using TX Text Control and RSSBus data providers, you can easily create powerful reports from many data sources such as SharePoint, QuickBooks, Facebook and Microsoft Dynamics.
Reporting
The Text Control Reporting Framework combines powerful reporting features with an easy-to-use, MS Word compatible word processor. Users can create documents and templates using ordinary Microsoft Word skills. The Reporting Framework is included in all .NET based TX Text Control products including ASP.NET, Windows Forms and WPF.
Related Posts
Creating Your First ASP.NET Reporting Application
This tutorial shows how to use the MailMerge component in an ASP.NET Web application to merge a template with data to create an Adobe PDF document.
New Online Sample: Build your First Report
We published a new online demo that shows how to create a report including preparing data, creating a template to merging them together.
ReportingDocumentationReportingCloud
Create your First Document with ReportingCloud
As part of our new ReportingCloud documentation, we published a guided tutorial that shows how to create a document without programming.
MailMerge: Starting Each Merge Block on a New Page
A merge block is repeated based on the number of matching data rows in the hierarchical data object. The complete merge block is cloned and inserted under the original location in the template.…
Using MailMerge with JSON Data
In the last article, we explained how to create an ASP.NET Web API to merge templates with JSON data in the payload body of an HTTP request. The focus of this article was on the Web API and…