Hi Ganesh,
You can call the CopyMergesFromGrid method after calling the ExportColumnHeaders method. Here is a code snippet.
private void CopyMergesFromGrid( GridModel grid, IWorksheet sheet)
{
GridModelCoveredRanges coveredRanges = grid.CoveredRanges;
GridRangeInfoList ranges = grid.CoveredRanges.Ranges;
for( int i = 0, len = ranges.Count; i < len; i++ )
{
GridRangeInfo rangeInfo = ranges[ i ];
string strMessage = string.Format( "({0}, {1})-({2}, {3})", rangeInfo.Top, rangeInfo.Left, rangeInfo.Bottom, rangeInfo.Right );
if( rangeInfo.Top == 0 || rangeInfo.Left == 0 ) continue;
sheet.Range[ rangeInfo.Top, rangeInfo.Left, rangeInfo.Bottom, rangeInfo.Right ].Merge();
}
}
Please refer to the attached sample for more details and let me know if this helps.
GDBGExportRowHeader.zipBest regards,
Haneef