Export to Excel with Select Filters - Shows two Header Rows

Suite and Optimus Suite 5
#1

When exporting from grid to Excel, the header includes the normal header values in the first row, but the second row includes the filters fields (and all of their possible values) as part of the header as well.

Is there any way to suppress the second row of the header?

#2

Hi,
if you have plans to export just one grid by export script you might customize it to enable printing just first grid row. To implement it modify gridExcelGenerator.php like here:

	private function headerParse($header) {

		..........
		$this->summaryWidth = $summaryWidth;
		$this->columns = array_slice($this->columns, 0, 1);
	}

But don’t forget that this customization will work for all grids which you’re going to export by this script.

#3

I added that line to our gridExcelGenerator.php file and we still receive the second row of the header in the excel sheet.

#4

Update: I added the line to the wrong file. The code works great when added to the file that is actually in use.