//如果单纯是想导出excel,可以移步这里:点击打开链接
//此方法20条数据导出需要10秒左右,效率太低了,有时间需要再优化,关键是能导出图片了。
//先要需要引入Microsoft.Office.Interop.Excel.dll
//申明定义
Microsoft.Office.Interop.Excel.Workbook xlWorkBook;
Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet;
protected void btnDown_Click(object sender, EventArgs e)
{
string strWhere = " flag=1 ";
ds = dal.GetList(strWhere);//取数据
dt = ds.Tables[0];
ImportDataToExcel(dt);
}
#region 导出
private void ImportDataToExcel(DataTable dt)
{
if (dt != null)
{
#region 操作excel
xlWorkBook = new Microsoft.Office.Interop.Excel.Application().Workbooks.Add(Type.Missing);
xlWorkBook.Application.Visible = false;
xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Sheets[1];
//设置标题
xlWorkSheet.Cells[1, 1] = "物品类型";
xlWorkSheet.Cells[1, 2] = "物品名称";
xlWorkSheet.Cells[1, 3] = "颜色";
xlWorkSheet.Cells[1, 4] = "价格/元";
xlWorkSheet.Cells[1, 5] = "重量/克";
xl