Date and Time export with excelHtml5

Date and Time export with excelHtml5

wittichwittich Posts: 3Questions: 1Answers: 0
edited April 2018 in Free community support

Hi,

is there any way to have a prober date and time export for Excel using excleHtml5?

I have try it with ISO 8601 2018-04-25 ([yyyy-MM-dd]) without success. Same with Time values eg. 59:15 ([hh:mm]) get's imported as string.

Regards
Valentin

ps: @allan I just saw in the source comments that you already had the idea to implement an API for that, any further plans on that matter?

This question has an accepted answers - jump to answer

Answers

  • allanallan Posts: 61,726Questions: 1Answers: 10,109 Site admin
    Answer ✓

    Currently no - sorry. When that does progress forward it will be in the source you linked to.

    Allan

  • wittichwittich Posts: 3Questions: 1Answers: 0
    edited June 2018

    Hi @allan, I just run over the problem again and coded a modification for buttons.html5.js. Should I fork my version into git?

    I added additional Styles for

    • [hh:mm:ss],
    • [hh:mm],
    • [yyyy-MM-dd] and
    • [dd.MM.yyyy]

    as well as the automatic pattern matches.

    Regards Valentin

    PS: for the dates I used Moments.JS (s. example), so it would only works in buttons.html5.js if it is loaded as well.

  • CamillCamill Posts: 1Questions: 0Answers: 0

    Hi, are there any news with date output formatting? Would be great, I have real problems with that atm.

This discussion has been closed.