Question
2
Replies
92
Views
Posted: January 25, 2019
Last activity: January 28, 2019
Closed
Date Problem in Excel while exporting to datagridview
Hello,
My requirement is to fetch excel date cloumn values to datagridview. But the problem is while fetching the date values to the datagridview it is displaying string values(i.e, 03-10-2018 is displayed as 43001). How can I resolve this problem?
Thanks & Regards,
Annapurna
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 2 years ago
I am new to C#.How can we define the script for the above code?
Thanks & Regards,
Anu
@AnuP3667
Try by applying dateformat on DataGridView columns using c# code.
dataGridView1.Columns[0].DefaultCellStyle.Format = "dd/MM/yyyy";