c# - Issue while reading an Excel through adapter which was written through npoi -

c# - Issue while reading an Excel through adapter which was written through npoi -

steps doing:

first exported rows excel(97-2003 format) using npoi. columns string fields, date fields , time fields when exported excel converted string(general in terms of excel format). now if suppose open above formed excel , update few cells(specially date/time columns), excel converts cells date/time format. now when read excel file using oledb adapter, reads cells converted date/time fields other cells in same column in string format throws error.

the npoi examples have illustration of setting date values in cells (setdatecellinxls). has 2 methods of writing dates, first setting cell style date format (the illustration in chinese, should easy utilize locale). sec utilize formula come in date.

hopefully 1 of these solve problem

c# npoi