Export spread views data

Posted by: ralvee on 8 September 2017, 9:18 am EST

  • Posted 8 September 2017, 9:18 am EST

    How do I export spread views data in MS excecl or csv format?

    I am using dataview

    var dataView = new GC.Spread.Views.DataView(document.getElementById('grid1'), data, columns,
    new GC.Spread.Views.Plugins.GridLayout({
    allowGrouping: true,
    defaultGroupingInfo: {
    footer: {
    visible: false
    }
    }
    }));
  • Marked as Answer

    Replied 8 September 2017, 9:18 am EST

    Hello Ralvee,

    Spread.Views don't support export to Excel/ CSV directly. For exporting to CSV you need write that function by yourself.

    You can refer to the following question, choose an answer which meets your requirement, Assume dataView is the instance of the DataView object, you can get the underlying data source array by calling:-

    dataView.data.sourceCollection


    Here is the link for the same:-
    http://stackoverflow.com/questions/14964035/how-to-export-javascript-array-info-to-csv-on-client-side

    Hope it helps.

    Thanks,
    Reeva
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels