book000

Sub Zoom100CursorA1NormalView()
    ' ScreenUpdatingを切るとA1セルがアクティブにはなるが、表示範囲が変わらない
    Dim sheet As Object
    For Each sheet In ActiveWorkbook.Sheets
        sheet.Activate
        ActiveSheet.Range("A1").Select
        ActiveWindow.Zoom = 100
        ActiveWindow.View = xlNormalView
    Next sheet
    Sheets(1).Select

book000

#!/bin/bash
function devopen() {
    local workspace_folder="$(readlink -f "$1")"

    if [ -d "$workspace_folder" ]; then
        local wsl_path="$(wslpath -w "$workspace_folder")"
        local path_id=$(printf "%s" "$wsl_path" | xxd -ps -c 256)

        code --folder-uri "vscode-remote://dev-container%2B${path_id}/workspaces/$(basename "$workspace_folder")"
    else

book000

# GitHubリポジトリをクローンするPowerShellスクリプト

# 関数: GitHubリポジトリのURLが有効かどうかを確認する
function Test-GitHubRepositoryURL {
  param (
    [string]$URL
  )

  if ($URL -notmatch '^https:\/\/github\.com\/.+\/.+') {
    Write-Host "エラー: 正しいGitHubリポジトリのURLを入力してください。" -ForegroundColor Red

book000

# package.jsonが無ければエラーを表示して終了する
if (-not (Test-Path .\package.json)) {
  Write-Host "Error: package.json not found." -ForegroundColor Red
  exit 1
}

# package.jsonのeslintがv9以上だったら、v9では動作しないことを表示して終了する
$package_json = Get-Content -Path package.json -Raw | ConvertFrom-Json -AsHashtable
$eslint_version = $package_json.devDependencies.eslint
if ($eslint_version -ge "9.0.0") {

book000

class DxdiagParser {
  constructor(dxdiag) {
    this.dxdiag = dxdiag;

    this.isDebug = false;
    this.parsableSections = [
      "System Information",
      "DxDiag Notes",
      "DirectX Debug Levels",
      "Display Devices",

book000

/*
This script is for toggling all bookmarks on pixiv to public or private.

Open your own pixiv user page, switch to the bookmarks tab, and then run this script in the browser console.
(e.g., https://www.pixiv.net/users/{userId}/bookmarks/artworks)
*/

/**
 * Wait for an element to appear in the DOM and resolve with it.
 *

book000

#!/bin/bash
cd "$(dirname "$0")" || exit 1

# ロックファイルのパス
LOCKFILE="$(realpath "$0").lock"

# ファイルディスクリプタ9でロックを取得 (エラーメッセージを無視)
exec 9>"$LOCKFILE" 2>/dev/null
if [ $? -ne 0 ]; then
  echo "Failed to open lockfile $LOCKFILE. It seems to be already running."

book000

Sub ListSheetNames()
    Dim ws As Worksheet
    Dim sheetNames() As String
    Dim i As Integer
    Dim listSheet As Worksheet
    
    ' 画面更新と自動計算を一時停止
    Application.ScreenUpdating = False
    Application.Calculation = xlCalculationManual
    

book000

import json
import sqlite3
import pandas as pd
import os

appdata_path = os.getenv('APPDATA')
dbpath = os.path.join(appdata_path, 'VRCX', 'VRCX.sqlite3')
print("DB Path: " + dbpath)
conn = sqlite3.connect(dbpath)

book000

SELECT
	gl.rowid AS join_id,
	gl.created_at AS world_created_at,
	gl.location AS instance_id,
	gl.world_id AS world_id,
	gl.world_name AS world_name,
	gl.time AS instance_elapsed_time,
	gl.group_name AS instance_group_name,
	gvp.created_at AS video_created_at,
	gvp.video_url AS video_url,