my office script to replace blanks with 0 is not working

[Reecenorman1996]

function main(workbook: ExcelScript.Workbook) {
let table1 = workbook.getTable("Table1");
// Replace all "" with "0" on table table1
table1.getRange().replaceAll("", "0", {completeMatch: true, matchCase: true});
let selectedSheet = workbook.getActiveWorksheet();
// Set format for range G:G on selectedSheet
selectedSheet.getRange("G:G").setNumberFormatLocal("[$-x-systime]h:mm:ss AM/PM");
}

the above works if i am not trying to find blanks , i need to use this code in power automate as run a script so cant use the above as a vba

 

[RoryA]

Are the cells actually empty, or do they have formulas returning "" in them?

 

[Reecenorman1996]

Are the cells actually empty, or do they have formulas returning "" in them?

The cells are empty when i use the select and replace it works, so i recorded the action as a script , which is the above but doesn't work