Aident Loadout के माध्यम से Excel Tools के साथ Excel Get Worksheet Used Range का उपयोग करें। चलाने से पहले इनपुट, आउटपुट, सेटअप, मूल्य और जोखिम देखें।
Tool to retrieve a worksheet's used range (active data region) without specifying a fixed range address. Use when you need to read all data from a sheet but don't know the exact range. The valuesOnly option helps filter out formatting-only cells.
item_idआवश्यकstringThe ID of the Excel file (drive item) containing the worksheet.
drive_idआवश्यकstringThe ID of the drive (e.g., 'me' for the user's default OneDrive, or a specific drive ID for SharePoint).
session_idstringOptional workbook session ID. If provided, will be sent in the workbook-session-id header. Must be a valid session ID obtained from the createSession action.
values_onlybooleanIf true, only returns cells with values (ignores formatting-only cells). Maps to valuesOnly parameter in the API.
worksheet_idआवश्यकstringThe ID or name of the worksheet. Can be the worksheet name (e.g., 'Sheet1') or its unique ID.
dataआवश्यकData from the action execution
errorstringError if any occurred during the execution of the action
successfulआवश्यकbooleanWhether or not the action execution was successful or not
OAuth कनेक्शन। जोखिम स्तर 2/5।
मुफ़्त Action
अभी कोई प्रकाशित Skills इस Action को स्पष्ट रूप से संदर्भित नहीं करती है।