GoogleDataLink: Google Docs Features



With GoogleDataLink you can write data and formulas into spreadsheet cells/ranges, read data from spreadsheet cells/ranges, get a list of contributors and their emails, see when the last edits to the spreadsheet were made, bulk-upload and retrieve data in a tabular structures, query/update/delete tabular data in the spreadsheet in a SQL query-like manner, add rows and columns, add/rename/delete worksheets, to name just a few features. Here are some examples:



An assignment:


GDL[“A12”]=56.8


or


GDL[12,1]=56.8






A retrieval:


GDL[“A12”]


56.8


or


GDL[12,1]


56.8


GDL[“A13”]=”Good Morning”


or


GDL[13,1]=”Good Morning”







GDL[“A13”]


Good Morning”


or


GDL[13,1]


Good Morning”


GDL[15,1]=Pi;

GDL[16,1]=Sqrt@5;

GDL[17,1]=64/10;





GDL[19,1]="=A15+A16"







Assigning and Retrieving Data: List-based Operations


GDLGetList[] returns a list of the column labels and the data matrix.









GDLListQuery[] returns a list of the column labels and the data matrix, filtered by the query.










GDLListUpdateByQuery[] updates the data that is filtered by the query in the worksheet (this can affect more than one row). This function should be used with extreme care as the existing data will be overwritten without asking for confirmation.









GDLListUpdateByRowIndex[] does the same as GDLListUpdateByQuery[], but uses a row index instead of a query to identify the row in which to update data. Unlike GDLListUpdateByQuery[] this can affect only one row. This function should also be used with extreme care as the existing data will be overwritten without asking for confirmation.


GDLListDeleteByRowIndex[] deletes the row with the specified row index.








GDLListAddRow[] adds the line at the bottom of the list.











GDLListAddRows[] adds the lines at the bottom of the list.










GoogleDataLink Functions: Returning Mathematica Expressions



The function GDLAddWorksheet[<name>,<rows>,<columns>] adds a new worksheet to the active spreadsheet with the specified number of rows and columns.





GDLAddWorksheet["secondsheet",200,3]








GDLSetWorksheetName["secondsheet","newnameforsecondsheet"]






GDLRemoveWorksheet["newnameforsecondsheet"]