C# Class CoreSprint.Spreadsheet.SpreadsheetFacade

Inheritance: ISpreadsheetFacade
ファイルを表示 Open project: fortesinformatica/CoreSprint

Public Methods

Method Description
CreateHeader ( Google.GData.Spreadsheets.WorksheetEntry worksheet, IList cellHeaders ) : void
CreateWorksheet ( Google.GData.Spreadsheets.SpreadsheetEntry spreadsheet, string worksheeTitle, uint rows = 100, uint cols = 10 ) : void
CreateWorksheet ( string spreadsheetId, string worksheeTitle, uint rows = 100, uint cols = 10 ) : void
DeleteWorksheet ( Google.GData.Spreadsheets.SpreadsheetEntry spreadsheet, string worksheetName ) : void
DeleteWorksheet ( string spreadsheetId, string worksheetName ) : void
GetCellValue ( WorksheetEntry worksheet, uint row, uint col ) : string
GetCellsValues ( WorksheetEntry worksheet, uint minrow, uint maxrow, uint mincol, uint maxcol ) : IEnumerable
GetSpreadsheet ( string spreadsheetId ) : SpreadsheetEntry
GetWorksheet ( SpreadsheetEntry spreadsheet, string worksheetName ) : WorksheetEntry
GetWorksheet ( string spreadsheetId, string worksheetName ) : WorksheetEntry
InsertInWorksheet ( WorksheetEntry worksheet, ListEntry row ) : void
SaveToCell ( WorksheetEntry worksheet, uint row, uint col, string value ) : void
SpreadsheetFacade ( ISpreadsheetConnection connection ) : System

Private Methods

Method Description
GetCellFeed ( CellQuery cellQuery ) : CellFeed
GetCellFeed ( WorksheetEntry worksheet ) : CellFeed
GetListFeed ( WorksheetEntry worksheet ) : ListFeed

Method Details

CreateHeader() public method

public CreateHeader ( Google.GData.Spreadsheets.WorksheetEntry worksheet, IList cellHeaders ) : void
worksheet Google.GData.Spreadsheets.WorksheetEntry
cellHeaders IList
return void

CreateWorksheet() public method

public CreateWorksheet ( Google.GData.Spreadsheets.SpreadsheetEntry spreadsheet, string worksheeTitle, uint rows = 100, uint cols = 10 ) : void
spreadsheet Google.GData.Spreadsheets.SpreadsheetEntry
worksheeTitle string
rows uint
cols uint
return void

CreateWorksheet() public method

public CreateWorksheet ( string spreadsheetId, string worksheeTitle, uint rows = 100, uint cols = 10 ) : void
spreadsheetId string
worksheeTitle string
rows uint
cols uint
return void

DeleteWorksheet() public method

public DeleteWorksheet ( Google.GData.Spreadsheets.SpreadsheetEntry spreadsheet, string worksheetName ) : void
spreadsheet Google.GData.Spreadsheets.SpreadsheetEntry
worksheetName string
return void

DeleteWorksheet() public method

public DeleteWorksheet ( string spreadsheetId, string worksheetName ) : void
spreadsheetId string
worksheetName string
return void

GetCellValue() public method

public GetCellValue ( WorksheetEntry worksheet, uint row, uint col ) : string
worksheet WorksheetEntry
row uint
col uint
return string

GetCellsValues() public method

public GetCellsValues ( WorksheetEntry worksheet, uint minrow, uint maxrow, uint mincol, uint maxcol ) : IEnumerable
worksheet WorksheetEntry
minrow uint
maxrow uint
mincol uint
maxcol uint
return IEnumerable

GetSpreadsheet() public method

public GetSpreadsheet ( string spreadsheetId ) : SpreadsheetEntry
spreadsheetId string
return SpreadsheetEntry

GetWorksheet() public method

public GetWorksheet ( SpreadsheetEntry spreadsheet, string worksheetName ) : WorksheetEntry
spreadsheet SpreadsheetEntry
worksheetName string
return WorksheetEntry

GetWorksheet() public method

public GetWorksheet ( string spreadsheetId, string worksheetName ) : WorksheetEntry
spreadsheetId string
worksheetName string
return WorksheetEntry

InsertInWorksheet() public method

public InsertInWorksheet ( WorksheetEntry worksheet, ListEntry row ) : void
worksheet WorksheetEntry
row ListEntry
return void

SaveToCell() public method

public SaveToCell ( WorksheetEntry worksheet, uint row, uint col, string value ) : void
worksheet WorksheetEntry
row uint
col uint
value string
return void

SpreadsheetFacade() public method

public SpreadsheetFacade ( ISpreadsheetConnection connection ) : System
connection ISpreadsheetConnection
return System