Bind Json data to Spreadsheet via Ajax call in popup

Question

Hi Team,I am using syncfusion spreadsheet in my project. I am facing 2 problems in binding data to spreadsheet1. When user clicks on first tab blank spreadsheet should load with blank cells. But in my case only blank spreadsheet is loading without cells. Cells are appearing on postback.2. I need help in Calling ajax method & binding that json value to spreadsheet.Below is my ajax methodfunction GetBulkUploadData() {    debugger;
    var jasonVal = "";
    var oppPK = "1";
    $.ajax({
        type: "POST",
        url: "../../Services/AutoComplete.svc/GetBulkData",
        data: '{"OpportunityPK":"' + oppPK + '"}',
        contentType: "application/json; charset=utf-8",
        DataType: "json",
        processdata: true,
        success: function (msg) {
            debugger;
            var sampleJSON = msg.d;
            if (msg.d == "") {
                sampleJSON = "[]";
            }
            jasonVal = sampleJSON;
        },
        error: ServiceFailed
    });
    return jasonVal;
 
}

Shanmugaraja K · Answer

Hi Akshay, 
 
Thank you for contacting Syncfusion support. 
 
Query 1: When user clicks on first tab blank spreadsheet should load with blank cells. But in my case only blank spreadsheet is loading without cells. Cells are appearing on postback. 
 
We have checked your query and we cannot able to reproduce your reported issue in our end. Before we proceed further on this issue, please provide us below information. 
 
1.       How you are binding data in Spreadsheet and explain about your exact scenario? 
2.       Whether you are using ejDataManager to load data into the Spreadsheet. 
 
Meanwhile, you can achieve the scenario by loading data at button click using “updateRange()” method and the same can be downloaded from below link. 
 
Sample Link: http://www.syncfusion.com/downloads/support/forum/139020/ze/SpreadsheetSample1653245499 
 
Query 2: I need help in Calling ajax method & binding that json value to spreadsheet. 
 
We have already created a Knowledge Base about to save and retrieve the Spreadsheet data as JSON in the database using $.ajax method. Kindly follow the below Knowledge Base to achieve your requirement. 
 
https://www.syncfusion.com/kb/7675/how-to-save-and-retrieve-the-spreadsheet-data-as-json-in-database 
 
Regards, 
Shanmugaraja K