Excel

Read Range

3min
overview https //docs procesio com/write to file#yja0t use this action to read values and formulas from a given excel range how to configure the read range action? https //kb procesio com/regex replace#qd how to https //docs procesio com/merge lists#q how to https //docs procesio com/write to file# s0vi step 1 create a process and give it a name step 2 drag the read range action to the canvas and link it to the other actions step 3 create the variables needed for the configuration of the action, and then add them to the configuration panel excel workbook you need to input the file with the workbook where range will be read from sheet name you need to input a string with the sheet name from the workbook where the range will be read from range you need to input a string with the range of cells to read from values json output which contains the read value(s) formulas json output which contains the read formulas if any formula is present in a cell, will be returned in the output json as a string if there is no formula present in a cell (or if there are values), will be returned as a null inside the json output step 4 save , validate and run the process step 5 you will be prompted to add the file for our input variable click run step 6 to verify the process click check instance step 7 in the output section, you can see the json output(s)