We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Integrate Drop Down List in Spread Sheet

Thread ID:

Created:

Updated:

Platform:

Replies:

128235 Jan 10,2017 09:15 AM UTC Jan 11,2017 07:29 AM UTC JavaScript 1
loading
Tags: ejSpreadSheet
kuldeep
Asked On January 10, 2017 09:15 AM UTC

Hello,

My Requirement are using Sync fusion Spread Sheet integrate drop down list on first row ,if possible then suggest please.

Thanks

Silambarasan I [Syncfusion]
Replied On January 11, 2017 07:29 AM UTC

Hi Kuldeep, 
 
Thank you for using Syncfusion products. 
 
We have checked your requirement “To integrate DropDownList on First Row in Spreadsheet” and it has been achieved by using ‘cellTypes’ API or ‘addCellTypes()’ client-side methods.  Please refer the following code example. 
 
 
<div id="Spreadsheet"></div> 
 
var dataSource = [...]; 
$(function () { 
    $("#Spreadsheet").ejSpreadsheet({ 
        sheets: [{ 
            rangeSettings: [{ dataSource: dataSource, startCell: "A3" }], 
            cellTypes: [                         
                { 'range': 'A1', 'settings': { 'type': ej.Spreadsheet.CustomCellType.DropDownList, 'dataSourceRange': 'A3:A11' } } 
            ] 
        }], 
        loadComplete: "onLoadComplete" 
    }); 
}); 
 
function onLoadComplete(args) { 
    if (!this.isImport) { 
        //... 
 
        //using Client-side method to add dropdownlist 
        //this.XLCellType.addCellTypes("A1", { 'type': ej.Spreadsheet.CustomCellType.DropDownList, 'dataSourceRange': 'A3:A11' }); 
    } 
} 
 
 
 
For your convenience, we have prepared a sample to demonstrate this in JS Playground.  Please refer the below sample link,  
 
For more information, please refer the below online help documentation & sample links about cell types data representation in Spreadsheet. 
 
 
Regards, 
Silambarasan I 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;