tools

package
v0.12.0 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Jul 19, 2025 License: MIT Imports: 18 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

View Source
var ExcelScreenCaptureArgumentsSchema = z.Struct(z.Shape{
	"fileAbsolutePath": z.String().Test(AbsolutePathTest()).Required(),
	"sheetName":        z.String().Required(),
	"range":            z.String(),
})

Functions

func AbsolutePathTest added in v0.7.0

func AbsolutePathTest() z.Test[*string]

func AddExcelCopySheetTool added in v0.8.0

func AddExcelCopySheetTool(server *server.MCPServer)

func AddExcelCreateTableTool added in v0.9.0

func AddExcelCreateTableTool(server *server.MCPServer)

func AddExcelDescribeSheetsTool added in v0.8.0

func AddExcelDescribeSheetsTool(server *server.MCPServer)

func AddExcelFormatRangeTool added in v0.12.0

func AddExcelFormatRangeTool(server *server.MCPServer)

func AddExcelReadSheetTool added in v0.8.0

func AddExcelReadSheetTool(server *server.MCPServer)

func AddExcelScreenCaptureTool added in v0.8.0

func AddExcelScreenCaptureTool(server *server.MCPServer)

func AddExcelWriteToSheetTool added in v0.8.0

func AddExcelWriteToSheetTool(server *server.MCPServer)

func CreateHTMLTableOfFormula added in v0.4.0

func CreateHTMLTableOfFormula(worksheet excel.Worksheet, startCol int, startRow int, endCol int, endRow int) (*string, error)

func CreateHTMLTableOfFormulaWithStyle added in v0.11.0

func CreateHTMLTableOfFormulaWithStyle(worksheet excel.Worksheet, startCol int, startRow int, endCol int, endRow int) (*string, error)

func CreateHTMLTableOfValues added in v0.4.0

func CreateHTMLTableOfValues(worksheet excel.Worksheet, startCol int, startRow int, endCol int, endRow int) (*string, error)

func CreateHTMLTableOfValuesWithStyle added in v0.11.0

func CreateHTMLTableOfValuesWithStyle(worksheet excel.Worksheet, startCol int, startRow int, endCol int, endRow int) (*string, error)

Types

type EnvConfig added in v0.3.0

type EnvConfig struct {
	EXCEL_MCP_PAGING_CELLS_LIMIT int
}

func LoadConfig added in v0.3.0

func LoadConfig() (EnvConfig, z.ZogIssueMap)

type ExcelCopySheetArguments added in v0.8.0

type ExcelCopySheetArguments struct {
	FileAbsolutePath string `zog:"fileAbsolutePath"`
	SrcSheetName     string `zog:"srcSheetName"`
	DstSheetName     string `zog:"dstSheetName"`
}

type ExcelCreateTableArguments added in v0.9.0

type ExcelCreateTableArguments struct {
	FileAbsolutePath string `zog:"fileAbsolutePath"`
	SheetName        string `zog:"sheetName"`
	Range            string `zog:"range"`
	TableName        string `zog:"tableName"`
}

type ExcelDescribeSheetsArguments added in v0.8.0

type ExcelDescribeSheetsArguments struct {
	FileAbsolutePath string `zog:"fileAbsolutePath"`
}

type ExcelFormatRangeArguments added in v0.12.0

type ExcelFormatRangeArguments struct {
	FileAbsolutePath string               `zog:"fileAbsolutePath"`
	SheetName        string               `zog:"sheetName"`
	Range            string               `zog:"range"`
	Styles           [][]*excel.CellStyle `zog:"styles"`
}

type ExcelReadSheetArguments added in v0.8.0

type ExcelReadSheetArguments struct {
	FileAbsolutePath string `zog:"fileAbsolutePath"`
	SheetName        string `zog:"sheetName"`
	Range            string `zog:"range"`
	ShowFormula      bool   `zog:"showFormula"`
	ShowStyle        bool   `zog:"showStyle"`
}

type ExcelScreenCaptureArguments added in v0.8.0

type ExcelScreenCaptureArguments struct {
	FileAbsolutePath string `zog:"fileAbsolutePath"`
	SheetName        string `zog:"sheetName"`
	Range            string `zog:"range"`
}

type ExcelWriteToSheetArguments added in v0.8.0

type ExcelWriteToSheetArguments struct {
	FileAbsolutePath string     `zog:"fileAbsolutePath"`
	SheetName        string     `zog:"sheetName"`
	NewSheet         bool       `zog:"newSheet"`
	Range            string     `zog:"range"`
	Values           [][]string `zog:"values"`
}

type PivotTable added in v0.9.0

type PivotTable struct {
	Name  string `json:"name"`
	Range string `json:"range"`
}

type Response added in v0.9.1

type Response struct {
	Backend string      `json:"backend"`
	Sheets  []Worksheet `json:"sheets"`
}

type StyleRegistry added in v0.11.0

type StyleRegistry struct {
	// contains filtered or unexported fields
}

func NewStyleRegistry added in v0.11.0

func NewStyleRegistry() *StyleRegistry

func (*StyleRegistry) GenerateStyleDefinitions added in v0.11.0

func (sr *StyleRegistry) GenerateStyleDefinitions() string

func (*StyleRegistry) RegisterBorderStyle added in v0.11.0

func (sr *StyleRegistry) RegisterBorderStyle(borders []excel.Border) string

Individual style element registration methods

func (*StyleRegistry) RegisterDecimalStyle added in v0.11.0

func (sr *StyleRegistry) RegisterDecimalStyle(decimal int) string

func (*StyleRegistry) RegisterFillStyle added in v0.11.0

func (sr *StyleRegistry) RegisterFillStyle(fill *excel.FillStyle) string

func (*StyleRegistry) RegisterFontStyle added in v0.11.0

func (sr *StyleRegistry) RegisterFontStyle(font *excel.FontStyle) string

func (*StyleRegistry) RegisterNumFmtStyle added in v0.11.0

func (sr *StyleRegistry) RegisterNumFmtStyle(numFmt string) string

func (*StyleRegistry) RegisterStyle added in v0.11.0

func (sr *StyleRegistry) RegisterStyle(cellStyle *excel.CellStyle) []string

type Table added in v0.9.0

type Table struct {
	Name  string `json:"name"`
	Range string `json:"range"`
}

type Worksheet added in v0.9.0

type Worksheet struct {
	Name         string       `json:"name"`
	UsedRange    string       `json:"usedRange"`
	Tables       []Table      `json:"tables"`
	PivotTables  []PivotTable `json:"pivotTables"`
	PagingRanges []string     `json:"pagingRanges"`
}

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL