Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
185
igx grid date column exporting to excel as text instead date
posted

Hi,

I have date column on igx grid with date filter with column data as (6/30/2021, 3/16/2020....).

While exporting to excel this date column is exporting as text in excel (shows text filter in excel column).

Please advise.

Parents
No Data
Reply
  • 740
    Offline posted

    Hi,

    Thank you for contacting Infragistics Community!

    I believe you will find the Export to Excel topic in our official documentation very helpful. As you can observe within the first example of this topic you can export the igxGrid to Excel. Once you do this, you will find that the values in the OrderDate column are of type Date and that the correct date filtering strategy is being used. Having this in mind, I assume two possible reasons for the described behavior:

    • the ‘date’ dataType property is not provided to the igxColumn
    • an older version of IgniteUI for Angular package is used

    In case that you are using IgniteUI for Angular 12.x, have the dataType property set to 'date' and the issue still persists I suggest modifying the following sample so that it reproduces the described behavior and send it back to me. This will give me the opportunity to debug it on my side and to provide you with solution as soon as possible.

    Looking forward to hearing from you.

    Best Regards,
    Martin Evtimov
    Associate Software Developer
    Infragistics, Inc.

Children