xxleyi
/ tableToSql.js
Created
April 18, 2021 13:38
— forked from rnaffer/tableToSql.js
Export table to excel with pure javascript
This file contains hidden or 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
| var tableToExcel = (function() { | |
| var uri = 'data:application/vnd.ms-excel;base64,' | |
| , template = '<html 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><!--[if gte mso 9]><?xml version="1.0" encoding="UTF-8" standalone="yes"?><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>{table}</table></body></html>' | |
| , base64 = function(s) { return window.btoa(unescape(encodeURIComponent(s))) } | |
| , format = function(s, c) { return s.replace(/{(\w+)}/g, function(m, p) { return c[p]; }) }; | |
| return function(table, name) { | |
| if (!table.nodeType) table = document.getElementById(table); | |
| var ctx = { worksheet: name || 'Worksheet', table: table.innerHTML }; | |
| window.location.href = uri + base64(format(template, ctx)); | |
| }; |
xxleyi
/ cheaphints.lua
Last active
December 26, 2020 14:34
cheaphints: lightweight hints in hammerspoon
This file contains hidden or 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
| --[[ | |
| installation: put this file in ~/.hammerspoon and add this line to your init.lua: | |
| local cheaphints = require "cheaphints" | |
| usage: by default, just hit F20. you'll see a list of keys and associated | |
| windows. if you hit escape, you'll exit hint mode. if you hit one of the keys in | |
| the list, that window gets focused. the hint mode will exit automatically after | |
| a while. | |
| ]] |