how to read image in datagridview from excel sheet

Question

i am having a excel sheet containing student details with photos...i want to read all the details along with photo in datagridview...i am not able to read image..

Kyle Story · Answer

Kale you can try this simple approach for converting back and forth between DataGridView control and Excel : ExcelFile ef = ExcelFile.Load(openFileDialog.FileName); // From ExcelFile to DataGridView. DataGridViewConverter.ExportToDataGridView(ef.Worksheets.ActiveWorksheet, this.dataGridView1, new ExportToDataGridViewOptions() { ColumnHeaders = true }); ExcelFile ef = new ExcelFile(); ExcelWorksheet ws = ef.Worksheets.Add("DataGridView Sheet"); // From DataGridView to ExcelFile. DataGridViewConverter.ImportFromDataGridView(ws, this.dataGridView1, new ImportFromDataGridViewOptions() { ColumnHeaders = true }); ef.Save(saveFileDialog.FileName); The code uses this Excel component for .NET framework . Now regarding your second task, I'm not sure what you need. As you mentioned you have student photos in an excel sheet and with the above code you will get those photos in DataGridView cells. Again I'm not sure but I presume you want to change these photos, then you can just change them when user clicks on them, like this: private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { var cell = ((DataGridView)sender).Rows[e.RowIndex].Cells[e.ColumnIndex]; if (cell.FormattedValueType == typeof(Image)) cell.Value = Image.FromFile(@"C:\New Photo.png"); }

Munesh Sharma · Answer

http://dotnet-munesh.blogspot.in/2014/05/create-excelxls-and-xlsx-file-from-c.html

Shradha Kale · Answer

(winform) GridView cells display system. Drawing. Bitmap don't display picture

Shradha Kale · Answer

I want to upload photos in each row of datagridview by clicking on linklabel present in that row....

Sagar Pardeshi · Answer

ref following url: http://www.codeproject.com/Articles/28269/Exporting-a-DataGridView-to-an-Excel-PDF-image-fil

how to read image in datagridview from excel sheet

Answers (5)