Skip to content

Instantly share code, notes, and snippets.

@ismaelc

ismaelc/capturerange.02.js

Created February 6, 2021 10:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ismaelc/8c99abe60620f3ae48a1c78d08c55ccc to your computer and use it in GitHub Desktop.
Save ismaelc/8c99abe60620f3ae48a1c78d08c55ccc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
capturerange.02.js
let range = resolveRange(selectedRange.address, usedRange.address)
range = book.worksheets
.getActiveWorksheet()
.getRange(range);
range.load("values");
await context.sync();
processedData = processData(range.values);
console.log(`Captured data! ${JSON.stringify(processedData)}`)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment