capturerange.js

export async function captureRange() {
  try {
    await Excel.run(async context => {
      let book = context.workbook
      let selectedRange = book.getSelectedRange()
      let usedRange = book.worksheets
        .getActiveWorksheet()
        .getUsedRange();
      selectedRange.load("address");
      usedRange.load("address");
      await context.sync();

      console.log(selectedRange.address)
      console.log(usedRange.address)

      let range = resolveRange(selectedRange.address, usedRange.address)
      console.log(range)

      range = book.worksheets
        .getActiveWorksheet()
        .getRange(range);

      range.load("values");
      await context.sync();

      processedData = processData(range.values);
      console.log(`Captured data! ${JSON.stringify(processedData)}`)
    })

  } catch (error) {
    console.error(error)
  }
}