Column binding/ordering not working

2 posts, 0 answers
  1. Kevin
    Kevin avatar
    2 posts
    Member since:
    Aug 2016

    Posted 02 Sep 2016 Link to this post

    My spreadsheet loads fine, but the order in which it loads the columns is odd based on the datasource I'm pulling from. I'd like to specify the order they're in, as well as the name of said columns.


    I have the following code:

                                columns: 17,
                                columnWidth: 100,
                                rows: 100,
                                toolbar: true,
                                sheetsbar: true,
                                excel: {                
                                    // Required to enable Excel Export in some browsers
                                    proxyURL: "//"
                                sheets: [{
                                    name: "Summary",
                                    dataSource: summaryDS
                                    name: "Customers",
                                    dataSource: customersDS,
                                        columns: [
                                                field: "nummer",
                                                title: "Number"
                                                field: "ans",
                                                title: "Customer"
                                    name: "Prospects",
                                    dataSource: prospectsDS
                                    name: "Leads",
                                    dataSource: leadsDS



  2. Boyan Dimitrov
    Boyan Dimitrov avatar
    2062 posts

    Posted 06 Sep 2016 Link to this post

    Hello Kevin,

    I am afraid that such functionality can not be achieved using the columns property of the sheet. My suggestion is to use the schema.parse of the DataSource in order to modify the server response and leave only the columns you want to display. 

    Boyan Dimitrov
    Telerik by Progress
    Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.
Back to Top