উদাহরণস্বরূপ, যদি স্প্রেডশীট ডেটা হয়: 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]] ।
[[["সহজে বোঝা যায়","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 UTC-তে শেষবার আপডেট করা হয়েছে।"],[[["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"]]
