export – grid -error

[rajesh guptaParticipant]

I am trying to do the export of grid to excel.
I am using the following code to the export

 excelBtnOnClick() {
    console.log('excelBtnOnClick()');
    this.myGrid.exportdata('xls', 'jqxGrid');
  }

I got the following error. what is is ‘getexportcolumntype’ means in the below error.

ReportEngineComponent.html:70 ERROR TypeError: Cannot read property 'indexOf' of null
    at c.(:8888/reportMgr/anonymous function)._getexportcolumntype (http://localhost:8888/gainangular/app-image-upload-image-upload-module~app-…s-module~app-my-data-my-data-module~app-predef-cust~3c0da948.js:33931:7668)
    at c.<anonymous> (jqxgrid.export.js:8)
    at Function.each (jqxcore.js:8)
    at c.(:8888/reportMgr/anonymous function).exportdata (http://localhost:8888/gainangular/app-image-upload-image-upload-module~app-…s-module~app-my-data-my-data-module~app-predef-cust~3c0da948.js:33931:1551)

[rajesh guptaParticipant]

My template is as follows

    <jqxGrid #myGrid [width]="gridWidth" [autoheight]="true" style="margin-top:10px" [source]="gridDataSource" [columns]="gridColumns"
      [showaggregates]="true" [showstatusbar]="true" (click)="onGridClick()" [class.cursor-pointer]="showCursorPointer" [enablehover]="false"
      [sortable]="true" [filterable]="true" [autorowheight]="true" [autoheight]="true">
    </jqxGrid>

[rajesh guptaParticipant]

What is the cause of the error ‘_getexportcolumntype’.

Your sample works good
https://jqwidgets.github.io/angular-grid/#/

[MartinParticipant]

Hello rajesh gupta,

How are you creating the columns?
Could you provide your code for gridColumns?

Best Regards,
Martin

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

[rajesh guptaParticipant]

It is solved. In the source, the datafields ‘type’ was not set for all fields.

[Author]

Posts