'Add new sheet in Excel from windows application c#

Hi i want to add new sheet and populate data from data-table into excel from windows application c#.If If the excel is already existing i have to create a new sheet for the same excel and get data from db using datatable and save. while adding new sheet i get typemismatch error https://imgur.com/6zlSub9 Please help. Code attached.

SqlConnection con = new SqlConnection();
                SqlCommand cmd = new SqlCommand("select * from tblBrand", con);
                con.Open();
                try
                {
                    SqlDataAdapter sda = new SqlDataAdapter();
                    sda.SelectCommand = cmd;
                    System.Data.DataTable dt = new System.Data.DataTable();
                    DataSet ds = new DataSet("New_data");
                    ds.Locale = System.Threading.Thread.CurrentThread.CurrentCulture;
                    sda.Fill(dt);
                    ds.Tables.Add(dt);
                    string folder = Directory.GetParent(Directory.GetCurrentDirectory()).FullName + "\\OutPut\\";
                    using (XLWorkbook wb = new XLWorkbook())
                    {
                        if(System.IO.File.Exists(folder + "sample.xlsx"))
                        {
                            Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
                            app.DisplayAlerts = false;
                            app.DefaultSaveFormat = XlFileFormat.xlOpenXMLWorkbook;
                            Excel.Workbook xwb = app.Workbooks.Open(folder + "sample.xlsx", 0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false);
                            Excel.Sheets sheet = xwb.Worksheets;
                            var xlNewSheet = (Excel.Worksheet)sheet.Add(sheet[1], Type.Missing, Type.Missing, Type.Missing);
                            xlNewSheet.Name = "newsheet";
                            // xlNewSheet.Cells[0, 0] = xwb.Worksheets.Add(ds);
                            //xlNewSheet = xwb.Worksheets.Add(dt);
                            xlNewSheet = (Excel.Worksheet)xwb.Worksheets.Add(dt);
                            xlNewSheet = (Excel.Worksheet)xwb.Worksheets.get_Item(1);
                            xlNewSheet.Select();
                            xwb.Save();
                            xwb.Close();
                            releaseObject(xlNewSheet);
                            releaseObject(sheet);
                            releaseObject(xwb);
                            releaseObject(app);
                           
                        }
                        else
                        {
                            wb.Worksheets.Add(dt, "Brands");
                            wb.SaveAs(folder + "sample.xlsx");
                        }

                    }
                    con.Close();
                }
                catch (Exception ec)
                {
                    MessageBox.Show(ec.Message);
                }


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source