Read range how to output specific values to online forms?

Help Studio
, ,
2

Hi @Lucius_L ,

  1. First to get the order number, name , email and postal code you can use read cell instead of read range. As the cell numbers in excel are constant given them and get the values
  2. To get whole quantity value use read range with range as “A13”(as per sheet provided) this will give you all the data in a datatable make sure to check the add columns check box in properties.
  3. Now to get the sum of quantity . say the datatable is in a variable dt then Enumerable.Sum(dt.AsEnumerable.Select(function(row) Cint(row(“Qty”)))) will give you the sum of quantity.

This is for one sheet. Add a for loop and in for loop change type argument to String and give your sheets names as {“Sheet1”,“Sheet2”,…so on} and the loop will run for all sheets. CurrentItem/Item from the for loop can be given as a variable to sheetname in the read cell/read range to change the sheet name and loop through all sheets

cheers

1 Like