How to run a C# funtion with double clicking on a cell

DataGridView can work with DataTables, Lists, and so on - so it's just a case of getting the Excel data in a form it can work with.

How you do that will depend on how you access the Excel data in the first place - but a simple Google gives a lot of hits: datagridview from excel workbook c - Google Search[^]

Start by thinking about how you get the Excel data currently, what constructs it it in, and so forth - then refine your search appropriately.

private void GridViewSetup()
{
int intDate = RegGlobals.intDateCol;
int int1stNam = RegGlobals.intFirstNameCol;
int int2ndNam = RegGlobals.intLastNameCol;
int intCity = RegGlobals.intCityCol;
int intZip = RegGlobals.intZipCodeCol;
int intPhone = RegGlobals.intPhoneCol;
int intNumInFam = RegGlobals.intNumInFamilyCol;
int intActiveSheet = frmFoodPantry.theWorkbook.ActiveSheet.Index;

Excel.Range xlRange = frmFoodPantry.theWorkbook.Sheets[intActiveSheet].UsedRange;
dgvExcel.ColumnCount = xlRange.Columns.Count;
int intRowIndex = 0;

for(int x1Row = 2; x1Row <= xlRange.Rows.Count; x1Row++)
{
if (intRowIndex == 0)
{
dgvExcel.Rows.Add(xlRange.Cells[x1Row, intDate].Text, xlRange.Cells[x1Row, int1stNam].Text, xlRange.Cells[x1Row, int2ndNam].Text,
xlRange.Cells[x1Row, intCity].Text, xlRange.Cells[x1Row, intZip].Text, xlRange.Cells[x1Row, intPhone].Text, xlRange.Cells[x1Row, intNumInFam].Text);
}
else
{
dgvExcel.Rows.Add(intRowIndex, xlRange.Cells[x1Row, intDate].Text, xlRange.Cells[x1Row, int1stNam].Text, xlRange.Cells[x1Row, int2ndNam].Text,
xlRange.Cells[x1Row, intCity].Text, xlRange.Cells[x1Row, intZip].Text, xlRange.Cells[x1Row, intPhone].Text, xlRange.Cells[x1Row, intNumInFam].Text);
}
intRowIndex++;
}
frmFoodPantry.theWorkbook.Close();
}