Excel Import
This tool will allow for the importing of data directly from excel.
Input | Description |
|---|---|
File Select | Select the Excel File (.xlsx, .xlsm) |
Sheet | Select the desired sheet that contains the import data |
Automatically determine row count | This tries to automatically find the end of your excel data by parsing data until a completely empty line is found |
Row count | If the “Auto determine row count” option is not enabled this will define the amount of rows that will be imported starting from “Top Left Cell” |
Top left Cell | This will be used as the starting cell for data import. This needs to be properly defined to find the desired data on the selected sheet |
Show preview | The live preview of imported data |
Allows for the creation of the data map for an excel sheet |
Show Preview
After an input is changed or the “Manage Template” window is closed the preview will be updated. This preview is a quick way to verify data. Below the imported data preview will be a quick reference to the row count that was imported and will show the errors that were encountered.
Data Errors
Sometimes data is imported and cannot be properly converted to our programs inputs. This results in an error. The most common reason this happens is because the value in the cell was not the data the program expected. For example if the data was looking for a number location yet in the mapped Excel cell location it found the word “Start” the program will not be able to automatically convert “Start” to be a number. If there is a situation like this we report it as an error and use a default value (0 or an empty value if the import is looking for text). A warning will be shown if errors exist but the import data is accepted regardless to confirm default values are acceptable.