Microsoft Excel implements a pseudo-database engine internally. By default, each worksheet within Excel is treated as a table.
The table names are suffixed with a $ sign. However, most users use Excel as a
free-form editor. Sometimes, you may need to access data within a specific
range of cells. To address this, Microsoft enhanced Excel’s metadata mechanism.
Within Excel, you can select a range of “cells”.These named ranges can be created from Insert->Name->Define dialog box.
When xFusion Studio reads this Excel file each named range is displayed as a separate table.
In the following sample Excel worksheet, we have defined two named ranges Table1 =Sheet1!$A$1:$B$15 and
Table2 =Sheet1!$G$12:$H$24
When we read the above Excel file in xFusion, it displays separate tables for each defined named range.
As you can see, you can easily convert a range of cells within Excel as a custom table and use it within xFusion.
You can define as many tables as desired within any worksheet.
Click here to download the sample fusion pack.
|