BookmarkSubscribeSubscribe to RSS Feed

Specification of where to find Units in Excel Import Wizard (Units are in row: ... )

For Excel tables like shown in the attached jpg I would like to be able to specify in the Excel Import Wizard "Units are in row 2" (similar to how it works with "Column headers start on row 1").

Those imported Units would then be stored in the respective Column Properties.

 

The same would be possible for Limits, e.g. "Lower Limits are in row 3", "Targets are in row 4", "Upper Limits are in row 5".

Being able to access Limits stored in a separate worksheet of the same Excel file would be even more comfortable.

 

For Units another scenario would be to specify that Units are stored in brackets [ ] or parentheses ( ) at the end of the column header.

 

Excelsheet.jpg

 

Tracking Number:

Defect ID: