MS Excel CSV import using VB.NET
This describes a brief Visual Basic .NET example to illustrate how the .NET DataTable Adapter can be used to integrate any data source and target in FlowHeater. Of course the example is also provided as Visual Studio Solution source code.
.NET DataTable Excel CSV import
Note: This example only serves as a demonstration. In fact this Excel import/export would be much simpler using with the Excel Adapter alone. If you want to repeat this example you will need Microsoft Excel 97 (or above) installed on your computer.
.NET DataTable Adapter configurator
Once you have opened this example’s Definition, the screen should look something like the screenshot above. The READ side contains nothing of special note, it simply inputs a small CSV text file called "MS-Excel-CSV-Import.txt". Let us inspect the WRITE side’s Configurator. The Excel-Import.dll contains only one Visual Basic .NET function, which stores the data received on the WRITE side at the end of an Excel workbook called "Output.xls". If this workbook does not already exist, it is first created.
Try running this Definition and also inspect the VB .NET source code. You will find the Visual Studio Solution in the directory "Examples\EN\DataTableAdapter\VSExcelImport".
VB.NET Code for the Excel import
Microsoft®, Windows®, Excel® are registered trademarks of Microsoft Corporation