Topics under consideration

What next

Thinking about what to work on next for the Excel Ramblings site, I wondered how I could pull together the work on JSON along with google visualization serialization to open up access to web service capabilities that Excel really doesnt get to easily. Looking at an article by Pete Bromberg on eggheadcafe, it struck me that I could process responses like this and populate Excel Sheets with some structured data taken from sources like otter, or alternatively to stream data live from google docs into Excel – indeed reverse engineering google table data into Excel. This would just mean providing a form where the available fields in the feed can be selected for inclusion in the query, after which it’s just a case of deserializing and formatting in Excel.

Projects under construction/consideration

These are the items I am working on are thinking about

  • Finish the JSON deserializer to handle arrays & data types other than just string.
  • Provide a means to import arbitrary data, as defined by a JSON data feed into Excel
  • Import google docs data into Excel directly using a dataurl mechanism set up in google docs
  • Improve the roadmap project with callouts and clickable shape manipulation

What Else

Please let me have ideas for how these should develop at excel@mcpher.com
bruce

About brucemcp 223 Articles
I am a Google Developer Expert and decided to investigate Google Apps Script in my spare time. The more I investigated the more content I created so this site is extremely rich. Now, in 2019, a lot of things have disappeared or don’t work anymore due to Google having retired some stuff. I am however leaving things as is and where I came across some deprecated stuff, I have indicated it. I decided to write a book about it and to also create videos to teach developers who want to learn Google Apps Script. If you find the material contained in this site useful, you can support me by buying my books and or videos.

Be the first to comment

Leave a Reply

Your email address will not be published.


*


4 × one =