excel

type Application interface {
	sugar.Chain
	// Workbooks returns the collection of all open workbooks.
	Workbooks() Workbooks
	// ActiveWorkbook returns the workbook that is currently active.
	ActiveWorkbook() Workbook
	// Quit quits the Excel application.
	Quit() error
}

type Range interface {
	sugar.Chain
	// SetValue sets the value for the entire range.
	SetValue(value interface{}) Range
	// Cells returns a Range object representing a single cell relative to this range.
	Cells(row, col interface{}) Range
}

type Workbook interface {
	sugar.Chain
	// Worksheets returns the collection of all worksheets in the workbook.
	Worksheets() Worksheets
	// ActiveSheet returns the worksheet that is currently active.
	ActiveSheet() Worksheet
	// Save saves the workbook.
	Save() error
	// Close closes the workbook.
	Close() error
}

type Workbooks interface {
	sugar.Chain
	// Add creates a new empty workbook.
	Add() Workbook
	// Item returns a specific workbook by index or name.
	Item(index interface{}) Workbook
}

type Worksheet interface {
	sugar.Chain
	// Range returns a Range object that represents a cell or a range of cells.
	// Arguments can be "A1" or ("A1", "B2").
	Range(cell1 interface{}, cell2 ...interface{}) Range
	// Cells returns a Range object representing a single cell at (row, col).
	Cells(row, col interface{}) Range
}

type Worksheets interface {
	sugar.Chain
	// Item returns a specific worksheet by index or name.
	Item(index interface{}) Worksheet
}