Export to Excel from Crystal reports in VB.NET

See more:

VB

Hi,

i am generating report by using crystal reports.
if i export the report to excel ., the records getting exporting.

But there is no proper alignment.

Now i want to see the records into excel as like crystal report.

Presently i am using the below code for exporting the records into Excel

Try
Dim CrExportOptions As ExportOptions
Dim CrDiskFileDestinationOptions As New _
DiskFileDestinationOptions()
Dim CrFormatTypeOptions As New ExcelFormatOptions
CrDiskFileDestinationOptions.DiskFileName = _
"c:\crystalExport.xls"
CrExportOptions = cryRpt.ExportOptions
With CrExportOptions
.ExportDestinationType = ExportDestinationType.DiskFile
.ExportFormatType = ExportFormatType.Excel
.DestinationOptions = CrDiskFileDestinationOptions
.FormatOptions = CrFormatTypeOptions
End With
cryRpt.Export()
Catch ex As Exception
MsgBox(ex.ToString)
End Try

Can you please any one help on this?