Class
SpreadProcessingWriteAgentTools

Provides document editing agent tools for writing data, applying styles, and formatting spreadsheets. These tools modify cell content and formatting in the workbook.

Definition

Namespace:Telerik.Documents.AI.AgentTools.Spreadsheet

Assembly:Telerik.Documents.AI.AgentTools.Spreadsheet.dll

Syntax:

cs-api-definition

public class SpreadProcessingWriteAgentTools : SpreadProcessingAgentToolsBase

Inheritance: objectAgentToolBaseSpreadProcessingAgentToolsBaseSpreadProcessingWriteAgentTools

Inherited Members SpreadProcessingAgentToolsBase.RepositoryAgentToolBase.GetTools()

Constructors

SpreadProcessingWriteAgentTools(IWorkbookRepository)

Declaration

cs-api-definition

public SpreadProcessingWriteAgentTools(IWorkbookRepository repository)

Parameters

repository

IWorkbookRepository

Methods

AutoFitColumnsWidth(int, int, string, string)

Declaration

cs-api-definition

[Tool]
public CallToolResult AutoFitColumnsWidth(int fromColumnIndex, int toColumnIndex, string worksheetName = null, string documentId = null)

Parameters

fromColumnIndex

toColumnIndex

worksheetName

documentId

Returns

AutoFitRowsHeight(int, int, string, string)

Declaration

cs-api-definition

[Tool]
public CallToolResult AutoFitRowsHeight(int fromRowIndex, int toRowIndex, string worksheetName = null, string documentId = null)

Parameters

fromRowIndex

toRowIndex

worksheetName

documentId

Returns

MergeCells(int, int, int, int, string, string)

Declaration

cs-api-definition

[Tool]
public CallToolResult MergeCells(int fromRowIndex, int fromColumnIndex, int toRowIndex, int toColumnIndex, string worksheetName = null, string documentId = null)

Parameters

fromRowIndex

fromColumnIndex

toRowIndex

toColumnIndex

worksheetName

documentId

Returns

SetCellFormula(int, int, string, string, string)

Declaration

cs-api-definition

[Tool]
public CallToolResult SetCellFormula(int rowIndex, int columnIndex, string formula, string worksheetName = null, string documentId = null)

Parameters

rowIndex

columnIndex

formula

worksheetName

documentId

Returns

SetCellStyles(int, int, int, int, List<List<string>>, string, string)

Declaration

cs-api-definition

[Tool]
public CallToolResult SetCellStyles(int fromRowIndex, int fromColumnIndex, int toRowIndex, int toColumnIndex, List<List<string>> styleNames, string worksheetName = null, string documentId = null)

Parameters

fromRowIndex

fromColumnIndex

toRowIndex

toColumnIndex

styleNames

List<List<string>>

worksheetName

string

documentId

string

Returns

CallToolResult

SetCellValues(int, int, int, int, List<List<string>>, string, string)

Declaration

cs-api-definition

[Tool]
public CallToolResult SetCellValues(int fromRowIndex, int fromColumnIndex, int toRowIndex, int toColumnIndex, List<List<string>> values, string documentId = null, string worksheetName = null)

Parameters

fromRowIndex

fromColumnIndex

toRowIndex

toColumnIndex

values

List<List<string>>

documentId

string

worksheetName

string

Returns

CallToolResult

UnmergeCells(int, int, int, int, string, string)

Declaration

cs-api-definition

[Tool]
public CallToolResult UnmergeCells(int fromRowIndex, int fromColumnIndex, int toRowIndex, int toColumnIndex, string worksheetName = null, string documentId = null)