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

Date Format when Importing CSV

Aug 1, 2014 at 3:58 PM
Edited Aug 1, 2014 at 3:59 PM
Hello guys, Im importing a CSV which has a column that displays Dates (I want to display them as dd/mm/yyyy)

CSV Example:

B]999] 13/01/2014 15:34 ]TEXT1]1
B]999] 03/01/2014 12:37 ]TEXT2]3
B]999] 03/01/2014 12:37 ]TEXT3]2

When i save the file with the rows imported to a XLSX I see the dates in this way:

13/01/2014 15:34

I tried to set a culture to the ExcelTextFormat but all i get is an empty report (only with the column headers)
   var format = new ExcelTextFormat();
   format.Delimiter = ']';
   format.TextQualifier = '[';
   format.SkipLinesBeginning = 0;
   format.SkipLinesEnd = 0;
   //format.Culture = CultureInfo.InvariantCulture; //Same as nothing
   //format.Culture = new CultureInfo("es-AR"); //Empty report
Do you guys know how to do a workaround this?