{"id":2110,"date":"2020-01-02T22:09:49","date_gmt":"2020-01-02T22:09:49","guid":{"rendered":"http:\/\/mauricemuteti.info\/?p=2110"},"modified":"2023-03-12T02:13:34","modified_gmt":"2023-03-12T02:13:34","slug":"how-to-import-excel-to-datagridview-in-c-sharp","status":"publish","type":"post","link":"https:\/\/mauricemuteti.info\/how-to-import-excel-to-datagridview-in-c-sharp\/","title":{"rendered":"How To Import Excel To Datagridview In C Sharp"},"content":{"rendered":"\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"How To Import Excel To Datagridview In C#\" width=\"769\" height=\"433\" src=\"https:\/\/www.youtube.com\/embed\/7xML-fvv774?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<\/div><figcaption>  <strong>How To Import Excel To Datagridview In C#<\/strong>  <\/figcaption><\/figure>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_49 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"ez-toc-toggle-icon-1\"><label for=\"item-67773ffc282d4\" aria-label=\"Table of Content\"><span style=\"display: flex;align-items: center;width: 35px;height: 30px;justify-content: center;direction:ltr;\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/label><input  type=\"checkbox\" id=\"item-67773ffc282d4\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/mauricemuteti.info\/how-to-import-excel-to-datagridview-in-c-sharp\/#How_To_Import_Excel_To_Datagridview_In_C\" title=\"How To Import Excel To Datagridview In C#\">How To Import Excel To Datagridview In C#<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/mauricemuteti.info\/how-to-import-excel-to-datagridview-in-c-sharp\/#Form1cs_SOURCE_CODE\" title=\"Form1.cs SOURCE CODE\">Form1.cs SOURCE CODE<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/mauricemuteti.info\/how-to-import-excel-to-datagridview-in-c-sharp\/#Form1Designercs_SOURCE_CODE\" title=\"Form1.Designer.cs SOURCE CODE\">Form1.Designer.cs SOURCE CODE<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/mauricemuteti.info\/how-to-import-excel-to-datagridview-in-c-sharp\/#Programcs_SOURCE_CODE\" title=\"Program.cs SOURCE CODE\">Program.cs SOURCE CODE<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"How_To_Import_Excel_To_Datagridview_In_C\"><\/span><strong>How To Import Excel To Datagridview In C#<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" loading=\"lazy\" width=\"700\" height=\"308\" src=\"http:\/\/mauricemuteti.info\/wp-content\/uploads\/2020\/01\/How-To-Import-Excel-To-Datagridview-In-C-Sharp-700x308.png\" alt=\"How To Import Excel To Datagridview In C#\" class=\"wp-image-2111\" srcset=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2020\/01\/How-To-Import-Excel-To-Datagridview-In-C-Sharp-700x308.png 700w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2020\/01\/How-To-Import-Excel-To-Datagridview-In-C-Sharp-300x132.png 300w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2020\/01\/How-To-Import-Excel-To-Datagridview-In-C-Sharp.png 712w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><figcaption> <strong>How To Import Excel To Datagridview In C#<\/strong> <\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" loading=\"lazy\" width=\"700\" height=\"358\" src=\"http:\/\/mauricemuteti.info\/wp-content\/uploads\/2020\/01\/How-To-Import-Excel-To-Datagridview-In-CSharp-700x358.png\" alt=\"How To Import Excel To Datagridview In C#\" class=\"wp-image-2112\" srcset=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2020\/01\/How-To-Import-Excel-To-Datagridview-In-CSharp-700x358.png 700w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2020\/01\/How-To-Import-Excel-To-Datagridview-In-CSharp-300x153.png 300w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2020\/01\/How-To-Import-Excel-To-Datagridview-In-CSharp-768x393.png 768w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2020\/01\/How-To-Import-Excel-To-Datagridview-In-CSharp-769x393.png 769w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2020\/01\/How-To-Import-Excel-To-Datagridview-In-CSharp.png 853w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><figcaption> <strong>How To Import Excel To Datagridview In C#<\/strong> <\/figcaption><\/figure>\n\n\n\n<p>How To Import Excel To Datagridview In C# .Net Windows Application<br> This Tutorial Shows How To Import Excel To Datagridview In C# .Net Windows Application Using Visual Studio 2010 And Microsoft Excel 2010.<\/p>\n\n\n\n<p>This application imports excel file to datagridview when you click import button. For the code to work you need to import\/Add microsoft.office.interop.excel library to your project.<\/p>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Form1cs_SOURCE_CODE\"><\/span>Form1.cs SOURCE CODE<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<pre class=\"brush: csharp; title: ; notranslate\" title=\"\">\nusing System;\nusing System.Collections.Generic;\nusing System.ComponentModel;\nusing System.Data;\nusing System.Drawing;\nusing System.Linq;\nusing System.Text;\nusing System.Windows.Forms;\nusing Microsoft.Office.Interop.Excel;\n\nnamespace HowToImportExcelToDataGridViewInCSharp\n{\n    public partial class Form1 : Form\n    {\n        public Form1()\n        {\n            InitializeComponent();\n        }\n\n        private void btnImportExcelToDataGridView_Click(object sender, EventArgs e)\n        {\n            _Application importExcelToDataGridViewApp;\n            _Workbook importExcelToDataGridViewWorkbook;\n            _Worksheet importExcelToDataGridViewWorksheet;\n            Range importExcelToDataGridViewRange;\n            \n            try\n            {\n                importExcelToDataGridViewApp = new Microsoft.Office.Interop.Excel.Application();\n\n                OpenFileDialog importExcelToDataGridViewOpenFileDialog = new OpenFileDialog();\n                \/\/importExcelToDataGridViewOpenFileDialog.InitialDirectory = @&quot;C:\/Users\/Authentic\/Desktop&quot;;\n                \/\/importExcelToDataGridViewOpenFileDialog.RestoreDirectory = true;\n                \/\/Dialog Box Title\n                importExcelToDataGridViewOpenFileDialog.Title = &quot;Import Excel File To DataGridView&quot;;\n                \/\/filter Excel Files Only\n                importExcelToDataGridViewOpenFileDialog.Filter = &quot;Choose Excel File | *.xlsx;*.xls;*.xlm&quot;;\n                \/\/If Open Button Is Clicked\n                if (importExcelToDataGridViewOpenFileDialog.ShowDialog() == DialogResult.OK)\n                {\n                    importExcelToDataGridViewWorkbook = importExcelToDataGridViewApp.Workbooks.Open(importExcelToDataGridViewOpenFileDialog.FileName);\n                    importExcelToDataGridViewWorksheet = importExcelToDataGridViewWorkbook.ActiveSheet;\n                    importExcelToDataGridViewRange = importExcelToDataGridViewWorksheet.UsedRange;\n\n                    \/\/Start Importing from the second row. Since the first row is column header\n                    for (int excelWorkSheetRowIndex = 2; excelWorkSheetRowIndex &amp;lt; importExcelToDataGridViewRange.Rows.Count + 1; excelWorkSheetRowIndex++)\n                    {\n                        \/\/Convert The Path to image and display it in datagridviewimagecolumn\n                        Image excelWorkSheetImage = Image.FromFile(importExcelToDataGridViewWorksheet.Cells[excelWorkSheetRowIndex, 7].Value);\n                        dgvImportExcelToDatagridGridView1.Rows.Add(importExcelToDataGridViewWorksheet.Cells[excelWorkSheetRowIndex, 1].Value, importExcelToDataGridViewWorksheet.Cells[excelWorkSheetRowIndex, 2].Value, importExcelToDataGridViewWorksheet.Cells[excelWorkSheetRowIndex, 3].Value, importExcelToDataGridViewWorksheet.Cells[excelWorkSheetRowIndex, 4].Value, importExcelToDataGridViewWorksheet.Cells[excelWorkSheetRowIndex, 5].Value, importExcelToDataGridViewWorksheet.Cells[excelWorkSheetRowIndex, 6].Value, importExcelToDataGridViewWorksheet.Cells[excelWorkSheetRowIndex, 7].Value, excelWorkSheetImage);\n                    }\n                }\n\n            }\n            catch (Exception importExcelToDataGridViewException)\n            {\n                MessageBox.Show(&quot;Error&quot; + importExcelToDataGridViewException);              \n            }\n        }\n\n        private void Form1_Load(object sender, EventArgs e)\n        {\n            \/\/change DataGridView Height On Form Load\n            dgvImportExcelToDatagridGridView1.RowTemplate.Height = 50;\n        }\n    }\n}\n\n<\/pre>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Form1Designercs_SOURCE_CODE\"><\/span>Form1.Designer.cs SOURCE CODE<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<pre class=\"brush: csharp; title: ; notranslate\" title=\"\">\nnamespace HowToImportExcelToDataGridViewInCSharp\n{\n    partial class Form1\n    {\n        \/\/\/ &amp;lt;summary&amp;gt;\n        \/\/\/ Required designer variable.\n        \/\/\/ &amp;lt;\/summary&amp;gt;\n        private System.ComponentModel.IContainer components = null;\n\n        \/\/\/ &amp;lt;summary&amp;gt;\n        \/\/\/ Clean up any resources being used.\n        \/\/\/ &amp;lt;\/summary&amp;gt;\n        \/\/\/ &amp;lt;param name=&quot;disposing&quot;&amp;gt;true if managed resources should be disposed; otherwise, false.&amp;lt;\/param&amp;gt;\n        protected override void Dispose(bool disposing)\n        {\n            if (disposing &amp;amp;&amp;amp; (components != null))\n            {\n                components.Dispose();\n            }\n            base.Dispose(disposing);\n        }\n\n        #region Windows Form Designer generated code\n\n        \/\/\/ &amp;lt;summary&amp;gt;\n        \/\/\/ Required method for Designer support - do not modify\n        \/\/\/ the contents of this method with the code editor.\n        \/\/\/ &amp;lt;\/summary&amp;gt;\n        private void InitializeComponent()\n        {\n            this.dgvImportExcelToDatagridGridView1 = new System.Windows.Forms.DataGridView();\n            this.btnImportExcelToDataGridView = new System.Windows.Forms.Button();\n            this.Column1 = new System.Windows.Forms.DataGridViewTextBoxColumn();\n            this.Column2 = new System.Windows.Forms.DataGridViewTextBoxColumn();\n            this.Column3 = new System.Windows.Forms.DataGridViewTextBoxColumn();\n            this.Column6 = new System.Windows.Forms.DataGridViewTextBoxColumn();\n            this.Column4 = new System.Windows.Forms.DataGridViewTextBoxColumn();\n            this.Column5 = new System.Windows.Forms.DataGridViewTextBoxColumn();\n            this.Column7 = new System.Windows.Forms.DataGridViewTextBoxColumn();\n            this.Column8 = new System.Windows.Forms.DataGridViewImageColumn();\n            ((System.ComponentModel.ISupportInitialize)(this.dgvImportExcelToDatagridGridView1)).BeginInit();\n            this.SuspendLayout();\n            \/\/ \n            \/\/ dgvImportExcelToDatagridGridView1\n            \/\/ \n            this.dgvImportExcelToDatagridGridView1.AllowUserToAddRows = false;\n            this.dgvImportExcelToDatagridGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;\n            this.dgvImportExcelToDatagridGridView1.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {\n            this.Column1,\n            this.Column2,\n            this.Column3,\n            this.Column6,\n            this.Column4,\n            this.Column5,\n            this.Column7,\n            this.Column8});\n            this.dgvImportExcelToDatagridGridView1.Location = new System.Drawing.Point(3, 4);\n            this.dgvImportExcelToDatagridGridView1.Name = &quot;dgvImportExcelToDatagridGridView1&quot;;\n            this.dgvImportExcelToDatagridGridView1.Size = new System.Drawing.Size(829, 336);\n            this.dgvImportExcelToDatagridGridView1.TabIndex = 0;\n            \/\/ \n            \/\/ btnImportExcelToDataGridView\n            \/\/ \n            this.btnImportExcelToDataGridView.Font = new System.Drawing.Font(&quot;Microsoft Sans Serif&quot;, 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));\n            this.btnImportExcelToDataGridView.Location = new System.Drawing.Point(426, 346);\n            this.btnImportExcelToDataGridView.Name = &quot;btnImportExcelToDataGridView&quot;;\n            this.btnImportExcelToDataGridView.Size = new System.Drawing.Size(406, 42);\n            this.btnImportExcelToDataGridView.TabIndex = 1;\n            this.btnImportExcelToDataGridView.Text = &quot;Import Excel To DataGridView&quot;;\n            this.btnImportExcelToDataGridView.UseVisualStyleBackColor = true;\n            this.btnImportExcelToDataGridView.Click += new System.EventHandler(this.btnImportExcelToDataGridView_Click);\n            \/\/ \n            \/\/ Column1\n            \/\/ \n            this.Column1.HeaderText = &quot;Full Name&quot;;\n            this.Column1.Name = &quot;Column1&quot;;\n            \/\/ \n            \/\/ Column2\n            \/\/ \n            this.Column2.HeaderText = &quot;Email&quot;;\n            this.Column2.Name = &quot;Column2&quot;;\n            \/\/ \n            \/\/ Column3\n            \/\/ \n            this.Column3.HeaderText = &quot;Phone Number&quot;;\n            this.Column3.Name = &quot;Column3&quot;;\n            \/\/ \n            \/\/ Column6\n            \/\/ \n            this.Column6.HeaderText = &quot;Language&quot;;\n            this.Column6.Name = &quot;Column6&quot;;\n            \/\/ \n            \/\/ Column4\n            \/\/ \n            this.Column4.HeaderText = &quot;Country&quot;;\n            this.Column4.Name = &quot;Column4&quot;;\n            \/\/ \n            \/\/ Column5\n            \/\/ \n            this.Column5.HeaderText = &quot;Gender&quot;;\n            this.Column5.Name = &quot;Column5&quot;;\n            \/\/ \n            \/\/ Column7\n            \/\/ \n            this.Column7.HeaderText = &quot;Image Path&quot;;\n            this.Column7.Name = &quot;Column7&quot;;\n            \/\/ \n            \/\/ Column8\n            \/\/ \n            this.Column8.HeaderText = &quot;Image&quot;;\n            this.Column8.ImageLayout = System.Windows.Forms.DataGridViewImageCellLayout.Stretch;\n            this.Column8.Name = &quot;Column8&quot;;\n            this.Column8.Resizable = System.Windows.Forms.DataGridViewTriState.True;\n            this.Column8.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.Automatic;\n            \/\/ \n            \/\/ Form1\n            \/\/ \n            this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);\n            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;\n            this.ClientSize = new System.Drawing.Size(836, 394);\n            this.Controls.Add(this.btnImportExcelToDataGridView);\n            this.Controls.Add(this.dgvImportExcelToDatagridGridView1);\n            this.Name = &quot;Form1&quot;;\n            this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;\n            this.Text = &quot;Form1&quot;;\n            this.Load += new System.EventHandler(this.Form1_Load);\n            ((System.ComponentModel.ISupportInitialize)(this.dgvImportExcelToDatagridGridView1)).EndInit();\n            this.ResumeLayout(false);\n\n        }\n\n        #endregion\n\n        private System.Windows.Forms.DataGridView dgvImportExcelToDatagridGridView1;\n        private System.Windows.Forms.Button btnImportExcelToDataGridView;\n        private System.Windows.Forms.DataGridViewTextBoxColumn Column1;\n        private System.Windows.Forms.DataGridViewTextBoxColumn Column2;\n        private System.Windows.Forms.DataGridViewTextBoxColumn Column3;\n        private System.Windows.Forms.DataGridViewTextBoxColumn Column6;\n        private System.Windows.Forms.DataGridViewTextBoxColumn Column4;\n        private System.Windows.Forms.DataGridViewTextBoxColumn Column5;\n        private System.Windows.Forms.DataGridViewTextBoxColumn Column7;\n        private System.Windows.Forms.DataGridViewImageColumn Column8;\n    }\n}\n\n\n<\/pre>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Programcs_SOURCE_CODE\"><\/span>Program.cs SOURCE CODE<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<pre class=\"brush: csharp; title: ; notranslate\" title=\"\">\nusing System;\nusing System.Collections.Generic;\nusing System.Linq;\nusing System.Windows.Forms;\n\nnamespace HowToImportExcelToDataGridViewInCSharp\n{\n    static class Program\n    {\n        \/\/\/ &amp;lt;summary&amp;gt;\n        \/\/\/ The main entry point for the application.\n        \/\/\/ &amp;lt;\/summary&amp;gt;\n        [STAThread]\n        static void Main()\n        {\n            Application.EnableVisualStyles();\n            Application.SetCompatibleTextRenderingDefault(false);\n            Application.Run(new Form1());\n        }\n    }\n}\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>How To Import Excel To Datagridview In C# How To Import Excel To Datagridview In C# .Net Windows Application This Tutorial Shows How To Import&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/posts\/2110"}],"collection":[{"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/comments?post=2110"}],"version-history":[{"count":0,"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/posts\/2110\/revisions"}],"wp:attachment":[{"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/media?parent=2110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/categories?post=2110"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/tags?post=2110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}