Problem Export Excel

9 posts, 0 answers
  1. Supaluk Jarungpornswat
    Supaluk Jarungpornswat avatar
    7 posts
    Member since:
    Jul 2018

    Posted 02 Aug 2018 Link to this post

    $("#grid").kendoGrid({ toolbar: ["excel"], excel: { fileName: "Kendo UI Grid Export.xlsx", proxyURL: "https://demos.telerik.com/kendo-ui/service/export", filterable: true}, dataSource: { type: "odata", transport: { read: "https://demos.telerik.com/kendo-ui/service/Northwind.svc/Products"}, schema:{ model: { fields: {UnitsInStock: { type: "number" },ProductName: { type: "string" },UnitPrice: { type: "number" },UnitsOnOrder: { type: "number" },UnitsInStock: { type: "number" }}}}, pageSize: 7, group: { field: "UnitsInStock", aggregates: [{ field: "ProductName", aggregate: "count" },{ field: "UnitPrice", aggregate: "sum"},{ field: "UnitsOnOrder", aggregate: "average" },{ field: "UnitsInStock", aggregate: "count" }]}, aggregate: [{ field: "ProductName", aggregate: "count" },{ field: "UnitPrice", aggregate: "sum" },{ field: "UnitsOnOrder", aggregate: "average" },{ field: "UnitsInStock", aggregate: "min" },{ field: "UnitsInStock", aggregate: "max" }]}, sortable: true, pageable: true, groupable: true, filterable: true, columnMenu: true, reorderable: true, resizable: true, columns: [{ field: "ProductName", title: "Product Name", aggregates: ["count"], footerTemplate: "Total Count: #=count#", groupFooterTemplate: "Count: #=count#" },{ field: "UnitPrice", title: "Unit Price", aggregates: ["sum"] },{ field: "UnitsOnOrder", title: "Units On Order", aggregates: ["average"], footerTemplate: "Average: #=average#", groupFooterTemplate: "Average: #=average#" },{ field: "UnitsInStock", title: "Units In Stock", aggregates: ["min", "max", "count"], footerTemplate: "Min: #= min # Max: #= max #", groupHeaderTemplate: "Units In Stock: #= value # (Count: #= count#)" }]});

    function search() {
                $('#grid').data('kendoGrid').dataSource.read({
                    "CusCode": $("#CusCode").val(), "FromDate": $("#FromDate").val(), "ToDate": $("#ToDate").val()
                                        , "IsAllEquity": $("[name=rbStock]:checked").val(), "EquitySymbol": $("#EquitySymbol").val()
                                        , "IsAllDerivative": $("[name=rbDerivative]:checked").val(), "Instrument": $("#Instrument").val()
                });
                $("#grid").data("kendoGrid").refresh();
            }

     

    Export Excel But data was lost when I called search() ( Use initialize parameter not in search() )

     

  2. Konstantin Dikov
    Admin
    Konstantin Dikov avatar
    2466 posts

    Posted 06 Aug 2018 Link to this post

    Hello,

    If you want to filter the data before exporting to Excel, you could use the "filter" method of the DataSource instead:
    Additionally, you could see if the service return the data and populates the Grid correctly when you are passing additional data to the "read" function. Note that if you are using DatePicker widgets you will have to use their "value" method to get the selected Date object:
    Hope this helps.


    Regards,
    Konstantin Dikov
    Progress Telerik
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
  3. Supaluk Jarungpornswat
    Supaluk Jarungpornswat avatar
    7 posts
    Member since:
    Jul 2018

    Posted 14 Aug 2018 Link to this post

    Dear Konstantin Dikov,

    I want retrieve from server but the fitter can use from the client. It doesn't refresh my data. 

    Thank you.

  4. Supaluk Jarungpornswat
    Supaluk Jarungpornswat avatar
    7 posts
    Member since:
    Jul 2018

    Posted 14 Aug 2018 in reply to Supaluk Jarungpornswat Link to this post

    I can send the fitter to server already but can't use same as data.

    data: 

    "SymbolID": "", "MktID": "", "CustCode": $("#CustomerCode").val(), "Userlevel": "", "Userleveldef": "", "QType": ""

    fitter:

     "SymbolID": "", "MktID": "", "CustCode": $("#CustomerCode").val(), "Userlevel": "", "Userleveldef": "", "QType": "" , fitter: [Object Object]

  5. Angel Petrov
    Admin
    Angel Petrov avatar
    1153 posts

    Posted 15 Aug 2018 Link to this post

    Hi,

    I am experiencing difficulties understanding the problem on hand. Can you please share with us the latest code and explain in detail the requirements? That would greatly facilitate us in assisting you further.

    Regards,
    Angel Petrov
    Progress Telerik
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
  6. Supaluk Jarungpornswat
    Supaluk Jarungpornswat avatar
    7 posts
    Member since:
    Jul 2018

    Posted 15 Aug 2018 in reply to Angel Petrov Link to this post

    Can I use the first topic post to export excel because I can't use like this you answer?

    function search() {
                $('#grid').data('kendoGrid').dataSource.read({
                    "CusCode": $("#CusCode").val(), "FromDate": $("#FromDate").val(), "ToDate": $("#ToDate").val()
                                        , "IsAllEquity": $("[name=rbStock]:checked").val(), "EquitySymbol": $("#EquitySymbol").val()
                                        , "IsAllDerivative": $("[name=rbDerivative]:checked").val(), "Instrument": $("#Instrument").val()
                });
                $("#grid").data("kendoGrid").refresh();
            }

  7. Angel Petrov
    Admin
    Angel Petrov avatar
    1153 posts

    Posted 17 Aug 2018 Link to this post

    Hello,

    I am still experiencing difficulties understanding the problem. Can you please elaborate in detail on what happens when the grid data is exported? What is the exact requirement?

    Regards,
    Angel Petrov
    Progress Telerik
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
  8. Supaluk Jarungpornswat
    Supaluk Jarungpornswat avatar
    7 posts
    Member since:
    Jul 2018

    Posted 19 Aug 2018 in reply to Angel Petrov Link to this post

    When call the searchCus()  I can't export excel.

    Can you have export excel by document get by ID (DOM) grid ?

     

      $("#grid").kendoGrid({
                    dataSource: {
                        type: "odata",
                        transport: {
                            read: {
                                // the remote service url
                                url: "wsCRM.asmx/crm_selIPOTrans", // GetBBGToADVTransactionsData is our web method

                                contentType: "application/json; charset=UTF-8",

                                type: "POST",

                                // JSONP is required for cross-domain AJAX
                                dataType: "json",

                                // additional parameters sent to the remote service
                                data:  /*"{Field:'',Text:'',page:1,rows:50000}"*/
                                    { "SymbolID": "", "MktID": "", "CustCode": $("#CustomerCode").val(), "Userlevel": "", "Userleveldef": "", "QType": "" }
                            }
                        }, group: [
                            // group by "category" and then by "subcategory"
                            /*{
                                field: "GrpMkt"
                            },
                            { field: "GrpCust" },*/
                        ],
                        groupable: true,
                        serverPaging: true,
                        serverFiltering: true,
                        pageSize: 50,
                        schema: {
                            data: function (response) {
                                var data = JSON.parse(response.d);
                                return data["rows"];
                            },
                            total: function (response) {
                                var data = JSON.parse(response.d);
                                return data["total"];
                            }
                        }
                    },
                    toolbar: ["excel", "pdf"],
                    excel: {
                        fileName: "Kendo UI Grid Export.xlsx",
                        proxyURL: "https://demos.telerik.com/kendo-ui/service/export",
                        filterable: true
                    },
                    pdf: {
                        allPages: true,
                        avoidLinks: true,
                        paperSize: "A4",
                        margin: { top: "2cm", left: "1cm", right: "1cm", bottom: "1cm" },
                        landscape: true,
                        repeatHeaders: true,
                        template: $("#page-template").html(),
                        scale: 0.8
                    },
                    height: 550,
                    groupable: true,
                    sortable: true,
                    reorderable: true,
                    resizable: false,
                    pageable: {
                        refresh: true,
                        //pageSizes: true,
                        buttonCount: 5,
                        pageSizes: [10, 20, 30, 40, 50]
                    },
                    columns: [{
                       // template: "#:dateSqlTodate(data.FormatResDate)#",
                        field: "FormatResDate",
                        title: "SubscriptionDate",
                        width: 100
                    }, {
                        field: "Symbol",
                        title: "Symbol",
                        //attributes: { style: "text-align:center;" },
                        width: 100
                    }, {
                        field: "QuotaName",
                        title: "Allocated by",
                        width: 240
                    }, {
                        field: "ConfirmUnit",
                        title: "Share",
                        format: "{0:n0}",
                        attributes: { style: "text-align:right;" },
                        width: 100
                    }, {
                        field: "Price",
                        title: "IPO price",
                        format: "{0:n2}",
                        attributes: { style: "text-align:right;" },
                        width: 100
                    }, {
                        field: "ConfirmAmt",
                        title: "Net Amount(THB)",
                        format: "{0:n2}",
                        attributes: { style: "text-align:right;" },
                        width: 150
                    }]
                });
                $("#FromDate,#ToDate").kendoDatePicker();

            });

       function searchCus() {
                //$('#grid').data('kendoGrid').dataSource.read({ "SymbolID": "", "MktID": "", "CustCode": $("#CustomerCode").val(), "Userlevel": "", "Userleveldef": "", "QType": "" });

    }

     

     

     

  9. Supaluk Jarungpornswat
    Supaluk Jarungpornswat avatar
    7 posts
    Member since:
    Jul 2018

    Posted 21 Aug 2018 Link to this post

    I have solved my problem finish.
Back to Top