Skip to Content
0
May 08, 2018 at 09:08 AM

I am not able to extract more than 100 row thorough exporting .csv

946 Views

Hi Experts,

I have set the sizeLimit of Odata before exporting the data from entity set.But still I am getting 100 rows data one.

This is the below code:

var model=this.getView().getModel().setSizeLimit(this.oTable.getBinding("items").iLength);

var Omodel=this.getOwnerComponent().getModel();

var oExport = new sap.ui.core.util.Export({ exportType : new sap.ui.core.util.ExportTypeCSV({ separatorChar : ";" }),

models :model,

rows : {path : '/AddressSet'},

columns : [{ name : "Vesrion", template : { content : "{Version}" }}, { name : "ProximusPointId", template : { content : "{ProximusPointId}"}}, { name : "Lang", template : { content : "{Lang}"}}, { name : "Name", template : { content : "{Name}" }}, { name : "CountryKey", template : { content : "{CountryKey}" }}, { name : "Street", template : { content : "{Street}" }}, { name : "HouseNo", template : { content : "{HouseNo}" }}, { name : "PostalCode", template : { content : "{PostalCode}" }}, { name : "City", template : { content : "{City}" }} ] }); oExport.saveFile().catch(function(oError) { MessageBox.error("Error when downloading data. Browser might not be supported!\n\n" + oError); }).then(function() { oExport.destroy(); });

Kindly please help me.

Thanks

Peeyush Ranjan