jQWidgets Forums

This topic contains 3 replies, has 2 voices, and was last updated by  sintetik 7 years, 12 months ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    exportdata Posts
  • exportdata #93231

    sintetik
    Participant

    I´m using this method, but with no results:

    cDadosArquivo=$(“#grdInvent”).jqxGrid(“exportdata”, “csv” , “jqxGrid”, True , null , True )

    I want to consider to export hidden columns too

    Thanks in advance

    exportdata #93255

    Stanislav
    Participant

    Hello sintetik,

    The fifth parameter is used for exporting hidden columns, in your case, it is ‘true’, it should be working.

    Best Regards,
    Stanislav

    jQWidgets Team
    http://www.jqwidgets.com/

    exportdata #93259

    sintetik
    Participant

    ok, but still not givin me any result, blank, or hang the app
    I´m doing this:

    JavaScript
    var source =
    {
    localdata: dataConfPed,
    datatype: “array”,
    datafields:
    [{ name: ‘pedido’ , type: ‘string’ },
    { name: ‘codigo’ , type: ‘string’ },
    { name: ‘quantidade’ , type: ‘number’ },
    { name: ‘qtdeoficial’, type: ‘number’ },
    { name: ‘divergencia’, type: ‘number’ },
    { name: ‘data’ , type: ‘string’ } ]
    };
    End JavaScript
    debugger
    ‘source = {localdata: dataConfPed, datatype: “array”};
    dataAdapter = new $.jqx.dataAdapter(source);
    NSB.jqxSettings[“grdExporta”].source = dataAdapter
    NSB.jqxSettings[“grdExporta”].columns = [ _
    { text: “Pedido” , dataField: “pedido” , width: 80 , columntype: “textbox” ,cellsalign: “left” }, _
    { text: “Código” , dataField: “codigo” , width: 180 , columntype: “textbox” ,cellsalign: “left” }, _
    { text: “Quantidade” , dataField: “quantidade” , width: 90 , columntype: “numberinput” ,cellsformat: “F2”,cellsalign: “right”}, _
    { text: “Qtde. Pedido” , dataField: “qtdeoficial”, width: 90 , columntype: “numberinput” ,cellsformat: “F2”,cellsalign: “right” }, _
    { text: “Divergência” , dataField: “divergencia”, width: 90 , columntype: “numberinput” ,cellsformat: “F2”,cellsalign: “right” }, _
    { text: “Data” , dataField: “data” , width: 80 , columntype: “textbox”,cellsalign: “right”} _
    ]
    $(“#grdExporta”).jqxGrid(NSB.jqxSettings[“grdExporta”]);

    cDadosArquivo=$(“#grdExporta”).jqxGrid(“exportdata” , “csv” )

    and nothing is happenning ! It´s export some kind of raw data !

    exportdata #93261

    sintetik
    Participant

    this is the format of exported data, I´ve chose CSV

    “Pedido”,”Código”,”Quantidade”,”Qtde. Pedido”,”Divergência”,”Data”
    “0000002”,”012345678901″,”0.00″,”1.00″,”0.00″,”02/05/17″
    “0000002”,”012345678902″,”0.00″,”2.00″,”0.00″,”02/05/17″
    “0000002”,”012345678903″,”0.00″,”3.00″,”0.00″,”02/05/17″
    “0000002”,”012345678904″,”0.00″,”4.00″,”0.00″,”02/05/17″
    “0000002”,”012345678905″,”0.00″,”5.00″,”0.00″,”02/05/17″
    “0000002”,”012345678906″,”0.00″,”6.00″,”0.00″,”02/05/17″
    “0000002”,”012345678907″,”0.00″,”7.00″,”0.00″,”02/05/17″
    “0000002”,”012345678908″,”0.00″,”8.00″,”0.00″,”02/05/17″

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.