Skip to content

Instantly share code, notes, and snippets.

View asilachev's full-sized avatar

Alex Silachev asilachev

View GitHub Profile
@asilachev
asilachev / excel_vb_tools.vb
Last active November 4, 2016 07:27
Excel VB tools
Sub UnhideAllSheets()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Visible = xlSheetVisible
Next ws
End Sub
Sub HideAllSheets()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
#include <stdio.h>
void find_deviation(int *v, int v_length, int d) {
int i;
int j;
int max_deviation = 0;
int value;
int min;
/usr/bin/plutil -convert xml1 -o - ~/Library/Safari/Bookmarks.plist | grep -E -o '<string>http[s]{0,1}://.*</string>' | grep -v icloud | sed -E 's/<\/{0,1}string>//g'
from django.conf import settings
# Defining alphabet of custom base as [a-z] + [A-Z] + [0-9]
alphabet = map(chr, range(97, 123) + range(65, 91)) + map(str, range(0, 10))
base = len(alphabet)
def encode(str):
reversed_str = str[::-1]
pow_num = 0
#!/usr/bin/env python
import argparse
import glob
import os
import sys
from transliterate import translit
Sub Main()
Dim i, f, path, lastCol
f = FreeFile
path = "output.txt"
Open path For Output As #f
lastCol = ActiveSheet.UsedRange.Columns(ActiveSheet.UsedRange.Columns.Count).Column
For i = 1 To lastCol
Print #f, Cells(1, i).Width
Next

Keybase proof

I hereby claim:

  • I am asilachev on github.
  • I am asilachev (https://keybase.io/asilachev) on keybase.
  • I have a public key whose fingerprint is 08F6 2EC4 8618 2E5C 19FC 2D21 B8DE F173 CA46 1E05

To claim this, I am signing this object: