Skip to content

Instantly share code, notes, and snippets.

name: WenUDF
description: UDF
host: EXCEL
api_set: {}
script:
content: |
//20220503
/**
* Get Range.
@superyngo
superyngo / export_PDD_order.js
Created March 6, 2025 05:29
拼多多导出訂單油猴脚本 PDD order lists export to excel GreaseMonkey script
// ==UserScript==
// @name PDD订单导出表格
// @namespace https://www.pinduoduo.com/
// @version 1.1
// @description 导出拼多多订单信息
// @AuThor ForkedFrom吾愛破解yiqifeng
// @match https://mobile.yangkeduo.com/orders.html*
// @require https://cdn.staticfile.org/jquery/3.5.0/jquery.min.js
// @grant GM_download
// @run-at document-end
@superyngo
superyngo / mini-nano.ps1
Last active December 31, 2025 01:11
Shell and PowerShell utility scripts
<#
.SYNOPSIS
mini-nano.ps1 - A lightweight PowerShell-based text editor
.DESCRIPTION
A terminal-based text editor similar to nano, written entirely in PowerShell.
Provides essential text editing features with support for multiple file types
and automatic comment symbol detection.
.FEATURES
@superyngo
superyngo / wappman.sh
Last active January 21, 2026 00:17
Application process manager with monitoring capabilities
#!/bin/bash
# wappman.sh
#
# Application process manager with monitoring capabilities:
# - Manages application lifecycle (start/stop/restart)
# - Optional health checking (periodic process monitoring)
# - Optional file watching (auto-restart on file changes)
# - Pure script solution (no systemd/supervisor dependencies)
#
# Usage:
@superyngo
superyngo / wrtman.sh
Last active December 30, 2025 01:56
Manage logrotate configurations
#!/usr/bin/env bash
# wrtman - Manage logrotate configurations
# Usage:
# ./wrtman.sh install [rotate_name]
# ./wrtman.sh uninstall [rotate_name]
# ./wrtman.sh info [rotate_name]
# ./wrtman.sh list
# ./wrtman.sh test [rotate_name]
# v0.2.1 fix config permission, add permission check for testing
@superyngo
superyngo / rclonemm.ps1
Last active January 11, 2026 16:17
Manage rclone mount through ssh config.
<#
.SYNOPSIS
rclone Mount 管理工具 (PowerShell 版本)
.DESCRIPTION
功能: mount, unmount, status, show, help
使用 SSH config 設定掛載 rclone SFTP remote 到本地目錄
.PARAMETER Operation
操作類型: mount/mnt, unmount/umount/umnt, status, show, help
@superyngo
superyngo / reformat_ventoy.sh
Created January 5, 2026 06:08
Reformat vetoy 1st partition and auto create another efi partiton for refind.
#!/bin/bash
set -e
# ====================================================
# 功能:
# 1️⃣ 若第 1 分割區非指定 FS,重新格式化為指定格式 (預設 xfs)
# 2️⃣ 若尾端有未分配空間且 >32MB,自動建立 FAT32 分區 label="refind"
# 3️⃣ 自動偵測並安裝必要格式化工具
# 4️⃣ 支援 --dry-run 模式(只顯示不執行)
# ====================================================
@superyngo
superyngo / ssh-copy-id.ps1
Created January 5, 2026 06:10
ssh-copy-id for windows powershell
param(
[string]$IdentityFile = "$env:USERPROFILE\.ssh\id_rsa.pub",
[Parameter(ValueFromRemainingArguments = $true)]
[string[]]$Target
)
function Print-Usage {
Write-Host "Usage: ssh-copy-id [-i identity_file] user@host"
exit 1
}
@superyngo
superyngo / gpinstaller.ps1
Last active May 19, 2026 01:04
GitHub Packages Generic Installation Script
#!/usr/bin/env pwsh
# gpinstaller — Generic GitHub Packages Installer (Windows)
# =========================================================
# Downloads the latest release binary from any GitHub repo and installs it
# to a per-user or system-wide location based on the caller's privilege.
#
# Required env: APP_NAME, REPO (REPO required for install)
# Optional env:
# INSTALL_DIR - override install directory
# UNINSTALL - "true" to uninstall (from default path only)
@superyngo
superyngo / sync_ssh_config.ps1
Last active February 23, 2026 02:52
sync ssh config
$SSHOpts = @('-o', 'ConnectTimeout=5', '-o', 'BatchMode=yes')
$DefaultParallel = 5
function Show-Usage {
Write-Host @"
用法: sync_ssh_config.ps1 [選項]
將本機 ~/.ssh/config 同步到所有 SSH config 中定義的遠端主機。
選項: