function main(workbook: ExcelScript.Workbook) {
let selectedSheet = workbook.getActiveWorksheet();
// Set format for range B:B on selectedSheet
selectedSheet.getRange("B:B").setNumberFormatLocal("0,00");
// Set format for range N:T on selectedSheet
selectedSheet.getRange("N:T").setNumberFormatLocal("0,00");
// Replace "." with "," on selectedSheet
selectedSheet.replaceAll(".", ",", {completeMatch: false, matchCase: false});
}
When run in Excelapp or ExcelOnline, it works perfectly, but when i run it through Power Automate, it does not work..
I have tried some of the troubleshooting hints in this link, but simply cannot figure out how to get the script working as intended...