像这样的 Epplus 导出错误：'System.Data.DataSet'对象类型'System.Data.DataTable'不采用实物。

Question

我想将一个gridview转换为.xls，但它会引发错误，当我单击OK时，它给我"给我"失败了。对象类型" system.data.databable"不使用。"这是我的代码；

我的搜索按钮

        groupBox2.Visible = true;
        SqlConnection baglanti = new SqlConnection("Data Source=.; Initial Catalog=database; Trusted_Connection=yes; MultipleActiveResultSets=True");
        SqlDataAdapter da = new SqlDataAdapter();
        SqlCommand cmd = new SqlCommand();
        DataSet ds = new DataSet();
        baglanti.Open();
        cmd.CommandText = "SELECT * FROM hostes_tablo WHERE ayak_no=" + comboBox7.Text + "";
        da.SelectCommand = cmd;
        cmd.Connection = baglanti;
        da.Fill(ds, "hostes_tablo");
        dataGridView1.DataSource = ds;
        dataGridView1.DataMember = "hostes_tablo";
        baglanti.Close();

我的导出按钮

var saveFileDialog1 = new SaveFileDialog();
        saveFileDialog1.Filter = "Excel File (*.xlsx)|*.xlsx";
        saveFileDialog1.FilterIndex = 1;
        if (saveFileDialog1.ShowDialog() == DialogResult.OK)
        {
            try
            {
                FileInfo file = new FileInfo(saveFileDialog1.FileName);
                if (file.Exists)
                {
                    file.Delete();
                }
                using (ExcelPackage pck = new ExcelPackage(file))
                {
                    ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Sheet1");
                    ws.Cells["A1"].LoadFromDataTable(((DataTable)dataGridView1.DataSource), true);
                    ws.Cells.AutoFitColumns();
                    using (ExcelRange rng = ws.Cells[1, 1, 1, dataGridView1.Columns.Count])
                    {
                        rng.Style.Font.Bold = true;
                        rng.Style.Fill.PatternType = ExcelFillStyle.Solid;
                        rng.Style.Fill.BackgroundColor.SetColor(System.Drawing.Color.FromArgb(79, 129, 189));
                        rng.Style.Font.Color.SetColor(System.Drawing.Color.White);
                    }
                    pck.Save();
                    pck.Dispose();
                }
                MessageBox.Show(string.Format("Excel file "{0}" generated successfully.", file.Name));
            }
            catch (Exception ex)
            {
                MessageBox.Show("Failed to export to Excel. Original error: " + ex.Message);
            }
        }

我搜索然后，当我单击导出按钮时，它给我错误。

Answer 1

你是对的，我从数据集铸造到datatable

 var saveFileDialog1 = new SaveFileDialog();
        saveFileDialog1.Filter = "Excel Dosyası (*.xlsx)|*.xlsx";
        saveFileDialog1.FilterIndex = 1;
        if (saveFileDialog1.ShowDialog() == DialogResult.OK)
        {
            try
            {
                DataSet ds = dataGridView1.DataSource as DataSet;
                if (ds != null)
                {
                    DataTable tbl = ds.Tables["hostes_tablo"];
                    FileInfo file = new FileInfo(saveFileDialog1.FileName);
                    if (file.Exists)
                    {
                        file.Delete();
                    }
                    using (ExcelPackage pck = new ExcelPackage(file))
                    {
                        ExcelWorksheet ws = pck.Workbook.Worksheets.Add("AjansRed Sorgu Sonuç");
                        ws.Cells["A1"].LoadFromDataTable(tbl, true);
                        ws.Cells.AutoFitColumns();
                        ws.Cells[1,dataGridView1.Columns.Count+2].Value = label81.Text.ToString();
                        using (ExcelRange rng = ws.Cells[1, 1, 1, dataGridView1.Columns.Count+1])//ws.cells[from row, from column, to row, to column]. sayıların anlamı
                        {
                            rng.Style.Font.Bold = true;
                            rng.Style.Fill.PatternType = ExcelFillStyle.Solid;
                            rng.Style.Fill.BackgroundColor.SetColor(System.Drawing.Color.FromArgb(79, 129, 189));
                            rng.Style.Font.Color.SetColor(System.Drawing.Color.White);
                        }
                        pck.Save();
                        pck.Dispose();
                    }
                    MessageBox.Show(string.Format(@"Sorgu Sonucunuzu İçeren  ""{0}"" Başarıyla Dışarıya Aktarıldı!", file.Name));
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Hata! Hata! Hata! Excel Dışarı Aktarma Esnasında Sorun Oluştu. Original error: " + ex.Message);
            }
        }

Answer 2

我认为从 DataSet到 DataTable的铸件正在给出错误。您不能将DataSet直接施放到DataTable。

使用下面的代码做到这一点。

BindingSource bs = (BindingSource)dataGridView1.DataSource; 
DataTable dt= (DataTable) bs.DataSource;
 ws.Cells["A1"].LoadFromDataTable(dt, true);