Google Apps Script Content Service – Cross Domain Puzzle More cool stuff you can do with Google Apps ScriptDbĪre the new Google Sheets faster than the old? Google Universal Analytics – getting insight into desktop apps too I’ve just been recognised as a Google Developer Expert as a substitute for ScriptDB in Google Apps ScriptĮurovision song contest voting oddities – interactive visualization Using universal analytics to track your Google Apps Script library usage How many requests a second can you throw at your Google Apps Script webapp Google Apps Script locking and optimum wait times and the golden ratio Some best practise notes on DbAbstraction usage Running JavaScript directly from Excel makes ‘going Google’ easier Targeting training material for Google Apps ScriptersĪ belated post – 2015 – a year in Apps Script What I’ve learned from my first play around with BigQuery/Sheets integration Using an Apps Script webapp to distribute assets Use a spreadsheet as a database in 5 minutesĢ018 – yet another year in and out of Google Apps ScriptĪpps Script Back end platform – some thoughts on a different approachĪpp Maker – Build engaging custom apps on G Suite with minimal coding Google Apps Script – What a difference 5 years make Google Apps Script – What a difference 5 years make – Episode 2 write_url ( row, col, '' + data, string = cell_data.

class UrlWriter ( Writer ): def write_cell ( self, row, col, cell_data, cell_format, data ): if cell_data. Note that this method is used bothįor writing header and rows - for header the data parameter is None. (instance of json_excel_converter.Value) and data (the originalĭata being written to this row). Note: this will only be rendered in XLSX output, CSV output will silently

url = lambda data : data conv = Converter ( options ) conv. Simple json options = Options () options.

A package that converts json to CSV, excel or other table formats

Exceltojson