Hi Dale,
Thanks for using Syncfusion products.
We suggest you to inherit the GridExcelExport class and
override the CopyStyles method to achieve your requirement. Please refer to the
code snippet below.
Public Class mycustomExport
Inherits GridExcelExport
Public Sub New(ByVal ggc As GridGroupingControl, ByVal fileName As String)
MyBase.New(ggc, fileName)
End Sub
Protected Overrides Sub CopyStyles(ByVal style As GridTableCellStyleInfo, ByVal rowIdx As Integer, ByVal colIdx As Integer)
Dim range As IRange = Me.Sheet(rowIdx, colIdx)
If style.TableCellIdentity.DisplayElement.Kind = DisplayElementKind.Record AndAlso style.TableCellIdentity.Column.HeaderText = "TestCurrency" Then
Dim nTest As Double = 0.0
nTest = rowIdx + 1
Dim nPi As Double = nTest * Math.PI
range.Text = String.Format("{0:C}", nPi)
End If
End Sub
End Class
Sample link: sample.zip
Please let us know if you have any concern.
Regards,
Ranjithkumar.