Quickstart Guide
...
Industrial Systems Connection ...
Excel

Excel (Gen1)

7min
you can set up the excel driver to read values in an excel file before you begin make sure you do the following have an excel file located on your hard drive ensure the ftp service is running see manage ftp and system services docid\ oc vxdmnbj1eeemyyt9m5 for more information install the winscp ftp client on your computer add an ftp user see add an ftp user docid\ xf3u3m 07uhd1supjb1zt for more information set up excel driver setting up the excel driver includes the following tasks step 1 set up ftp client step 2 add excel driver step 3 add a tag for a single cell in excel step 4 add a tag for range of cells in excel step 5 create flow for single cell in excel step 6 create flow for range of cells in excel step 1 set up ftp client to set up the ftp client open the winscp ftp client the ftp login dialog box appears for file protocol , select ftp configure the following parameters host name enter the manufacturing connect edge url user name enter the ftp username you created when you add an ftp user docid\ xf3u3m 07uhd1supjb1zt password paste the password you copied when you add an ftp user docid\ xf3u3m 07uhd1supjb1zt click login the winscp window appears open the devicehub folder in the right pane from the left pane, drag the excel file to the open devicehub folder the excel file uploads to the folder step 2 add excel driver to add the excel driver in manufacturing connect edge, navigate to devicehub > devices click add new device the connect device dialog box appears in the device type drop down list, select excel in the driver name drop down list, select excel (gen1) in the name field, enter a name for the device in the path field, enter the path for the excel file that you just previously uploaded click add device the excel device appears in the devices pane step 3 add a tag for a single cell in excel the excel device is disconnected until you add a tag to add a tag for single cell in manufacturing connect edge, navigate to devicehub > tags click the add new tag and select add one select the excel device configure the following parameters value type select single polling interval enter a value tag name enter a tag name name select r start cell enter a value for example, a1 end cell to configure the tag for only one cell, enter the same value as the start cell sheet enter the excel file sheet name from which the cell data is used the sheet name must be exactly the same as the sheet name in the excel file click add tag the tag is added to the tags pane click the copy icon for the tag in the raw topic column step 4 add a tag for range of cells in excel to add a tag for a range of cells in manufacturing connect edge, navigate to devicehub > tags click the add new tag and select add one select the excel device configure the following parameters value type select range polling interval enter a value tag name enter a tag name name select r start cell enter the starting cell to read data end cell enter the ending cell to read data sheet enter the excel file sheet name from which the cell data is used the sheet name must be exactly the same as the sheet name in the excel file click add tag the tag is added to the tags pane click the copy icon for the tag in the raw topic column step 5 create flow to create a flow in manufacturing connect edge, navigate to the flows manager and create a new flow see create a flow docid\ veeod3n3slcasdleedzbr to learn more drag the datahub subscribe and debug nodes to the canvas and wire them together double click the datahub subscribe node in the topic field, paste the raw topic value from either "step 3 add a tag for a single cell in excel" or "step 4 add a tag for range of cells in excel" if needed, configure the datahub subscribe connection see the "step 3 configure connector nodes" section in create a flow docid\ veeod3n3slcasdleedzbr to learn more click deploy click the debug icon see the "additional options" section in manage the flow canvas docid 2lhjfdowjw7kbft0qngzo to learn more review the debug messages and confirm they correspond to the values in the excel file