Comments by CandyT - CodeProject

CandyT 20-Dec-12 2:17am View

What file format do you want to export into?

CandyT 19-Dec-12 22:02pm View

Hi Melvintcs, have you added the reference System.Data and System.Data.OleDb?

CandyT 19-Dec-12 0:49am View

http://www.e-iceblue.com/Introduce/data-export-for-net-intro.html It may help

CandyT 18-Dec-12 23:04pm View

Private Sub cellExport1_GetDataParams(sender As Object, e As Spire.DataExport.EventArgs.DataParamsEventArgs)
If e.Col = 1 Then
e.FormatText = "dd/MM/yy"
End If
End Sub

Using these code to keep the date format

CandyT 18-Dec-12 22:33pm View

You could add a new row after it is exported into excel

CandyT 12-Dec-12 4:30am View

It's great that you have solved it.

CandyT 12-Dec-12 4:29am View

Seems the trial version has the same function with the paid edition. Good luck.

CandyT 10-Dec-12 20:47pm View

Just reinstall your visual studio and try again to see the results.

Comments by CandyT (Top 8 by date)