theangkko

name: NeutriumJSSteam
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
  content: >-
    $("#run").click(() => tryCatch(run));


    async function run() {

theangkko

CMake를 왜 쓰는거죠?
좋은 툴은 Visual Studio 뿐입니다. 그 이외에는 전부 사도(邪道)입니다 사도! - 작성자

주의

• 이 문서는 CMake를 주관적으로 서술합니다
• 이 문서를 통해 CMake를 시작하기엔 적합하지 않습니다
  https://cgold.readthedocs.io/en/latest/ 3.1 챕터까지 따라해본 이후 기본사항들을 속성으로 익히는 것을 돕기위한 보조자료로써 작성되었습니다

theangkko

name: tgJS
description: |-
  OfficeJS-JavaScript & Promises
  by theangkko
host: EXCEL
api_set: {}
script:
  content: |
    $("#run").click(() => tryCatch(run));
    function run() {

theangkko

name: tgCF
description: |-
  OfficeJS-excel custom function
  by theangkko
host: EXCEL
api_set: {}
script:
  content: >
    // $("#run").click(() => tryCatch(run)); // async function run() { //  
    await Excel.run(async (context) => { //     const sheet =

theangkko

FROM python:3.10 as python-base

# https://python-poetry.org/docs#ci-recommendations
ENV POETRY_VERSION=1.2.0
ENV POETRY_HOME=/opt/poetry
ENV POETRY_VENV=/opt/poetry-venv

# Tell Poetry where to place its cache and virtual environment
ENV POETRY_CACHE_DIR=/opt/.cache

theangkko

Function Check-RunAsAdministrator()
{
  #Get current user context
  $CurrentUser = New-Object Security.Principal.WindowsPrincipal $([Security.Principal.WindowsIdentity]::GetCurrent())
  
  #Check user is running the script is member of Administrator Group
  if($CurrentUser.IsInRole([Security.Principal.WindowsBuiltinRole]::Administrator))
  {
       Write-host "Script is running with Administrator privileges!"
  }

theangkko

Set-ExecutionPolicy Bypass ` -Scope Process ` -Force
Invoke-Expression ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))

choco install git  -y
# choco install googlechrome vscode  -y


$progressPreference = 'silentlyContinue'
Write-Information "Downloading WinGet and its dependencies..."
Invoke-WebRequest -Uri https://aka.ms/getwinget -OutFile Microsoft.DesktopAppInstaller_8wekyb3d8bbwe.msixbundle

theangkko

# https://stackoverflow.com/questions/44767554/sorting-with-openpyxl


def sheet_sort_rows(ws, row_start, row_end=0, cols=None, sorter=None, reverse=False):
""" Sorts given rows of the sheet
    row_start   First row to be sorted
    row_end     Last row to be sorted (default last row)
    cols        Columns to be considered in sort
    sorter      Function that accepts a tuple of values and
                returns a sortable key

theangkko

# https://endjin.com/blog/2023/03/how-to-setup-python-pyenv-poetry-on-windows


[CmdletBinding()]
param (
    [Parameter(Mandatory=$true)]
    [string] $PythonVersion
)

$ErrorActionPreference = "Stop"

theangkko

    # ------------------------------------------------------------------
    # Excelの定数を設定
    # ------------------------------------------------------------------
    # https://excel-ubara.com/EXCEL/EXCEL905.html
    # https://docs.microsoft.com/en-us/office/vba/api/excel(enumerations)
    # https://docs.microsoft.com/ja-jp/office/vba/api/excel(enumerations)
    # ------------------------------------------------------------------
    # Excelの定数を取得する方法もあるようです。
    # https://wacky.hatenadiary.com/entry/20091011/1255240572