Exporting crystal report to excel problem

[Sep410]

Hi all,
I have a report in crystal report when I export it to excel each column will be shown in 2 or 3 merged columns!!!
The worst part is that sometimes the header of the column is in the A and B columns but the details of this columns are in B and C in excel sheet!!!
I don’t want that and I want to have normal excel sheet with the boarders around each cell what should I do?
Here is the example of my exported report in excel:

A        B        C        D        E        F          G    
Case         Customer Name                                 Tel
1                        John                1232547
2                        Jane                9999999    
3                        Mark                99999544
4                        Harry                8789874
 
What I need in excel is:
A    B        C        
Case     Customer Name     Tel
1    John        1232547
2    Jane        9999999    
3    Mark        99999544
4    Harry        8789874
 

Please help me.

[dnnddane]

I used to come across this problem before.
What i have done is to rearrange all fields in crystall report and make sure header and value field is in the same column(same position, width and height).
you can use snap to grid in Crystal Report to help you in arranging fields.

Finally, you will get a good result in excel file.
Dane

[amwggyy504]

I exploitation report use VS2005 RDLC,it Export to excel is very good .

[grigorythegreat]

There is no need to involve Crystal Reports if all you want is to export your data into an excel spreadsheet. Below is the code that worked for me:

Private Sub ExportToExcel(ByVal GridView1 As GridView)

Try
Dim strFileName As String = "Report" & ".xls"
Dim strFilePath As String = "C:\temp\" & strFileName
If File.Exists(strFilePath) Then
File.Delete(strFilePath)
End If

Dim oStringWriter As New StringWriter
Dim oHtmlTextWriter As New HtmlTextWriter(oStringWriter)
Dim objStreamWriter As StreamWriter
Dim strStyle As String = Environment.NewLine

objStreamWriter = File.AppendText(strFilePath)
GridView1.RenderControl(oHtmlTextWriter)
objStreamWriter.WriteLine(strStyle)
objStreamWriter.WriteLine(oStringWriter.ToString)
objStreamWriter.Close()
Me.btnExportToExcel.Attributes.Add("OnClick", "wOpen()")

Catch ex As Exception

End Try
End Sub

[Sep410]

I used to come across this problem before.
What i have done is to rearrange all fields in crystall report and make sure header and value field is in the same column(same position, width and height).
you can use snap to grid in Crystal Report to help you in arranging fields.

Finally, you will get a good result in excel file.
Dane

Thanks,
That was what I needed.
It is working well now.