Support for cell types

[zheffie]

It would be great is cell types were supported. Eg. Number, text, date, ...
Currently everything is a string.

[pofider]

The problem is that in html everything is just a string.

• we can try to parse the cell values to check if it is a number or perhaps an ISO date format
• or we can add support for some attributes specifying data type like <td data-type='number'>1.1</td>

suggestions?

[zheffie]

Defining a custom html attribute is probably the way to go.

eg
`100``

With below format codes (from the openXML standard)

ID  Format Code
0   General
1   0
2   0.00
3   #,##0
4   #,##0.00
9   0%
10  0.00%
11  0.00E+00
12  # ?/?
13  # ??/??
14  mm-dd-yy
15  d-mmm-yy
16  d-mmm
17  mmm-yy
18  h:mm AM/PM
19  h:mm:ss AM/PM
20  h:mm
21  h:mm:ss
22  m/d/yy h:mm
37  #,##0 ;(#,##0)
38  #,##0 ;[Red](#,##0)
39  #,##0.00;(#,##0.00)
40  #,##0.00;[Red](#,##0.00)
45  mm:ss
46  [h]:mm:ss
47  mmss.0
48  ##0.0E+0
49  @

[zheffie]

Problems seems to be that msexcel-builder does not really support other formats then string.
Perhaps you can incorporate following patch:
chuanyi/msexcel-builder#11

[bjrmatos]

another options to support cell types is to use: https://github.com/d-band/better-xlsx or inspect how better-xlsx does the cell type support and extend our fork

[bjrmatos]

this is supported in 1.1.0, docs are coming..