Add data(rows) to WPF datagrid uisng C#

See more:

C#

WPF

DataGrid

Hello Team,

I have created WPF datagrid with below 3 columns in design mode. I want to add below information on button click event.

Sr.No = AutoNumber
MappingFileColumnNames = To be filled from items from one of List object (I have list of employees in a <list>
Department This is a ComboBox with values (Dept 1, Dept , Dept 3)

Please Help.

What I have tried:

List<string> MappingFileColumnNames = new List<string>();

private void GetExcelSheetColumnNames(string FilePath, int SelectedSheet)
        {
            Microsoft.Office.Interop.Excel.Application XLApp = new Microsoft.Office.Interop.Excel.Application();          

            Microsoft.Office.Interop.Excel.Workbook wkb = XLApp.Workbooks.Open(FilePath, 0, true);
            
            Microsoft.Office.Interop.Excel.Worksheet wks = (Microsoft.Office.Interop.Excel.Worksheet)wkb.Worksheets.get_Item(SelectedSheet);
            Microsoft.Office.Interop.Excel.Range DataRng = wks.UsedRange;

            string strCellData = "";
            int colCnt = 0;

            for (colCnt = 1; colCnt <= DataRng.Columns.Count; colCnt++)
            {
                string strColumn = "";
                strColumn = (string)(DataRng.Cells[1, colCnt] as Microsoft.Office.Interop.Excel.Range).Value2;
                MappingFileColumnNames.Add(strColumn);
            }
	    }