corienb benninkcorien

benninkcorien / addrightclickopenconsole2here.reg

Created November 30, 2021 12:47

I like Console2 as my command prompt. You can add "Open Console2 Here" to the right-click menu with this reg file.

	Windows Registry Editor Version 5.00

	; I like Console2 as my command prompt.
	; This files adds "Open Console2 Here" to the rightclick menu when you click on a folder.
	; I installed Console2 in C:\Console2
	; -d specifies which directory to open, %V passes the one where you right clicked in
	; no clue what the ,0 is after icon. Probably the first one it finds? Whatever, it works.

	[HKEY_CLASSES_ROOT\Directory\shell\console2]
	@="Open Console2 here"

benninkcorien / replaxe-excel-column-values.py

Last active October 21, 2020 13:41

openpyxl regex replace values in Excel column

	import openpyxl
	import re

	wb = openpyxl.load_workbook('file01.xlsx')
	# print(wb.sheetnames)
	ws = wb["Sheet1"]
	number_rows = ws.max_row

	# Set Column number here !

benninkcorien / ebay_scraper.py

Created October 10, 2020 14:02

Get average price of sold items from Ebay

	import sys
	import requests
	import os
	import re
	from urllib.request import urlopen
	from bs4 import BeautifulSoup

	# changed script from
	# https://www.reddit.com/r/declutter/comments/j6ts24/python_script_to_calculate_average_sell_price_of/