Copy Data from Excel to DataGridView.

Question

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.

Anoop Kumar Sharma · 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.

Ghulam Murtaza · Answer

Thanks Anoop Kumar Sharma

Sachin Singh · Answer

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 Ahmed · Answer

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 R · Answer

Hi , please refer this link: https://www.youtube.com/watch?v=CpD8rxcf3E4

alice yang · Answer

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