Click here to Skip to main content
13,000,135 members (57,646 online)
Rate this:
Please Sign up or sign in to vote.

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.
Posted 19-May-13 19:47pm
Updated 22-May-13 20:29pm

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170624.1 | Last Updated 20 Oct 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100