C#

Bruce Greene wrote:

My question is - how important is it that I drop

var wordApp = new Microsoft.Office.Interop.Word.Application();
            wordApp.Visible = false;
            Document wordDoc1 = wordApp.Documents.Add();
            Document wordDoc1a = wordApp.Documents.Add();
            Document wordDoc2 = wordApp.Documents.Open(@"c:\users\robertsf\desktop\doc2.docx",
                false, false, false, "", "", false, "", "", WdOpenFormat.wdOpenFormatAuto,
                MsoEncoding.msoEncodingUTF8, false, false, none, none, none);

private void MyOtherButton_Click(object sender, EventArgs e)
    {
    DataTable dataTable = new DataTable();

    foreach (DataGridViewColumn col in myDataGridView.Columns)
        {
        dataTable.Columns.Add(col.Name);
        }

    foreach (DataGridViewRow row in myDataGridView.Rows)
        {
        DataRow drow = dataTable.NewRow();
        foreach (DataGridViewCell cell in row.Cells)
            {
            drow[cell.OwningColumn.Name] = cell.Value;
            }
        // The drow (DataRow) has all the Data in its ItemArray property but it does not get saved into the datatable row.
        dataTable.Rows.Add(drow);
        dataTable.AcceptChanges();
        //The columns load but the data rows do not add or import

        }
    MyOtherDataGridView.DataSource = dataTable;
    }

if (myDGV.DataSource is BindingSource bs)
   {
   if (bs.DataSource is DataTable dt)
      {
      ... use the Datatable in dt here ...
      }
   }

private void saveToolStripMenuItem_Click(object sender, EventArgs e)
   {
       //      var dia = new System.Windows.Forms.SaveFileDialog();
       saveFileDialog1.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
       saveFileDialog1.Filter = "Excel Worksheets (*.xlsx)|*.xlsx|xls file (*.xls)|*.xls|All files (*.*)|*.*";
       saveFileDialog1.FileName = "";



       if (dataGridView1.DataSource is BindingSource SBind)   //bs)
       {
           if (SBind.DataSource is DataTable dataTable)
           {
               using (ExcelPackage package = new ExcelPackage())
               {
                   if (saveFileDialog1.ShowDialog() != DialogResult.Cancel)
                   {
                       try
                       {
                           ExcelWorksheet ws = package.Workbook.Worksheets.Add("Countries");
                           ws.Cells["A1"].LoadFromDataTable(dataTable, true);
                           package.SaveAs(new FileInfo(saveFileDialog1.FileName));
                       }
                       catch (Exception)
                       {
                           DialogResult reminder = MessageBox.Show("Cannot save file, file opened in another program.\nClose it first! ", "Save Failed", MessageBoxButtons.OK);
                       }
                   }
               }
           }
       }

   }