Google spreadsheet is one subset of Google Doc. We can create, store, manage, share and publish spreadsheets all freely with Google Spreadsheet. The good thing is we can access our spreadsheet data from anywhere in the world. Google Spreadsheet services were launched in 2006 as Google Labs Spreadsheet.
To create, manage online spreadsheet with Google Doc all you need is a Google account. You can create, read, and modify your spreadsheet using browsers. Google also has provided a set of APIs called Spreadsheet API which helps the developers to integrate their web sites, applications with Google Spreadsheets. You can read and update your spreadsheet without being on Google. You can create a desktop applications, web based application or mobile application and access your spreadsheets.
To start using SpreadSheet API in your application; you need to complete following things:
#1. You need to have a Google account with Google to start with.
#2. You need to download and install Google Data API library. Google Data API library is available in many flavours (Java, .NET, PHP, JavaScript etc.). So if you want to explore Google Data API library with .NET you need to download Google Data API library, you can go to http://code.google.com/p/google-gdata/downloads/list and download Google Data API setup.
#3. You need to be connected with internet to explore and use Google Data API library.
Once you have completed the three pre-requisite you are all set to explore SpreadSheet API. We will explore the SpreadSheet API with .NET in this post and upcoming posts.
To explore Spreadsheet API, we need to have some online spreadsheet available. We can read, manipulate these spreadsheets using our .NET interface. So I navigated to the https://docs.google.com/ and uploaded two spreadsheet (EmpDetails and ProductDetails).
OK, so we have the online spreadsheet files available to explore; the next thing we can do is to fire up the Ms-Visual Studio and create a new project. The choice is yours what application you want to create – windows, web, wpf; it does not matter as the concepts are same across the platform.
The very first thing we need to do with Ms-Visual Studio project is to add references of Google Data API Dll in our project. I am using MS-Visual Studio 2010 on Windows 7 and after installation my Google Data API DLL’s are located at C:\Program Files (x86)\Google\Google Data API SDK\Redist\.
So with this we are all set to get started to explore SpreadSheet API.
Thanks! for reading till this point
How to get started with Google Spreadsheet API?
How to read conditional data from Google Spreadsheet? How to delete individual row from Google Spreadsheet?
How to read data from Private Google SpreadSheet?
How to read data from Published Google SpreadSheet?
How to delete an existing worksheet from Google Spreadsheet?
How to modify an existing Google Spreadsheet Worksheet?
How to create new worksheet with Google Spreadsheet?
How to read Google SpreadSheet properties?
How to add blank rows and columns into Google SpreadSheet?
How to pull spreadsheet list from Google Doc?
