-
Notifications
You must be signed in to change notification settings - Fork 0
/
core.ts
81 lines (74 loc) · 1.98 KB
/
core.ts
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
export function tableHTMLToExcelXML(tableHTML: string) {
return /* html */ `
<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>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>name</x:Name>
<x:WorksheetOptions>
<x:DisplayGridlines/>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
</x:ExcelWorkbook>
</xml>
<![endif]-->
</head>
<body>
${tableHTML}
</body>
</html>
`.trim()
}
export function excelXMLToDataUrl(xml: string): string {
return `data:${mimeType},${xml}`
}
export function downloadDataUrlAsFile(dataUrl: string, filename: string) {
let a = document.createElement('a')
document.body.appendChild(a)
a.href = dataUrl
a.download = filename
a.click()
a.remove()
}
let mimeType = 'application/vnd.ms-excel'
let defaultFilename = 'data.xls'
export function downloadTableAsExcel(
table: HTMLTableElement,
filename: string = defaultFilename,
) {
let xml = tableHTMLToExcelXML(table.outerHTML)
let dataUrl = excelXMLToDataUrl(xml)
downloadDataUrlAsFile(dataUrl, filename)
}
// TODO handle unicode
export function textToBlob(text: string, mimeType: string): Blob {
let n = text.length
let buffer = new Uint8Array(n)
for (let i = 0; i < n; i++) {
buffer[i] = text.charCodeAt(i)
}
return new Blob([buffer], { type: mimeType })
}
export function excelXMLToFile(
xml: string,
filename: string = defaultFilename,
options?: Pick<FilePropertyBag, 'lastModified'>,
) {
let blob = textToBlob(xml, mimeType)
return new File([blob], filename, {
type: blob.type,
lastModified: options?.lastModified,
})
}
export function tableToFile(
table: HTMLTableElement,
filename: string = defaultFilename,
options?: Pick<FilePropertyBag, 'lastModified'>,
): File {
let xml = tableHTMLToExcelXML(table.outerHTML)
return excelXMLToFile(xml, filename, options)
}