Skip to content

Instantly share code, notes, and snippets.

View gedankenexperimenter's full-sized avatar

Michael Richters gedankenexperimenter

  • Winnipeg, MB
View GitHub Profile
# -*- coding: utf-8 -*-
import click
import os
import pandas as pd
def file_split(file):
s = file.split('.')
name = '.'.join(s[:-1]) # get directory name
@gedankenexperimenter
gedankenexperimenter / export-to-csv.gs
Created June 13, 2018 16:31 — forked from mderazon/export-to-csv.gs
Google apps script to export to individual csv files all sheets in an open spreadsheet
/*
* script to export data in all sheets in the current spreadsheet as individual csv files
* files will be named according to the name of the sheet
* author: Michael Derazon
*/
function onOpen() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var csvMenuEntries = [{name: "export as csv files", functionName: "saveAsCSV"}];
ss.addMenu("csv", csvMenuEntries);