Power Platform Community Forum Thread Details

Hey,

I m trying to add values to merged excel cells (rows and columns) via an office script:

function main(workbook: ExcelScript.Workbook,
section1: string,
section2: string,
section3: string,
section4: string,
row17_1: string,
row17_2: string,
row17_3: string,
row17_4: string) {
let sheet = workbook.getWorksheet("SHEETNAME"); // sheet name
// Update  4 main merged cells (rows 13-16)
sheet.getRange("B13").setValue(section1);
sheet.getRange("I13").setValue(section2);
sheet.getRange("P13").setValue(section3);
sheet.getRange("W13").setValue(section4);
// Update row 17-18 merged cells
sheet.getRange("B17").setValue(row17_1);
sheet.getRange("I17").setValue(row17_2);
sheet.getRange("P17").setValue(row17_3);
sheet.getRange("W17").setValue(row17_4);
}



But when i try and run the script, it just gets stuck on retry(badgateway) and then if i try and resubmit, it goes into Conflict state.



I appreciate any help on this.