void
|
createSpreadsheet(String title)
Creates a new spreadsheet using a given title
|
Worksheet
|
createWorksheet(String spreadsheet, int spreadsheetIndex, String title, int rowCount, int colCount)
Creates a new worksheet for an specified spreadsheet
|
void
|
deleteWorksheet(String spreadsheet, String worksheet, int spreadsheetIndex, int worksheetIndex)
Deletes an specified worksheet
|
String
|
getAccessToken()
|
List<Row>
|
getAllCells(String spreadsheet, String worksheet, int spreadsheetIndex, int worksheetIndex)
Returns a list of Row in which each
entry represents one of the initialized cells on a worksheet
|
String
|
getAllCellsAsCsv(String spreadsheet, String worksheet, String columnSeparator, String lineSeparator, int spreadsheetIndex, int worksheetIndex)
Returns a CSV file representing all the initialized cells in a worksheet.
|
List<Spreadsheet>
|
getAllSpreadsheets()
Returns all the spreadsheets associated with the user's account
|
List<Worksheet>
|
getAllWorksheets(String spreadsheet, int spreadsheetIndex)
Lists all the worksheets contained in an specified spreadsheet
|
String
|
getApplicationName()
|
List<Person>
|
getAuthors(String spreadsheet, int spreadsheetIndex)
Returns a list of com.google.gdata.data.Person where each entry represent a a contributor
on a specified spreadsheet
|
List<Row>
|
getCellRange(String spreadsheet, String worksheet, int spreadsheetIndex, int worksheetIndex, Integer minRow, Integer maxRow, Integer minCol, Integer maxCol)
Returns a list of Row containing
the cells contained in a given range
|
String
|
getCellRangeAsCsv(String spreadsheet, String worksheet, int spreadsheetIndex, int worksheetIndex, String columnSeparator, String lineSeparator, Integer minRow, Integer maxRow, Integer minCol, Integer maxCol)
Returns a CSV file representing the requested cell range.
|
Object
|
getClient()
|
Row
|
getColumnHeaders(String spreadsheet, String worksheet, int spreadsheetIndex, int worksheetIndex)
This processor returns the a worksheet's first row
|
String
|
getConsumerKey()
|
String
|
getConsumerSecret()
|
String
|
getScope()
|
List<Spreadsheet>
|
getSpreadsheetsByTitle(String title)
Returns a list of Spreadsheet with all the spreadsheets
associated with the user which title matches the one specified.
|
List<Worksheet>
|
getWorksheetByTitle(String spreadsheet, String title, int spreadsheetIndex)
Returns a list of Worksheet
which title matches the one specified.
|
void
|
postAuth()
|
void
|
purgeWorksheet(String spreadsheet, String worksheet, int spreadsheetIndex, int worksheetIndex)
This processors deletes all the cell entries of a specified worksheet.
|
List<Row>
|
search(String spreadsheet, String worksheet, String query, int spreadsheetIndex, int worksheetIndex)
Performs a full-text search on a worksheet and returns a list of Row
in which each entry represent a cell containing a matching value
|
void
|
setAccessToken(String accessToken)
|
void
|
setApplicationName(String applicationName)
|
void
|
setConsumerKey(String consumerKey)
|
void
|
setConsumerSecret(String consumerSecret)
|
void
|
setCsvValues(String spreadsheet, String worksheet, String csv, int startingRow, int startingColumn, String lineSeparator, String columnSeparator, int spreadsheetIndex, int worksheetIndex, boolean purge)
Performs a batch update of a worksheet's cells taking values from a csv String.
|
void
|
setDocService(DocsService docService)
|
void
|
setRowValues(List<Row> rows, String spreadsheet, String worksheet, int spreadsheetIndex, int worksheetIndex, boolean purge)
Performs a batch update of a worksheet's cells taking values from a list of Row
taken from the message payload.
|
void
|
setScope(String scope)
|
void
|
setSpreadsheetService(SpreadsheetService spreadsheetService)
|
void
|
updateWorksheetMetadata(String spreadsheet, String worksheet, String title, Boolean draft, Boolean canEdit, String summary, int rowCount, int colCount, int spreadsheetIndex, int worksheetIndex)
This processor allows updating a worksheet's metadata, constituted by
its title, dimensions, summary, draft and editability status.
|