This project has moved. For the latest updates, please go here.

handle null date

Jul 15, 2013 at 4:26 PM
Edited Jul 15, 2013 at 4:50 PM
Hello, when I export a datatable to excel if a date columns value is null then the created excel file displays 1/0/1900 as the null date value.

How can I ensure if the date value is null to not show 1/0/1900 but display nothing in that cell?

Dim DS As New DataSet
        Dim DT As DataTable
        DS = ConvertToDataSet(MyData)
        DT = DS.Tables(0)

        Dim wb As New XLWorkbook

        wb.Worksheets.Add(DT)