In Spreadsheets Add-on (Google Apps Script),
vars=SpreadsheetApp.getActiveSheet();
range=ss.getActiveRange();
var values = range.getValues();
Then, if the selection range is selected in Ctrl or Command over multiple areas, such as images,
value: [[a11, b11, c11], [a12, b12, c12], [a13, b13, c13], [a14, b14, c14]]
returns (only the last selected part returns values)
I would like to get the range that I originally selected as range, but is there any way?
google-apps-script google-spreadsheet
getActiveRange()
allows you to retrieve only a few cells if you select multiple ranges in Ctrl.
There seems to be some requests, but they are not available at this time.
Add support to allow use and manual disjoint Ranges
https://issuetracker.google.com/issues/36761866
574 Who developed the "avformat-59.dll" that comes with FFmpeg?
578 Understanding How to Configure Google API Key
572 rails db:create error: Could not find mysql2-0.5.4 in any of the sources
581 PHP ssh2_scp_send fails to send files as intended
618 Uncaught (inpromise) Error on Electron: An object could not be cloned
© 2024 OneMinuteCode. All rights reserved.