উদাহরণস্বরূপ, যদি শীট1-এ স্প্রেডশীট ডেটা হয়: A1=1,B1=2,A2=3,B2=4 , তাহলে range=Sheet1!A1:B2?majorDimension=ROWS রিটার্ন করে [[1,2],[3,4]] , যেখানে range=Sheet1!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-09-05 UTC-তে শেষবার আপডেট করা হয়েছে।"],[[["This Google Sheets API endpoint retrieves a range of values from a specified spreadsheet and range using an HTTP GET request."],["Users need to provide the `spreadsheetId` and `range` as path parameters in the request URL."],["Optional query parameters allow customization of the output, including `majorDimension`, `valueRenderOption`, and `dateTimeRenderOption`."],["The response body, upon successful execution, will contain a `ValueRange` object with the requested data."],["Authorization is required using one of the specified OAuth scopes related to Google Drive or Google Sheets access."]]],["This describes retrieving data from a spreadsheet using a `GET` HTTP request. The request URL includes the `spreadsheetId` and `range` as path parameters. Optional query parameters, like `majorDimension`, `valueRenderOption`, and `dateTimeRenderOption`, allow customization of the returned data. The request body must be empty. The response contains the spreadsheet data in `ValueRange` format if the request is successful. Authentication requires specific OAuth scopes for access.\n"]]
