Copy Data from Excel to DataGridView.

Ghulam Murtaza

Hello,

I'm wondring about how I copy data from excel and paste in datagridview in C#... Give me a simple code that I copy data from excel manually then in C# form I could paste in dataDridview in existing SQL table.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Anoop Kumar Sharma6y ago
Accepted answer
Hi Ghulam Murtaza,

Instead of copy and pasting the data to gridview, Upload the Excel Sheet's data in a Table, and bind the data from that table to datagridview.

I am sharing you a few links which might be helpful for you:

https://www.aspsnippets.com/Articles/Import-data-from-Excel-file-to-Windows-Forms-DataGridView-using-C-and-VBNet.aspx

https://www.encodedna.com/windows-forms/read-an-excel-file-in-windows-forms-application-using-csharp-vbdotnet.htm

I hope this will help you.
alice yang6y ago
You can use Free Spire.XLS API to easily copy data from Excel to DataGridview.

Refer the below link:
https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Import/Export-Import-Data-from-Excel-to-Datatable.html
Ghulam Murtaza6y ago
Thanks Anoop Kumar Sharma
Sachin Singh6y ago
Please visit below link
https://www.aspsnippets.com/Articles/Read-and-Import-Excel-File-into-DataSet-or-DataTable-using-C-and-VBNet-in-ASPNet.aspx
Farhan Ahmed6y ago
visit these link

https://stackoverflow.com/questions/22833327/pasting-excel-data-into-a-blank-datagridview-index-out-of-range-exception
https://www.codeproject.com/Articles/36850/DataGridView-Copy-and-Paste
Mageshwaran R6y ago
Hi ,
please refer this link:
https://www.youtube.com/watch?v=CpD8rxcf3E4