Skip to content

Instantly share code, notes, and snippets.

View jgstew's full-sized avatar

JGStew jgstew

View GitHub Profile
@jgstew
jgstew / ExcelComAutomationExample.py
Last active September 15, 2015 20:43
Automating Excel with Python using Win32com interface
import time
import random
# win32com does not come with python
from win32com.client import Dispatch
xlApp = Dispatch("Excel.Application")
xlApp.Visible = 1
xlApp.Workbooks.Add()
# http://web.archive.org/web/20090916091434/http://www.markcarter.me.uk/computing/python/excel.html
# http://stackoverflow.com/questions/510348/how-can-i-make-a-time-delay-in-python
time.sleep(.5)
' !!! Moved to here: https://github.com/jgstew/tools/blob/master/VBS/msiGetProperty.vbs
' written by James Stewart ( @jgstew )
' public domain, use at your own risk
' this vbs script will get msi property values
' the default is to get "ProductName"
' the default can be changed by renaming the file, or changing the initial msiProperty value
' Example: msiGetPropertyProductVersion.vbs will get ProductVersion
' !!! Moved to here: https://github.com/jgstew/tools/blob/master/VBS/zipGetFilesList.vbs
' zipGetFilesList.vbs
' Written by James Stewart ( @jgstew )
' Public Domain - use at your own risk
@jgstew
jgstew / char_stats.py
Last active August 29, 2015 14:22
parse character stats from http://arcticmud.org/
# parse character stats from http://arcticmud.org/
# - likely works with other MUDs
import re
# http://regexr.com/397kv
# http://www.pythonregex.com/
# Str (?P<Str>\d+) Int (?P<Int>\d+) Wis (?P<Wis>\d+) Dex (?P<Dex>\d+) Con (?P<Con>\d+)( Cha )*(?P<Cha>\d+)*
# Str (\d+) Int (\d+) Wis (\d+) Dex (\d+) Con (\d+)
def main(sCharStats):
import re
@jgstew
jgstew / FizzBuzz.py
Last active August 29, 2015 14:22
Fizz Buzz example, for no real reason.
# example FizzBuzz
def FizzBuzz(iMax = 100):
for num in xrange(1,iMax+1):
msg = ''
if num % 3 == 0:
msg += 'Fizz'
if num % 5 == 0:
msg += 'Buzz'
print msg or num
{
"AWSTemplateFormatVersion" : "2010-09-09",
"Description" : "AWS CloudFormation Template to create a BigFix Evaluation root server within the resource limits of the AWS Free Tier."
}
@jgstew
jgstew / clientsettings.cfg
Last active October 3, 2018 01:09
An example clientsettings.cfg to set the default BigFix client settings at install time. Only works with the Windows EXE installer or the OS X installer. For linux, see here: https://github.com/jgstew/tools/blob/master/bash/install_bigfix.sh
__RelaySelect_Automatic=1
_BESClient_Resource_StartupNormalSpeed=1
_BESClient_Download_RetryMinutes=1
_BESClient_Download_CheckAvailabilitySeconds=120
_BESClient_Resource_WorkIdle=20
_BESClient_Resource_SleepIdle=500
_BESClient_PowerHistory_EnablePowerHistory=1
_BESClient_Comm_WakeOnLanForwardingEnable=1
_BESClient_Comm_CommandPollEnable=1
_BESClient_Comm_CommandPollIntervalSeconds=7200