C#

private void barButtonItem5_ItemClick(object sender, ItemClickEventArgs e)
       {
           if (!backgroundWorker1.IsBusy)
           {
               backgroundWorker1.RunWorkerAsync();
           }
       }
       private void CreateSheet(string _sheetName)
       {
           IWorkbook workbook = spreadsheetControl.Document;

           if (workbook.Worksheets.Contains(_sheetName) == false)
           {
               workbook.Worksheets.Add().Name = _sheetName;
           }
               //or
               //workbook.Worksheets.Add("Summarize")
       }
       private void ClearSheet(string _sheetName)
       {
           IWorkbook workbook = spreadsheetControl.Document;
           var keys = new List<string>();
           var values = new List<int>();

           Worksheet ws_summarized = workbook.Worksheets[_sheetName];
           ws_summarized.Clear(workbook.Worksheets[_sheetName].GetUsedRange());
           keys.Clear();
           values.Clear();
       }
       DataTable my_table = new DataTable();
       DataTable my_table2 = new DataTable();
       private void backgroundWorker1_DoWork(object sender, System.ComponentModel.DoWorkEventArgs e)
       {
           IWorkbook workbook = spreadsheetControl.Document;
           Worksheet worksheet = workbook.Worksheets["DataSet1"];
           CellRange range = worksheet.GetDataRange();
           int LastRow = range.BottomRowIndex;
           var keys = new List<string>();
           var values = new List<int>();

           for (int i = 0; i < LastRow + 1; i++)
           {
               if (worksheet.Cells[i, 10].DisplayText == "خاتمه یافته")
               {
                   keys.Add(string.Join(",", worksheet.Cells[i, 28].DisplayText, worksheet.Cells[i, 0].DisplayText, worksheet.Cells[i, 9].DisplayText,
                   worksheet.Cells[i, 15].DisplayText, worksheet.Cells[i, 31].DisplayText));
                   values.Add((int)worksheet.Cells[i, 32].Value.NumericValue);
               }
           }
           if (worksheet.HasData)
           {
               if (spreadsheetBarController1.Control.InvokeRequired)
               {
                   //***Instead of (Action), we can use (MethodInvoker)***
                   spreadsheetBarController1.Control.Invoke((Action)delegate { CreateSheet("Summarized"); });
                   spreadsheetBarController1.Control.Invoke((MethodInvoker)delegate { ClearSheet("Summarized"); });
               }

               var mydic = new Dictionary<string, int>();
               for (int i = 0; i < keys.Count; i++)
               {
                   if (mydic.ContainsKey(keys[i]))
                   {
                       mydic[keys[i]] += values[i];
                   }
                   else
                   {
                       mydic.Add(keys[i], values[i]);
                   }
               }
               keys.Clear();
               values.Clear();
               foreach (var item in mydic.Keys)
               {
                   keys.Add(item);
               }
               foreach (var item in mydic.Values)
               {
                   values.Add(item);
               }

               my_table.Columns.Add("A");
               my_table.Columns.Add("B");
               my_table.Columns.Add("C");
               my_table.Columns.Add("D");
               my_table.Columns.Add("E");

               for (int i = 0; i < mydic.Count; i++)
               {
                   string text = keys[i];
                   string[] rewrite = text.Split(',');

                   my_table.Rows.Add(rewrite[0], rewrite[1], rewrite[2], rewrite[3], rewrite[4]);
               }

               my_table2.Columns.Add("F");
               for (int i = 0; i < mydic.Count; i++)
               {
                   int text = values[i];

                   my_table2.Rows.Add(text);
               }
               backgroundWorker1.ReportProgress(100);
           }
           else
           {
               MessageBox.Show("خطای داده ورودی", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
           }
       }

       private void backgroundWorker1_RunWorkerCompleted(object sender, System.ComponentModel.RunWorkerCompletedEventArgs e)
       {
           progressPanel1.Visible = false;
       }

       private void backgroundWorker1_ProgressChanged(object sender, ProgressChangedEventArgs e)
       {
           IWorkbook workbook = spreadsheetControl.Document;
           Worksheet worksheet = workbook.Worksheets["DataSet1"];
           CellRange range = worksheet.GetDataRange();
           int LastRow = range.BottomRowIndex;

           for (int i = 0; i < my_table.Rows.Count; i++)
           {
               workbook.Worksheets["Summarized"].Cells[i, 0].SetValue(my_table.Rows[i]["A"].ToString());
               workbook.Worksheets["Summarized"].Cells[i, 1].SetValue(my_table.Rows[i]["B"].ToString());
               workbook.Worksheets["Summarized"].Cells[i, 2].SetValue(my_table.Rows[i]["C"].ToString());
               workbook.Worksheets["Summarized"].Cells[i, 3].SetValue(my_table.Rows[i]["D"].ToString());
               workbook.Worksheets["Summarized"].Cells[i, 4].SetValue(my_table.Rows[i]["E"].ToString());
           }
       }

if (!backgroundWorker1.IsBusy)
            {
                backgroundWorker1.RunWorkerAsync();
            }

workbook.Worksheets.Add().Name = "Summarized";

OriginalGriff wrote:

the Add addition is probably coincidental, and you broke something else at the same time

public interface IHazardLocation {}