###Batch import CSV to a Spreadsheet http://stackoverflow.com/questions/17578317
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// vim: ft=javascript: | |
/*jslint sloppy: true, vars: true, white: true, nomen: true, browser: true */ | |
/*global SpreadsheetApp, UiApp, UrlFetchApp, Utilities */ | |
/* | |
* A script to automate requesting data from an external url that outputs CSV data. | |
* | |
* Adapted from the Google Analytics Report Automation (magic) script. | |
* @author nickski15@gmail.com (Nick Mihailovski) | |
* @author ianmlewis@gmail.com (Ian Lewis) | |
*/ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
* Copyright 2017 Mohsen Mesgarpour | |
* | |
* Licensed under the Apache License, Version 2.0 (the "License"); | |
* you may not use this file except in compliance with the License. | |
* You may obtain a copy of the License at | |
* | |
* http://www.apache.org/licenses/LICENSE-2.0 | |
* | |
* Unless required by applicable law or agreed to in writing, software |
In this report, I would like to introduce a workaround for automatically recalculating custom functions on Spreadsheet.
The sample situation is below. This is a sample situation for this document.
- There are 3 sheets with "sheet1", "sheet2" and "sheet3" of sheet name in a Spreadsheet.
- Calculate the summation of values of "A1" of each sheet using a custom function.
- Sample script of the custom function is as follows.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!-- LINE Tag Base Code --> | |
<!-- Do Not Modify --> | |
<script> | |
(function(g,d,o){ | |
g._ltq=g._ltq||[];g._lt=g._lt||function(){g._ltq.push(arguments)}; | |
var h=location.protocol==='https:'?'https://d.line-scdn.net':'http://d.line-cdn.net'; | |
var s=d.createElement('script');s.async=1; | |
s.src=o||h+'/n/line_tag/public/release/v1/lt.js'; | |
var t=d.getElementsByTagName('script')[0];t.parentNode.insertBefore(s,t); | |
})(window, document); |