به عنوان مثال، اگر داده های صفحه گسترده عبارتند از: A1=1,B1=2,A2=3,B2=4 , سپس درخواست ranges=["A1:B2"],majorDimension=ROWS[[1,2],[3,4]] , در حالی که درخواست ranges=["A1:B2"],majorDimension=COLUMNS[[1,3],[2,4]] را برمی گرداند.
تاریخ آخرین بهروزرسانی 2024-10-25 بهوقت ساعت هماهنگ جهانی.
[[["درک آسان","easyToUnderstand","thumb-up"],["مشکلم را برطرف کرد","solvedMyProblem","thumb-up"],["غیره","otherUp","thumb-up"]],[["اطلاعاتی که نیاز دارم وجود ندارد","missingTheInformationINeed","thumb-down"],["بیشازحد پیچیده/ مراحل بسیار زیاد","tooComplicatedTooManySteps","thumb-down"],["قدیمی","outOfDate","thumb-down"],["مشکل ترجمه","translationIssue","thumb-down"],["مشکل کد / نمونهها","samplesCodeIssue","thumb-down"],["غیره","otherDown","thumb-down"]],["تاریخ آخرین بهروزرسانی 2024-10-25 بهوقت ساعت هماهنگ جهانی."],[[["This method allows retrieval of one or more ranges of values from a specified Google Sheet using the spreadsheet ID and desired ranges."],["Users can customize data retrieval by defining the major dimension (ROWS or COLUMNS), value rendering options, and date/time formatting."],["The response includes the spreadsheet ID and an array of ValueRanges containing the requested values, mirroring the order of requested ranges."],["Authorization requires specific OAuth scopes, including read or write access to Google Drive or Sheets."]]],["This outlines how to retrieve multiple ranges of values from a spreadsheet using a `GET` request. The core actions include specifying the `spreadsheetId` in the URL path and defining desired `ranges` in the query parameters. Other query parameters like `majorDimension`, `valueRenderOption`, and `dateTimeRenderOption` further customize the output. An empty request body is required. The response, structured in JSON, includes the `spreadsheetId` and the retrieved `valueRanges`. Appropriate authorization scopes are also required.\n"]]
