Common Lisp Package: CL-GDATA-SPREADSHEETS

README:

FUNCTION

Public

CELL-INPUT-VALUE (WORKSHEET ROW COL &OPTIONAL (DEFAULT-VALUE ))

Returns the input value of the given cell. The input value is the value that is typed into the cell, for example a formula. The evaluated value is accessible through the function CELL-VALUE.

SETFCELL-INPUT-VALUE (VALUE WORKSHEET ROW COL)

Set the input value of the cell.

CELL-VALUE (WORKSHEET ROW COL &OPTIONAL (DEFAULT-VALUE ))

Returns the value of the cell. The value is the content in the cell after evaluating any formula that the cell has.

LOAD-CELL-RANGE (WORKSHEET &KEY (SESSION *GDATA-SESSION*) (MIN-ROW 0) (MAX-ROW (1- (ARRAY-DIMENSION (SLOT-VALUE WORKSHEET 'CELLS) 0))) (MIN-COL 0) (MAX-COL (1- (ARRAY-DIMENSION (SLOT-VALUE WORKSHEET 'CELLS) 1))))

Loads the specified cell range into the worksheet.

LOAD-WORKSHEETS (DOC &KEY (SESSION *GDATA-SESSION*))

Loads the worksheets into the document instance. Returns the new worksheets.

MAP-CELL-RANGE (WORKSHEET FUNCTION &KEY (SESSION *GDATA-SESSION*) (MIN-ROW 0) (MAX-ROW (1- (ARRAY-DIMENSION (SLOT-VALUE WORKSHEET 'CELLS) 0))) (MIN-COL 0) (MAX-COL (1- (ARRAY-DIMENSION (SLOT-VALUE WORKSHEET 'CELLS) 1))))

Call FUNCTION for each cell that has a value in the given WORKSHEET. FUNCTION is called with 3 arguments: The SPREADSHEET-CELL instance, the row and the column indexes.

SAVE-UPDATED-CELLS (WORKSHEET &KEY (SESSION *GDATA-SESSION*))

Update the spreadsheet document with all changes that has been made.

WORKSHEET-COLS (WORKSHEET)

Returns the number of columns in the worksheet

WORKSHEET-ROWS (WORKSHEET)

Returns the number of rows in the worksheet

Private

Undocumented

%GET-AND-PARSE-CELL-RANGE (WORKSHEET SESSION MIN-ROW MAX-ROW MIN-COL MAX-COL)

%LOAD-CELL-RANGE-FROM-DOM (WORKSHEET DOC &KEY TEST)

%MAP-CELL-RANGE-FROM-DOM (FUNCTION DOC)

BUILD-CELL-XML-STREAM (STREAM WORKSHEET UPDATED CELLSFEED-NAME)

ENSURE-CELL-LOADED (WORKSHEET ROW COL)

FILL-ARRAY-SLICE (ARRAY ELEMENT-VALUE X1 X2 Y1 Y2)

FIND-CELL-FEED (WORKSHEET CELL ROW COL)

FIND-UPDATED-CELLS (WORKSHEET)

GENERIC-FUNCTION

Private

Undocumented

CELL-UPDATE-ERROR-CELL-DOM (CONDITION)

SLOT-ACCESSOR

Public

SPREADSHEET-WORKSHEETS (OBJECT)

A list of the worksheets in this document, or :unset if the worksheets has not yet been loaded.

WORKSHEET-CELLS (OBJECT)

The content of the worksheet

WORKSHEET-ID-URL (OBJECT)

URL to this worksheet

WORKSHEET-SPREADSHEET (OBJECT)

The spreadsheet this worksheet belongs to

WORKSHEET-TITLE (OBJECT)

The worksheet title

CLASS

Public

SPREADSHEET

Class that manages the content and pending updates to a spreadsheet document.

SPREADSHEET-CELL

Class that describes the content of a single cell

WORKSHEET

Class that manages a single worksheet in a spreadsheet document

CONDITION

Public

CELL-UPDATE-ERROR

Condition that is raised if there is a problem uploading the spreadsheet.

CONSTANT

Public

Undocumented

+SPREADSHEETS-CELLSFEED+

+SPREADSHEETS-TABLESFEED+

+SPREADSHEETS-WORKSHEETSFEED+