116 lines
3.2 KiB
PowerShell
116 lines
3.2 KiB
PowerShell
|
#!/usr/bin/env pwsh
|
||
|
|
# https://docs.sheetjs.com/docs/demos/cli/nodesea
|
||
|
|
|
||
|
|
$oldDir = Get-Location
|
||
|
|
$tempDir = Join-Path -Path $env:TEMP -ChildPath "sheetjs-sea"
|
||
|
|
if (Test-Path -Path $tempDir) { Remove-Item -Path $tempDir -Recurse -Force }
|
||
|
|
New-Item -ItemType Directory -Path $tempDir | Out-Null
|
||
|
|
Set-Location -Path $tempDir
|
||
|
|
|
||
|
|
# NOTE: This effectuates "Native Tools Command Prompt"
|
||
|
|
|
||
|
|
$vsVersions = @("2022\Community", "2022\Professional", "2022\Enterprise", "2019\Community")
|
||
|
|
|
||
|
|
foreach ($vsVersion in $vsVersions) {
|
||
|
|
$vcbasePath = "${env:ProgramFiles}\Microsoft Visual Studio\$vsVersion"
|
||
|
|
$vcvarsPath = "${env:ProgramFiles}\Microsoft Visual Studio\$vsVersion\VC\Auxiliary\Build\vcvars64.bat"
|
||
|
|
if (Test-Path -Path $vcvarsPath) { break }
|
||
|
|
}
|
||
|
|
|
||
|
|
$tempEnvFile = [System.IO.Path]::GetTempFileName()
|
||
|
|
|
||
|
|
Push-Location "$vcbasePath"
|
||
|
|
cmd.exe /c "`"$vcvarsPath`" && set > `"$tempEnvFile`""
|
||
|
|
Pop-Location
|
||
|
|
|
||
|
|
Get-Content "$tempEnvFile" | ForEach-Object { if ($_ -match '^([^=]+)=(.*)$') {
|
||
|
|
$name = $matches[1]
|
||
|
|
$value = $matches[2]
|
||
|
|
|
||
|
|
if ($name -ne 'PATH') {
|
||
|
|
Set-Item -Path "Env:$name" -Value $value
|
||
|
|
} else {
|
||
|
|
$env:PATH = "$value;$env:PATH"
|
||
|
|
}
|
||
|
|
} }
|
||
|
|
|
||
|
|
Remove-Item "$tempEnvFile" -Force -ErrorAction SilentlyContinue
|
||
|
|
|
||
|
|
node --version
|
||
|
|
|
||
|
|
npm init -y
|
||
|
|
|
||
|
|
@'
|
||
|
|
// For NodeJS SEA, the CommonJS `require` must be used
|
||
|
|
const { createRequire } = require('node:module');
|
||
|
|
require = createRequire(__filename);
|
||
|
|
const { readFile, utils } = require("xlsx");
|
||
|
|
|
||
|
|
// argv[2] is the first argument to the script
|
||
|
|
const filename = process.argv[2];
|
||
|
|
|
||
|
|
// read file
|
||
|
|
const wb = readFile(filename);
|
||
|
|
|
||
|
|
// generate CSV of first sheet
|
||
|
|
const ws = wb.Sheets[wb.SheetNames[0]];
|
||
|
|
const csv = utils.sheet_to_csv(ws);
|
||
|
|
|
||
|
|
// print to terminal
|
||
|
|
console.log(csv);
|
||
|
|
'@ | Out-File -FilePath "sheet2csv.js" -Encoding utf8
|
||
|
|
|
||
|
|
npm i --save https://cdn.sheetjs.com/xlsx-latest/xlsx-latest.tgz
|
||
|
|
|
||
|
|
### Script Test
|
||
|
|
|
||
|
|
Invoke-WebRequest -Uri "https://docs.sheetjs.com/pres.numbers" -OutFile "pres.numbers"
|
||
|
|
|
||
|
|
node sheet2csv.js pres.numbers
|
||
|
|
|
||
|
|
### SEA Bundle
|
||
|
|
|
||
|
|
@'
|
||
|
|
{
|
||
|
|
"main": "sheet2csv.js",
|
||
|
|
"output": "sheet2csv.blob"
|
||
|
|
}
|
||
|
|
'@ | Out-File -FilePath "sheet2csv.json" -Encoding utf8
|
||
|
|
|
||
|
|
node --experimental-sea-config sheet2csv.json
|
||
|
|
|
||
|
|
# Local Copy
|
||
|
|
$nodePath = (Get-Command node).Source
|
||
|
|
Copy-Item $nodePath "sheet2csv.exe"
|
||
|
|
|
||
|
|
# Remove the code signature
|
||
|
|
# (windows)
|
||
|
|
signtool remove /s .\sheet2csv.exe
|
||
|
|
|
||
|
|
# Inject the SEA bundle
|
||
|
|
## NOTE: npx -y postject seemed to fail in windows :(
|
||
|
|
npm i -g postject
|
||
|
|
postject --sentinel-fuse NODE_SEA_FUSE_fce680ab2cc467b6e072b8b5df1996b2 sheet2csv.exe NODE_SEA_BLOB sheet2csv.blob
|
||
|
|
|
||
|
|
# Resign the binary
|
||
|
|
$cert = New-SelfSignedCertificate -Type CodeSigning -DnsName "www.onlyspans.net" -CertStoreLocation Cert:\CurrentUser\My
|
||
|
|
$pass = ConvertTo-SecureString -String "hunter2" -Force -AsPlainText
|
||
|
|
Export-PfxCertificate -Cert "cert:\CurrentUser\My\$($cert.Thumbprint)" -FilePath "mycert.pfx" -Password $pass
|
||
|
|
|
||
|
|
## NOTE: if self-signed cert is not trusted, verify will show an error
|
||
|
|
$cert | Export-Certificate -FilePath "mycert.cer"
|
||
|
|
Import-Certificate -FilePath "mycert.cer" -CertStoreLocation Cert:\CurrentUser\Root | Out-Null
|
||
|
|
|
||
|
|
signtool sign /v /f mycert.pfx /p hunter2 /fd SHA256 sheet2csv.exe
|
||
|
|
|
||
|
|
### Standalone Test
|
||
|
|
|
||
|
|
.\sheet2csv.exe pres.numbers
|
||
|
|
|
||
|
|
# Validate the signature
|
||
|
|
|
||
|
|
signtool verify /v /pa sheet2csv.exe
|
||
|
|
|
||
|
|
Set-Location $oldDir
|
||
|
|
Remove-Item -Path $tempDir -Recurse -Force
|