Custom Datasource Field Name

[Unknown]

Hello,

I have a spreadsheet with sheet bind from a datasource with the option 'FieldAsColumnHeader' set as true. The problem is that it always get the field name as it is in the datasource (ex.: I have a field called "ItemCode" and I would like it to show in the header as "Item Code"). Is there a way to customize the fields name that are shown in the header? It would help in the process of localization too.

Att,

[Sangeetha Priya Murugan]

  

Hi Erik, 

 

Thank you for using Syncfusion products.  

 

We have checked your requirement and your requirement can be achieved using “columns” property in sheets object. Please refer the below code example to achieve your requirement.  

 

[JS]  

<script>   

    var dataSource = [   

            { "ItemName": "Casual Shoes", Quantity: 10, Price: "20", Amount: "200", Discount: "1", Profit: "10" },   

            //...   

    ];   

    $(function () {   

        $("#Spreadsheet").ejSpreadsheet({   

            columnWidth: 100,   

            sheets: [{   

                dataSource: dataSource, fieldAsColumnHeader: true,   

                columns: [   

                    { field: 'A', text: Item Name },   

                    { field: 'C', text: 'Header2' },   

                    { field: 'E', text: 'Header3' },   

                ]   

            }],   

        });   

    });   

</script>   

For your convenience, we have prepared the sample based on your requirement. Please find the link below. 

 

JSPlayground Link: http://jsplayground.syncfusion.com/54j4fu4w  

 

Regards, 

Sangeetha M 

[Unknown]

Hi Sangeetha,

Thank you for the response. I did as in the example and it worked!

Att,

[Vinoth Kumar Sundara Moorthy]

Hi Erik, 

 

We are happy to hear that your reported issue has been resolved. Please feel free to contact us if you need any further assistance on Syncfusion components. 

 

Regards, 

Vinoth Kumar S