In gridview export to excel how to get colors in excel sheet Sir, I want to export Crystal report to Excel and the following is the code i wrote in the button click.ReportDocument rptExcel = new ReportDocument() string strExportFile = "C:/Session_SessionID.xls" rptExcel = new RptJobOrderRecap() //report = ExportDestinationType.DiskFile = ExportFormatType.Excel ExcelFormatOptions objExcelOptions = new ExcelFormatOptions() objExcelOptions.ExcelUseConstantColumnWidth = false = objExcelOptions DiskFileDestinationOp.