This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# May 4, 2024 | |
# convert all files in a folder from xlsx to csv or the other way around | |
# run like ".\convert2.ps1 xlsx csv" or ".\convert2.ps1 csv xlsx" | |
param ( | |
[string]$src, | |
[string]$dst | |
) | |
$excel = New-Object -ComObject excel.application |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
'--------------------------------------------------------------------------------------- | |
' Module : modSQL | |
' Author : Michiel van der Blonk (blonkm@gmail.com) | |
' Date : 10/1/2015 | |
' Purpose : generate SQL queries from Excel cell data | |
'--------------------------------------------------------------------------------------- | |
Option Explicit | |
Enum eEscape |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# (c) Michiel van der Blonk | |
# blonkm@gmail.com | |
# @name SchoologyGetLatestSubmissions.ps1 | |
# @date 2015-06-12 | |
# @description Get only last revision from a Schoology submissions download | |
# @notes copies files to a new folder on the destination named schoology_<date> | |
# @args | |
# path defaults to current directory | |
# destination defaults to desktop |