Smartsheet API: developer tools and resources - Smartsheet.com
www.smartsheet.com
on 05/15/2013
Excerpt:... read the full post.
Tags: , API-Evangelist, API-Stack, Collaboration, smartsheetapi, Spreadsheet
Geocoding Part II: Geocoding Data in a Google Docs Spreadsheet
schoolofdata.org
on 02/19/2013
Excerpt: A very common need is to geocode data in a Google Spreadsheet (for example, in creating TimeMaps with the Timeliner project). There are several options here:
By hand – use a Geocoding service (see the previous post) and then copy and paste by hand. Use the ImportXML (or ImportCSV) formulae to grab data from a geocoding service – great but with limitations on the number of rows you can code at one time (~50). Use a Google App Script – the most powerful but requires installation of an App Script in your spreadsheet. In this tutorial I’m going to cover the latter two automated options and specifically focus on option 2. All of the following is illustrated live in this google spreadsheet.... read the full post.
Tags: API-Evangelist, API-Stack, APIs, Google Docs, Spreadsheet
Manipulate the worksheets uploaded at Amazon S3 Storage using Saaspose.Cells REST API
saaspose.com
on 11/05/2012
Excerpt: Workbooks are extensively used by a number of people from different walks of life for data analysis and information sharing. The worksheets contain the information such as charts, images, numerical data, hyperlinks, comments, formulas. Saaspose. Cells is a REST based API that supports manipulation of workbooks in the cloud. There are a number of operations that can be performed on the data to achieve multiple tasks involved in document manipulation e. g. you may want to get a specific chart or shape from the worksheet. Saaspose storage is the default storage for uploading the files and processing them with Saaspose. Cells. Saaspose offers you to manipulate the worksheets uploaded at Amazon S3 storage using Saaspose. Cells REST API.... read the full post.
Tags: API-Evangelist, Conversion, Documents, Spreadsheet
Excerpt: A very common need is to geocode data in a Google Spreadsheet (for example, in creating TimeMaps with the Timeliner project). There are several options here: By hand – use a Geocoding service (see the previous post) and then copy and paste by hand. Use the ImportXML (or ImportCSV) formulae to grab data from a geocoding service – great but with limitations on the number of rows you can code at one time (~50). Use a Google App Script – the most powerful but requires installation of an App Script in your spreadsheet. In this tutorial I’m going to cover the latter two automated options and specifically focus on option 2. All of the following is illustrated live in this google spreadsheet.... read the full post.
Tags: API-Evangelist, API-Stack, APIs, Google Docs, Spreadsheet
