graph

Documentation

Index

• func AddWorksheetColumn(ctx context.Context, workbookID, worksheetID, columnID string, ...) error
• func AddWorksheetRow(ctx context.Context, c *msgraphsdkgo.GraphServiceClient, ...) error
• func CreateWorksheet(ctx context.Context, c *msgraphsdkgo.GraphServiceClient, ...) (string, error)
• func GetWorksheetColumnHeaders(ctx context.Context, c *msgraphsdkgo.GraphServiceClient, ...) ([][]any, models.WorkbookRangeable, error)
• func GetWorksheetData(ctx context.Context, c *msgraphsdkgo.GraphServiceClient, ...) ([][]any, models.WorkbookRangeable, error)
• type HTTPErrorBody
• type Table
  • func GetWorksheetTables(ctx context.Context, c *msgraphsdkgo.GraphServiceClient, ...) ([]Table, error)
• type UpdateBody
  • func (u *UpdateBody) AppendColumnCellToFormulas(newColumnCell []any)
  • func (u *UpdateBody) AppendColumnCellToValues(newColumnCell []any)
  • func (u *UpdateBody) AppendRowToFormulas(newRow []any)
  • func (u *UpdateBody) AppendRowToValues(newRow []any)
• type WorkbookInfo
  • func ListWorkbooks(ctx context.Context, c *msgraphsdkgo.GraphServiceClient) ([]WorkbookInfo, error)
• type WorksheetInfo
  • func ListWorksheetsInWorkbook(ctx context.Context, c *msgraphsdkgo.GraphServiceClient, workbookID string) ([]WorksheetInfo, error)

Functions

func AddWorksheetColumn

func AddWorksheetColumn(ctx context.Context, workbookID, worksheetID, columnID string, contents []string) error

func AddWorksheetRow

func AddWorksheetRow(ctx context.Context, c *msgraphsdkgo.GraphServiceClient, workbookID, worksheetID string, contents []string) error

func CreateWorksheet

func CreateWorksheet(ctx context.Context, c *msgraphsdkgo.GraphServiceClient, workbookID, name string) (string, error)

func GetWorksheetColumnHeaders

func GetWorksheetColumnHeaders(ctx context.Context, c *msgraphsdkgo.GraphServiceClient, workbookID, worksheetID string) ([][]any, models.WorkbookRangeable, error)

func GetWorksheetData

func GetWorksheetData(ctx context.Context, c *msgraphsdkgo.GraphServiceClient, workbookID, worksheetID string) ([][]any, models.WorkbookRangeable, error)

Types

type HTTPErrorBody

type HTTPErrorBody struct {
	Error struct {
		Code       string `json:"code,omitempty"`
		Message    string `json:"message,omitempty"`
		InnerError struct {
			Code            string `json:"code,omitempty"`
			Message         string `json:"message,omitempty"`
			Date            string `json:"date,omitempty"`
			RequestID       string `json:"request-id,omitempty"`
			ClientRequestID string `json:"client-request-id,omitempty"`
		} `json:"innerError,omitempty"`
	} `json:"error,omitempty"`
}

type Table

type Table struct {
	ID, Name string
}

func GetWorksheetTables

func GetWorksheetTables(ctx context.Context, c *msgraphsdkgo.GraphServiceClient, workbookID, worksheetID string) ([]Table, error)

type UpdateBody

type UpdateBody struct {
	Values   [][]any `json:"values,omitempty"`
	Formulas [][]any `json:"formulas,omitempty"`
}

func (*UpdateBody) AppendColumnCellToFormulas

func (u *UpdateBody) AppendColumnCellToFormulas(newColumnCell []any)

func (*UpdateBody) AppendColumnCellToValues

func (u *UpdateBody) AppendColumnCellToValues(newColumnCell []any)

func (*UpdateBody) AppendRowToFormulas

func (u *UpdateBody) AppendRowToFormulas(newRow []any)

func (*UpdateBody) AppendRowToValues

func (u *UpdateBody) AppendRowToValues(newRow []any)

type WorkbookInfo

type WorkbookInfo struct {
	ID, Name string
}

func ListWorkbooks

func ListWorkbooks(ctx context.Context, c *msgraphsdkgo.GraphServiceClient) ([]WorkbookInfo, error)

type WorksheetInfo

type WorksheetInfo struct {
	ID, Name, WorkbookID string
}

func ListWorksheetsInWorkbook

func ListWorksheetsInWorkbook(ctx context.Context, c *msgraphsdkgo.GraphServiceClient, workbookID string) ([]WorksheetInfo, error)