Here's how to use the Google Visualization API to get data out of Google Spreadsheets
As part of playing around with parse.com, here's how to get data into your js app so you can populate parse from Google Spreadsheets. This shows how to sync up this asynchronous activity with others using jQuery promises.
Just how slow is Google Apps Script ?
I'm a big fan of Google Apps Script, but I'm really fed up of seeing "Execution time exceeded". Obviously data access times can be unpredictable, and although it can be improved through caching it's never going to be as good as a local Excel Workbook. But once you have the data loaded, how about processing speeds - shouldn't that be comparable ?
In playing around with color in VBA I introduced a bunch of functions to manipulate various color spaces from VBA. Digging into the whole topic a little more, I wondered if it would be possible to create color palettes from a single color. After some research, I figured that I would try the cie LabLch and HSL color spaces to see how I might do this. Here are a load of VBA functions to make this possible.
Here's a little bit more on the subject of VBA string manipulation. I showed in a post the other day how things take longer and longer when concatenating large strings in VBA.
One reason I was digging into this was that for very large datasets, JSON serialization - 500k strings and above, was taking an inexplicable amount of time. It turned out that string concatenation and the interaction with the garbage collector was at the heart of the problem.
I remember reading an article on Browser optimization (unfortunately I cant remember where now) where the subject of garbage collection and strings was discussed, in particular the behavior of the garbage collector when a certain amount of strings had been allocated. The same thing happens in VBA. Here's how to avoid it.
In documenting VBA procedures automatically I showed how to create web pages that documented your VBA projects. I've updated that now to also include a popup showing the detail of function arguments too. Hover over the procedure name and it will bring up detail on the arguments - here's the documentation for the code that does it (created by itself) http://xliberation.com/googlecharts/docsclassSerializer.html.
I've been on a little diversion playing around with color in VBA, so now it's time to implement some of that in GAS. If you have been following from VBA to Google Apps Script, you'll know that the migration from VBA to Excel is actually pretty trivial for this kind of thing, with most of what's needed already implemented in a shared library.
Here's the detail, and source code on a bunch of color manipulation functions I've ported from VBA to GAS,
In a previous post I covered a way of automatically including and inserting VBA code in Excel from gists. You would normally use this if you wanted to include a bunch of functions and classes and excel references with dependencies on each other in some workbook. However, you can easily use it to just pull in a simple class or function, or even to set up references automatically. The main thing though, is that you can get updates directly from gist as and when required.
One liners to create google Visualization or static html tables from Excel
If you want to embed or publish Excel data to web pages, there are many solutions. Excel 2013 does fancy things with skydrive to share data, and there are plenty of activeX plugins and so on that do the same. Here's a my way to create a simple web page or google visualization table that you can either load directly on a web site, or send to someone, with the option of inheriting the Excel cell style properties.
Sharing your scoops to your social media accounts is a must to distribute your curated content. Not only will it drive traffic and leads through your content, but it will help show your expertise with your followers.
How to integrate my topics' content to my website?
Integrating your curated content to your website or blog will allow you to increase your website visitors’ engagement, boost SEO and acquire new visitors. By redirecting your social media traffic to your website, Scoop.it will also help you generate more qualified traffic and leads from your curation work.
Distributing your curated content through a newsletter is a great way to nurture and engage your email subscribers will developing your traffic and visibility.
Creating engaging newsletters with your curated content is really easy.