jQWidgets Forums

jQuery UI Widgets › Forums › Grid › Exporting date to excel

Tagged: , ,

This topic contains 2 replies, has 2 voices, and was last updated by  userdch 12 years, 3 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Exporting date to excel Posts
  • February 12, 2013 at 6:13 pm Exporting date to excel #15090

    userdch
    Participant

    date shows on screen as mm/dd/yyyy.
    the column specification is shown below:
    { text: ‘Reset’, dataField: ‘colResetDt’, width: 80, filterable: false, cellsformat: ‘D’, type: ‘date’},

    when i export to excel
    – date shows up as ‘Thursday, January 31, 2013’ instead of 01/31/2013.
    – numbers are stored as text.

    Thanks in advance.

    February 12, 2013 at 6:19 pm Exporting date to excel #15091

    Peter Stoev
    Keymaster

    Hi userdch,

    There is no “type” field in the column’s definition. The “type” should be specified in the datafield’s definition in the source object.

    Best Regards,
    Peter Stoev

    jQWidgets Team
    http://www.jqwidgets.com

    February 12, 2013 at 6:23 pm Exporting date to excel #15092

    userdch
    Participant

    hi Peter
    thanks for the quick reply.
    it turns out that cellsformat should be ‘d’ instead of D and type is not required.
    export works fine.

    thanks.

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.