19 lines
470 B
Bash
Executable File
19 lines
470 B
Bash
Executable File
#!/bin/bash
|
|
# https://docs.sheetjs.com/docs/demos/data/sqlite/#nodejs-demo
|
|
|
|
cd /tmp
|
|
rm -rf sheetjs-sqlite
|
|
mkdir sheetjs-sqlite
|
|
cd sheetjs-sqlite
|
|
npm init -y
|
|
|
|
npm i --save better-sqlite3@12.6.2 https://cdn.sheetjs.com/xlsx-latest/xlsx-latest.tgz
|
|
|
|
curl -L -O https://docs.sheetjs.com/sqlite/chinook.sql
|
|
sqlite3 chinook.db ".read chinook.sql"
|
|
|
|
curl -L -O https://docs.sheetjs.com/sqlite/SheetJSQLiteNode.mjs
|
|
|
|
node SheetJSQLiteNode.mjs
|
|
|
|
npx xlsx-cli -l SheetJSQLiteNode.xlsx |