Transfering data from Excel to dataGridView
- by Panecillo
I have a problem when I want to transfer data from Excel to dataGridView in C#.
My Excel's column has numeric and alphanumeric values. But for example, if the column has 3 numbers and 2 alphanumeric values then only the numbers are shown in the dataGridView, and vice versa. Why aren't all the values shown? The next is what happen:
Excel's Column:…