Text with comma is sowing like date

[mguha]

Hello,
I have a ops column where some of the values in datatable like 10,15 or 03,10,15. Now when it's displaying this using Free spire.xls the column looks like 10/15/2017 or 3/10/2015

Datable Excel
10,15 10/15/2017 not ok. how it's converting to date
03,10,15 3/10/2015 not ok. how it's converting to date
09 9 This is ok. But needs to be 09 though

I don't have any date format or anything.
code is simple . I have sheet.InsertDataTable(dt, true, 3, 1);
then savetoFile. Need help. this is strange.

[Simon.yang]

Hello,

Thanks for your post. Please change sheet.InsertDataTable(dt, true, 3, 1) into sheet.InsertDataTable(dt, true, 3, 1, true) which will keep the format from the data table.

Best regards,
Simon
E-iceblue support team

[Simon.yang]

Hello,

Hope you are doing well.
Did you try the solution I provided? Is it working on your side?
Please give us some feedback at your convenience.

Best regards,
Simon
E-iceblue support team

[mguha]

Solved. Thanks

[Simon.yang]

Hello,

Thanks for your feedback. If you have any other question, please feel free to contact us.

Best regards,
Simon
E-iceblue support team