Crystal report to excel wrap and merge

See more:

C#

MS-Excel

CrystalReports

Hi
I am using this code.

ReportClass report = ConfiguringCrysReports(); 
ExportOptions exportOpts = new ExportOptions(); 
ExcelFormatOptions excelFormatOpts = new ExcelFormatOptions(); DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions(); 
exportOpts = report.ExportOptions; 
// Set the excel format options. 
//excelFormatOpts.ExcelUseConstantColumnWidth = true; 
exportOpts.ExportFormatType = ExportFormatType.Excel; 
exportOpts.FormatOptions = excelFormatOpts; 
// Set the disk file options and export. 
exportOpts.ExportDestinationType = ExportDestinationType.DiskFile; diskOpts.DiskFileName = "D:\\RnD\\abc.xls"; 
exportOpts.DestinationOptions = diskOpts; report.Export(); 

But the text in excel is wrapping and merging column cells. I require not to merge column cells. Any suggestion / help is welcome.