Posted 8 September 2017, 2:52 pm EST
Our app had code below working at v 4.0.3512.2008 but stopped working at 5.0.3518.2008. We are using VS2010(Target Framework: .NET Framework 3.5 or 4)
.SaveExcel() method using ExcelSaveFlags.SaveCustomColumnHeaders stopped exporting data (exports Column Headers only).
Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
Try
Dim dtTest As New DataTable
With dtTest
.Columns.Add("StoredValue", Type.GetType("System.String"))
.Columns.Add("DisplayValue", Type.GetType("System.String"))
.Rows.Add("1", "Standard")
End With
With FpSpread1.ActiveSheet
.DataSource = dtTest
End With
Catch ex As Exception
End Try
End Sub
Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
Try
'Using this flag: populate column headers but no data
FpSpread1.SaveExcel("C:\TEMP\11.XLS", FarPoint.Excel.ExcelSaveFlags.SaveCustomColumnHeaders)
'code below
'Poulates data only
'FpSpread1.SaveExcel("C:\TEMP\11.XLS")
Catch ex As Exception
End Try
End Sub
