Lots of people are talking about Google Spreadsheets. Yesterday I wrote some c# code to enable me to access my Spreadsheets account from my .net applications: a Google Spreadsheets API. So far I can authenticate, list all my existing spreadsheets, create a new spreadsheet, edit individual cells, delete a spreadsheet, rename a spreadsheet, import from a local XLS file, and export to a local XLS or CSV file. I will post some code later today.
properties:
string Email
string Password
string CurrentSheetKey
int SpreadsheetCount
string[] SpreadsheetKey
string[] SpreadsheetName
string[] SpreadsheetOwner
string[] SpreadsheetDate
string Localfile
functions:
void Auth()
void ListSheets()
string NewSheet() //returns sheetid
string OpenSheet()
void EditCell(int row, int col, string value)
void SaveSheet(string name)
void CloseSheet()
void Upload(string name)
void Download(string format)
void DeleteSheet()
void RenameSheet(string newname)
string GenerateUrl()
Update: Download it here, source included.
Update 2: The library is no longer available. Instead, I am using the RSSBus GsheetOps connector.
Example here.
Technorati tags: google spreadsheets api