Great Will,

Thanks, much prefer to NOT change the source code.

G.

Will,

It work now but the customer wants to freeze the first two rows when outputting to excel. I could not find anyway to do it via the parameters, so I did a temporary fix for it by modifying jqGridExport.php with the line:

$objWorksheet = $objPHPExcel->getActiveSheet()->freezePane(‘B3’); //gws 20180808

following:

$objWorksheet = $objPHPExcel->getActiveSheet();

Is there a way to do it via the export parameters? Or will that be available in a future release?

Thanks.

Gordon.

Sorry, here is the full line of code in the PHP

$grid->setColProperty(‘REV_TOT’, array(“label”=>”Revenue”, “formatter”=>”currency”,”formatoptions”=>array(“isExported”=>true,”exporttype”=>”excel”,”decimalPlaces”=>2,”thousandsSeparator”,”,”),”align”=>”right”));