I'm reading and processing excel files (xlsx). I have two sample files and my code behaves differently for them. Both files are, to my knowledge, generated by the same software, but possibly on different systems. Columns represent the same information (e.g.
date, time, product code etc).
Excerpt from file 1
S,10/3/2014,22:05:00,23:45:00,.....
S,10/3/2014,19:55:00,24:05:00,.....
Excerpt from file 2
S,11/5/2014,20:20:00,20:20:00,.....
The last shown column in the excerpts represents a time. When I read the first file, I indeed get the data shown. If I read the second file, it's a complete date/time. I've checked the formats of the cell in the first record using the below excel function
and they are the same (D8).
=cell("format",D2)
The code to process the excel data
foreach (DataTable table in ds.Tables)
{
...
Go to the complete details ...