Hi, I've created a simple database windows form app using LINQ to SQL. Can I use LINQ to SQL to export Datatable to Excel from Database using spire.XLS?
I've uploaded my project, if that helps
private void ExportToExcel_Click(object sender, EventArgs e)
{
Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
//Export datatable to excel
sheet.InsertDataTable((DataTable)this.dataGridView1.DataSource, true, 1, 1, -1, -1);
sheet.AllocatedRange.AutoFitColumns();
sheet.AllocatedRange.AutoFitRows();
//Save the file
workbook.SaveToFile("result.xlsx", ExcelVersion.Version2013);
}
sheet.InsertDataTable((DataTable)this.dataGridView1.DataSource, true, 1, 1, -1, -1);
private void ExportToExcel_Click(object sender, EventArgs e)
{
Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
//Convert data from datagridview to datatable
DataTable dt=GetDgvToTable(this.dataGridView1);
//Export datatable to excel
sheet.InsertDataTable(dt, true, 1, 1, -1, -1);
sheet.AllocatedRange.AutoFitColumns();
sheet.AllocatedRange.AutoFitRows();
workbook.SaveToFile("result.xlsx", ExcelVersion.Version2013);
}
public DataTable GetDgvToTable(DataGridView dgv)
{
DataTable dt = new DataTable();
//Column
for (int count = 0; count < dgv.Columns.Count; count++)
{
DataColumn dc = new DataColumn(dgv.Columns[count].Name.ToString());
dt.Columns.Add(dc);
}
//Row
for (int count = 0; count < dgv.Rows.Count; count++)
{
DataRow dr = dt.NewRow();
for (int countsub = 0; countsub < dgv.Columns.Count; countsub++)
{
dr[countsub] = Convert.ToString(dgv.Rows[count].Cells[countsub].Value);
}
dt.Rows.Add(dr);
}
return dt;
}