Excel Script ReplaceAll ignore formulas

Lorenzo 

We may use console.log here, but no sense if the script runs by Power Automate.

You variant returns

${sheet} has no UsedRange

if change on

console.log( sheet.getName() +  ' is empty')

it returns something like

Sheet3 is empty

===

Yes, without FALSE condition it returns

Line #13: ':' expected.

However, if instead of shortened "if" to use regular "if" we may skip it

function main(workbook: ExcelScript.Workbook) {

  workbook
    .getWorksheets()
    .forEach(sheet => {
      if( sheet.getUsedRange() !== undefined ) {
        sheet
          .getUsedRange()
          .getSpecialCells(ExcelScript.SpecialCellType.constants)
          .getAreas()
          .map(a => a.getUsedRange().replaceAll("'", "''", {}))
      }
    } ) 
}