Mapping Files

You can use file mapping to map contents from a file into Excel or to map contents from Excel into a file. You can control various options that define the content that will be mapped.

When inserting contents from a file into Excel, Isight adds each line in the file as a row and splits the line at spaces, commas, and tabs to define the items to put into different columns in that row. Values that have spaces must have quotation marks around them to be interpreted as a single value to insert into a cell.

Double-click the Excel component icon .
The Excel Component Editor appears.
From the Excel Component Editor, click the arrow next to the button, and select Add mapping from/to a file.

The Map To or From a File dialog box appears.

Select one of the following

Map from a file to Excel

Click Next.
The Select File dialog box appears.
In the File text box, enter the name of the file or click Browse to navigate to the file.

Select one of the following:


Insert entire file contents starting in cell	Select this option to have the entire contents of the file inserted into the workbook starting at the currently selected cell.
Match parameter names from file with selected range	Select this option to select a row of parameter names in the Excel worksheet to be matched against parameter names found on the first line of the file. The entire column of data for those matching parameters will then be copied from the file to the corresponding column in the Excel worksheet.

Map from Excel to a file
1. Click Next.
  The Select File dialog box appears.
2. In the File text box, enter the name of the file or click Browse to navigate to the file.
3. Click Export entire selected sheet or Export only selected range.
4. Specify the Separator to use when writing the value.

Click Finish.

The new mappings are listed at the bottom of the Excel editor.
Set any desired advanced options. See Using Advanced Options.
Click OK to save your changes and to close the Excel Component Editor.