-
Notifications
You must be signed in to change notification settings - Fork 30
Expand file tree
/
Copy pathexample.html
More file actions
57 lines (47 loc) · 1.97 KB
/
example.html
File metadata and controls
57 lines (47 loc) · 1.97 KB
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
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<table _excel-name="My sheet">
<tr>
<!-- Apply json-encoded styles to cells -->
<th _excel-styles='{"font-size":16, "font-color":"#FF0000", "font-style":"bold"}'>An Excel worksheet</th>
</tr>
<tr>
<!-- Empty row -->
</tr>
<!-- Apply json-encoded styles to rows -->
<tr _excel-styles='{"fill-color":"#4F4F4F"}'>
<!-- You can set links, too -->
<th _excel-styles='{"font-color":"#FFFFFF", "hyperlink": "http://www.google.com"}'>Column A</th>
<th _excel-styles='{"font-color":"#FFFFFF"}'>Column B</th>
</tr>
<tr>
<td>Left align</td>
<td _excel-styles='{"text-align": "right"}'>Right align</td>
</tr>
<tr>
<!-- For reliable results, set the cell format explicitly for non-text values
<-- See https://github.com/aVadim483/fast-excel-writer/blob/master/docs/03-writing.md#cell-formats -->
<td _excel-styles='{"format": "@integer"}'>5</td>
<td _excel-styles='{"format": "@integer"}'>6</td>
<td _excel-styles='{"format": "@text"}'>0022</td>
</tr>
<tr>
<!-- Formulas work, too -->
<td>=1+1</td>
<td>=A5+B5</td>
<td>=SUM(A5:B5)</td>
</tr>
<!-- Set row dimensions-->
<tr _excel-styles='{"height": 50, "text-align": "center"}'>
<!-- Number formats! -->
<td _excel-styles='{"format": "@money"}'>25</td>
<td _excel-styles='{"format": "#’##0.00"}'>1520.20</td>
</tr>
<tr>
<!-- Merge cells -->
<td colspan="2" rowspan="2" _excel-styles='{"text-align": "center", "vertical-align": "center"}'>Merge cells</td>
<!-- Set column dimensions -->
<td _excel-styles='{"width": 100, "height": 50}'>No need to fill all cells.</td>
<td _excel-styles='{"width": "auto"}'>And no need to care about how many cells there are in each row.</td>
<td>Ich bin ein Ümläøut.</td>
</tr>
</table>