ClassSpreadProcessingReadAgentTools
Provides read-only agent tools for querying and analyzing spreadsheet data without modification. These tools are safe for analysis-only scenarios.
Definition
Namespace:Telerik.Documents.AI.AgentTools.Spreadsheet
Assembly:Telerik.Documents.AI.AgentTools.Spreadsheet.dll
Syntax:
public class SpreadProcessingReadAgentTools : SpreadProcessingAgentToolsBaseInheritance: objectAgentToolBaseSpreadProcessingAgentToolsBaseSpreadProcessingReadAgentTools
Inherited Members
Constructors
SpreadProcessingReadAgentTools(IWorkbookRepository)
Declaration
public SpreadProcessingReadAgentTools(IWorkbookRepository repository)Parameters
repository
Methods
FilterAndExtract(int, List<string>, List<int>, string, string, int)
Declaration
[Tool]
public CallToolResult FilterAndExtract(int filterColumnIndex, List<string> filterValues, List<int> columnsToReturn, string worksheetName = null, string documentId = null, int maxSampleRows = 5)Parameters
filterColumnIndex
filterValues
columnsToReturn
worksheetName
documentId
maxSampleRows
Returns
FindAll(string, Range[], string, string, int)
Declaration
[Tool]
public CallToolResult FindAll(string findWhat, Range[] searchRanges, string worksheetName = null, string documentId = null, int maxSampleLocations = 10)Parameters
findWhat
searchRanges
Range[]
worksheetName
documentId
maxSampleLocations
Returns
GetCellStyles(int, int, int, int, string, string)
Declaration
[Tool]
public CallToolResult GetCellStyles(int fromRowIndex, int fromColumnIndex, int toRowIndex, int toColumnIndex, string worksheetName = null, string documentId = null)Parameters
fromRowIndex
fromColumnIndex
toRowIndex
toColumnIndex
worksheetName
documentId
Returns
GetCellValues(int, int, int, int, string, string)
Declaration
[Tool]
public CallToolResult GetCellValues(int fromRowIndex, int fromColumnIndex, int toRowIndex, int toColumnIndex, string worksheetName = null, string documentId = null)Parameters
fromRowIndex
fromColumnIndex
toRowIndex
toColumnIndex
worksheetName
documentId
Returns
GetStyleProperties(List<string>, string)
Declaration
[Tool]
public CallToolResult GetStyleProperties(List<string> styleNames, string documentId = null)Parameters
styleNames
documentId
Returns
GetUniqueValues(Range, string, string)
Declaration
[Tool]
public CallToolResult GetUniqueValues(Range range, string worksheetName = null, string documentId = null)Parameters
range
worksheetName
documentId
Returns
GetUsedCellRange(string, string)
Declaration
[Tool]
public CallToolResult GetUsedCellRange(string worksheetName = null, string documentId = null)Parameters
worksheetName
documentId
Returns
GetWorkbookStyles(string)
Declaration
[Tool]
public CallToolResult GetWorkbookStyles(string documentId = null)Parameters
documentId
Returns
GetWorksheetNames(string)
Declaration
[Tool]
public CallToolResult GetWorksheetNames(string documentId = null)Parameters
documentId
Returns
ListAvailableStyles(string)
Declaration
[Tool]
public CallToolResult ListAvailableStyles(string documentId = null)Parameters
documentId
Returns