Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
2480
Is there a way to prevent the arrows in the header cells, which are for filtering/sorting, when doing the export?
posted

I'm using $.ig.GridExcelExporter.exportGrid. Is there a way to prevent the arrows in the header cells, which are for filtering/sorting, when doing the export? These appear even though I don't have filtering active in the grid.

  • 720
    Verified Answer
    Offline posted

    Hello,

    Thank you for posting in our community.

    The table's filter button can be disabled during the exportEnding event by calling the isFilterUIVisible function on a given table:

    $('#exportButton').on('click', function () {
    	var gridExcelExporter = new $.ig.GridExcelExporter();
    	var $grid = $('#grid');
    	gridExcelExporter.exportGrid($grid, {
    		fileName: "igGrid",
    		gridStyling: "applied"
    	}, {
    		exportStarting: function (e, args) {
    			showExportingIndicator(args.grid, exportingIndicator);
    		},
    		exportEnding: function (sender, args) {
    			args.workbook.worksheets(0).tables(0).isFilterUIVisible(false);
    		},      
    		success: function () {
    			hideExportingIndicator(exportingIndicator);
    		},
    	});
    });

    Please let me know if you need any further assistance with this matter.