Skip to content

Instantly share code, notes, and snippets.

@pmdroid
pmdroid / xlsx.ts
Created April 29, 2021 08:54
xlsx to json parsing
import * as _ from 'lodash';
import * as csv from 'fast-csv';
import * as ExcelJS from 'exceljs';
export interface Column {
key: string;
header: string;
}
export async function xlsxToJSON<T>(filePath: string, columns: Partial<Column>[]): Promise<T[]> {
We can't make this file beautiful and searchable because it's too large.
Ort;Plz;Bundesland
Aach;54298;Rheinland-Pfalz
Aach;78267;Baden-Württemberg
Aachen;52062;Nordrhein-Westfalen
Aachen;52064;Nordrhein-Westfalen
Aachen;52066;Nordrhein-Westfalen
Aachen;52068;Nordrhein-Westfalen
Aachen;52070;Nordrhein-Westfalen
Aachen;52072;Nordrhein-Westfalen
Aachen;52074;Nordrhein-Westfalen
@pmdroid
pmdroid / setup.sh
Last active December 1, 2016 12:12
dev setup
#!/bin/bash
GLOBAL_NPM='servedir mversion gulp grunt-cli ntl nodemon'
ZSH_PLUGINS='git atom docker brew go node npm'
declare -a APM_PACKAGES=("atom-beautify" "file-icons" "genesis-ui" "linter" "linter-xo" "react" "language-babel" "atom-ternjs" "docblockr" "hyperclick" "js-hyperclick" "imdone-atom")
LIST_PACKAGES='Caskroom/versions/java7 android-platform-tools elasticsearch redis wget mongodb glide homebrew/versions/node5 zsh go graphicsmagick dockutil git git-flow'
declare -a BREW_AUTOSTART=("redis" "mongodb" "elasticsearch")
## brew
/usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
@pmdroid
pmdroid / remove-all-builds.java
Last active May 27, 2016 15:35
remove all jenkins builds
import hudson.model.*
// For each project
for(item in Hudson.instance.items) {
// check that job is not building
if(!item.isBuilding()) {
System.out.println("Deleting all builds of job "+item.name)
for(build in item.getBuilds()){
build.delete()
}
}