Power Automate: Excel データを Office Scripts で高速に更新 - Qiita

function main( workbook: ExcelScript.Workbook, ): object { let topLeftAddress: string = "B6"; let retreiveData: JSON; try { let targetSheet = workbook.getActiveWorksheet(); let usedRange = targetSheet.getUsedRange(); let lastCell = usedRange.getLastCell(); let addressWithSheet = lastCell.getAddressLocal();; let regExp = new RegExp("!(?<columnName>[a-zA-Z]+)(?<rowValue>\\d+)"); let match = addressW