Here is an example process for iterating through a particular column on a chosen worksheet using Office scripts:
getWorksheet
function.let sheet = context.workbook.worksheets.getItem("Sheet1");
getRange
function.let range = sheet.getRange("A:A");
getValues
function.let values = range.getValues();
for(let i=0; i<values.length; i++){
let item = values[i];
// do something with the item
}
for(let i=0; i<values.length; i++){
let item = values[i];
sheet.getRange("B" + (i+1)).setValue(item * 2);
}
for(let i=0; i<values.length; i++){
let item = values[i];
if(item > 10){
sheet.getRange("B" + (i+1)).setValue("High");
} else {
sheet.getRange("B" + (i+1)).setValue("Low");
}
}
Asked: 2023-06-26 16:11:51 +0000
Seen: 8 times
Last updated: Jun 26 '23