Thiago Filadelfo trfiladelfo

trfiladelfo / Coce.gs

Created April 26, 2020 16:14 — forked from dommmel/Coce.gs

Google Apps Script to upload and import a CSV File into a Google Spreadsheet

	// http://stackoverflow.com/questions/11273268/script-import-local-csv-in-google-spreadsheet

	function onOpen() {
	var ss = SpreadsheetApp.getActiveSpreadsheet();
	var csvMenuEntries = [{name: "Upload CSV file", functionName: "doGet"}];
	ss.addMenu("CSV", csvMenuEntries);
	}

	function doGet(e) {
	var app = UiApp.createApplication().setTitle("Upload CSV to Sheet");

trfiladelfo / export-to-csv.gs

Created April 26, 2020 16:14 — forked from franklinbaldo/export-to-csv.gs

Google apps script to export to individual csv files all sheets in an open spreadsheet

	function myFunction() {
	var ss = SpreadsheetApp.getActive();
	var sheet = ss.getSheetByName("orange");

	var range = sheet.getRange("1:1").getValues();
	var titles = range[0];
	var a1range = "A1:A";
	var a1array = [];
	a1range = a1range +titles.length*titles.length;
	var b1range = "B1:B";

trfiladelfo / mongodb_model.py

Created April 29, 2020 13:18 — forked from fatiherikli/mongodb_model.py

Very simple MongoDB Model in Python

	from pymongo import Connection
	from bson import ObjectId
	from itertools import imap


	class Model(dict):
	"""
	A simple model that wraps mongodb document
	"""
	__getattr__ = dict.get

trfiladelfo / Code.gs

Created June 3, 2021 03:05 — forked from superstrong/Code.gs

Google Script to generate a UUID in Google Sheets

	function getId() {
	/**
	* Imported from https://github.com/kyo-ago/UUID
	* Robbie Mitchell, @superstrong
	*/

	/**
	* UUID.core.js: The minimal subset of the RFC-compliant UUID generator UUID.js.
	*
	* @fileOverview