Excel (Gen1.3)

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 8wxarubsl0wubj tsl3ha for more information install the winscp ftp client on your computer add an ftp user see add an ftp user docid\ mcl0lrotq1vooa5e2crmi 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 litmus edge url user name enter the ftp username you created when you add an ftp user docid\ mcl0lrotq1vooa5e2crmi password paste the password you copied when you add an ftp user docid\ mcl0lrotq1vooa5e2crmi 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 litmus edge, navigate to devicehub > devices click the connect a device box 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 3) 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 litmus edge, navigate to devicehub > tags click the excel device click the add icon and select add a tag configure the following parameters name select r value type select single polling interval enter a value tag name enter a tag name 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 litmus edge, navigate to devicehub > tags select the excel device click the add icon and select add a tag configure the following parameters name select r value type select range polling interval enter a value tag name enter a tag name 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 litmus edge, navigate to the flows manager and create a new flow see create a flow docid\ wh4zihwf0pwmryrbazbco 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\ wh4zihwf0pwmryrbazbco to learn more click deploy click the debug icon see the "additional options" section in manage the flow canvas docid\ fd9bu5dd1nbv3xvy 0xxn to learn more review the debug messages and confirm they correspond to the values in the excel file