This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
WORKSHEET FILE FORMAT | |
FROM LOTUS | |
INTRODUCTION AND QUICK REFERENCE | |
Copyright(c) 1984, Lotus Development Corporation | |
161 First Street | |
Cambridge, Massachusetts 02142 | |
(617) 492-7171 | |
Electronic Edition, December, 1984 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* require XLSX */ | |
var XLSX = require('XLSX') | |
function datenum(v, date1904) { | |
if(date1904) v+=1462; | |
var epoch = Date.parse(v); | |
return (epoch - new Date(Date.UTC(1899, 11, 30))) / (24 * 60 * 60 * 1000); | |
} | |
function sheet_from_array_of_arrays(data, opts) { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
set -o pipefail | |
UZIPVER=$(date "+0.%Y%m%d.0") | |
# Remove and re-clone | |
rm -rf UZIP.js | |
git clone https://github.com/photopea/UZIP.js/ | |
cd UZIP.js | |
# Generate package.json |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<html xmlns:v="urn:schemas-microsoft-com:vml" | |
xmlns:o="urn:schemas-microsoft-com:office:office" | |
xmlns:x="urn:schemas-microsoft-com:office:excel" | |
xmlns="http://www.w3.org/TR/REC-html40"> | |
<head> | |
<meta http-equiv=Content-Type content="text/html; charset=utf-8"> | |
<meta name=ProgId content=Excel.Sheet> | |
<meta name=Generator content="Microsoft Excel 14"> | |
<link id=Main-File rel=Main-File |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* this sample was run in nodejs */ | |
var XLSX = require('xlsx'); | |
/* build up a very simple workbook */ | |
var wb = { | |
SSF: XLSX.SSF.get_table(), | |
SheetNames: ["Sheet1"], | |
Sheets: { | |
Sheet1: { | |
'!ref': 'A1:A1', |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
UEsDBBQABgAIAAAAIQDpA5ilpwEAAGcHAAATAAgCW0NvbnRlbnRfVHlwZXNdLnhtbCCiBAIooAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADMld1O4zAQhe+R9h0i365ityygFWrKBbCXgAQ8wNSeNqaObXlMad+eSQoVu+q2VFSiN/lz5pxvbOt4cDFvXDHDRDb4SvRlTxTodTDWTyrx+PCn/C0KyuANuOCxEgskcTH8cTR4WESkgqs9VaLOOZ4rRbrGBkiGiJ5HxiE1kPk1TVQEPYUJquNe70zp4DP6XOZWQwwHVziGZ5eL6zl/XpJwuSgul/+1VpWAGJ3VkBlUtaNqbV1CRxsKZ978Q1e+kUmu7MSptpF+ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* generate CSV output for every sheet */ | |
function to_csv(workbook) { | |
var result = []; | |
workbook.SheetNames.forEach(function(sheetName) { | |
var csv = XLSX.utils.make_csv(workbook.Sheets[sheetName]); | |
if(csv.length > 0){ | |
result.push("SHEET: " + sheetName); | |
result.push(""); | |
result.push(csv); | |
} |