jQWidgets Forums
jQuery UI Widgets › Forums › Getting Started › exportdata
Tagged: Exportdata, grid, jqxgrid
This topic contains 3 replies, has 2 voices, and was last updated by sintetik 7 years, 12 months ago.
-
Authorexportdata Posts
-
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
Hello sintetik,
The fifth parameter is used for exporting hidden columns, in your case, it is ‘true’, it should be working.
Best Regards,
StanislavjQWidgets Team
http://www.jqwidgets.com/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 !
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″ -
AuthorPosts
You must be logged in to reply to this topic.