Install yt-dlp on Windows
winget install yt-dlp
Install ffmpeg
winget install ffmpeg
/** | |
* Delete columns and rows | |
*/ | |
function DeleteColumnsAndRows() { | |
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); | |
var sheet = spreadsheet.getSheetByName("SHEET-NAME-HERE"); | |
// sheet.getRange(1, 2, sheet.getMaxRows(), sheet.getMaxRows()).activate(); | |
// Delete column B to max | |
if (sheet.getMaxColumns() > 1) { |
Install yt-dlp on Windows
winget install yt-dlp
Install ffmpeg
winget install ffmpeg
Create a new gist: https://gist.github.com/new
:: Set key variable as full path the the private key id_rsa file :: | |
:: set key="%userprofile%\.ssh\id_rsa" | |
set keyname="ocifree" | |
set key=%~dp0%\%keyname% | |
:: Remove default inheritance :: | |
cmd /c icacls %key% /c /t /inheritance:d | |
:: Set ownership to the owner :: |
$today = Get-Date -Format yyyyMMdd | |
# Install the Microsoft Graph Powershell module | |
Install-Module Microsoft.Graph | |
# Install the Microsoft Azure AD module | |
Install-Module AzureAD | |
# Using credential | |
$credential = Get-Credential |
# Add PERMENANT entry to %PATH% environment variable - Add to Registry | |
$addToPath = "C:\Program Files\Amazon\AWSCLIV2" | |
$currentPath = (Get-ItemProperty -Path 'Registry::HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\Environment' -Name PATH).path | |
$newPath = "$currentPath;$addToPath" | |
Set-ItemProperty -Path 'Registry::HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\Environment' -Name PATH -Value $newPath |
<!-- Post URL QR Code--> | |
<div> | |
<img expr:alt='"QR Code of " + data:post.title' expr:src='"https://chart.googleapis.com/chart?chs=120x120&cht=qr&chl=" + data:post.url + "&choe=UTF-8"'/> | |
</div> |
<table> | |
<caption style="caption-side:bottom;" >Caption here</caption> | |
<thead> | |
<tr> | |
<th>Header1</th> | |
<th>Header2</th> | |
</tr> | |
</thead> | |
<tbody> | |
<tr> |