实现ASP.NET数据库导出Excel功能，轻松管理数据 (asp.net数据库导出excel文件)

{

oSheet.Cells[i + 2, 1] = dt.Rows[i][“ID”].ToString();

oSheet.Cells[i + 2, 2] = dt.Rows[i][“Name”].ToString();

oSheet.Cells[i + 2, 3] = dt.Rows[i][“Gender”].ToString();

oSheet.Cells[i + 2, 4] = dt.Rows[i][“Age”].ToString();

oSheet.Cells[i + 2, 5] = dt.Rows[i][“Class”].ToString();

oSheet.Cells[i + 2, 6] = dt.Rows[i][“Grade”].ToString();

}

“`

5.输出Excel文件

利用.NET中的Response类，将Excel文件输出到用户端，以下是完整代码：

“`

oBook.SaveAs(filePath, Excel.XlFileFormat.xlWorkbookNormal);

oBook.Close(true, Missing.Value, Missing.Value);

oApp.Quit();

FileInfo fi = new FileInfo(filePath);

Response.Clear();

Response.Charset = “GB2312”;

Response.ContentEncoding = Encoding.UTF8;

Response.AddHeader(“Content-Disposition”, “attachment; filename=” + HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8));

Response.AddHeader(“Content-Length”, fi.Length.ToString());

Response.ContentType = “application/ms-excel”;

Response.WriteFile(filePath);

Response.End();

“`

三、导出Excel的注意事项

1.确保Excel模板和导出代码中的字段名称一致，否则数据无法正确填充到Excel模板中。

2.导出的Excel文件必须是.xls或.xlsx格式，否则用户无法正常打开文件。

3.确保服务器上安装了Excel应用程序，并且用户的操作系统支持Excel的安装。

四、

在ASP.NET中实现数据库导出Excel功能是一项十分重要的任务，它可以大大提高企业数据管理的效率和灵活性。通过本文的介绍，我们清楚了实现该功能的基本思路和具体步骤，也了解了导出Excel文件的注意事项。相信读者在实践中能够更好地运用这项技术，轻松管理数据，提高工作效率。

相关问题拓展阅读：

• asp.net 导出Excel

asp.net 导出Excel

用PageOffice 很简单，网上搜有很多示例代码

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using MyExcel;

using Excel;

using System.Drawing;

using System.IO;

using System.Data.SqlClient;

using System.Reflection;

namespace ExcelManager

{

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

///

/// 导出到EXCEL文件

///

///

///

protected void btnDaoChu_Click(object sender, EventArgs e)

{

string save_path = “”;

string tick = “”;

string temp_path = Server.MapPath(“Xls_Files”);

string template_path = Server.MapPath(“Xls_Template”);

if (!Directory.Exists(temp_path))

{

Directory.CreateDirectory(temp_path);

Directory.CreateDirectory(template_path);

}

MyExcel.ExcelManager myExcel = new MyExcel.ExcelManager();

#region 打开模手敬空板

myExcel.OpenNewTemplate(template_path + “\\Excel测试.xlsx”);

myExcel.SetActiveSheet(1);//稿梁设毕瞎置为当前EXCEL

_Worksheet worksheet1 = myExcel.Sheet;

System.Data.DataTable dt1 = GetTable();

for (Int32 i = 0; i

{

worksheet1.Cells = dt1.Rows.ToString();

worksheet1.Cells = dt1.Rows.ToString();

myExcel.SetBgColor(worksheet1.Cells, worksheet1.Cells, Color.Green);//背景色

myExcel.SetHAlign(worksheet1.Cells, worksheet1.Cells, XlHAlign.xlHAlignRight);//对齐

}

#endregion

#region 插入第2张表

//_Worksheet worksheet = (_Worksheet)myExcel.Sheets.Add(Missing.Value, myExcel.Sheet, Missing.Value, Missing.Value);

_Worksheet worksheet = myExcel.InsertSheet(myExcel.Sheet,false);//插入第2张工作表

worksheet.Name = “EXCEL”; //设置工作表名

myExcel.SetActiveSheet(2); //设置为当前EXCEL

myExcel.Merge(worksheet.Cells, worksheet.Cells);//横合并单元格

myExcel.WriteRange(worksheet.Cells, worksheet.Cells, “导出测试”); //写区域

myExcel.SetFontBold(worksheet.Cells, worksheet.Cells);//黑体

myExcel.SetBgColor(worksheet.Cells, worksheet.Cells, Color.Red);//背景色

myExcel.SetHAlign(worksheet.Cells, worksheet.Cells, XlHAlign.xlHAlignCenter); //水平对齐

myExcel.SetBorder(worksheet.Cells, worksheet.Cells, Color.Black, XlBordersIndex.xlEdgeBottom, XlBordersIndex.xlEdgeRight);//边框

worksheet.Cells = “序号”;//写标题

worksheet.Cells = “公司”;

worksheet.Cells = “部门”;

System.Data.DataTable dt = GetTable();

int rowNum = 0;

for (Int32 i = 0; i

{

rowNum = i + 1;

worksheet.Cells = rowNum;

worksheet.Cells = dt.Rows.ToString();

worksheet.Cells = dt.Rows.ToString();

myExcel.SetFontBold(worksheet.Cells, worksheet.Cells);//黑体

myExcel.SetBgColor(worksheet.Cells, worksheet.Cells, Color.Green);//背景色

myExcel.SetHAlign(worksheet.Cells, worksheet.Cells, XlHAlign.xlHAlignCenter);//对齐

//设置边框全部的

myExcel.SetBorder(worksheet.Cells, worksheet.Cells, Color.Yellow, XlBordersIndex.xlEdgeLeft, XlBordersIndex.xlEdgeRight, XlBordersIndex.xlEdgeTop, XlBordersIndex.xlEdgeBottom, XlBordersIndex.xlInsideVertical, XlBordersIndex.xlInsideHorizontal);

myExcel.SetColumnWidth(worksheet.Cells, 30);//设置列宽

myExcel.SetRowHeight(worksheet.Cells, 50);//设置行高

myExcel.SetColumnWidth(worksheet.Cells, 60);

myExcel.SetColumnWidth(worksheet.Cells, 90);

}

myExcel.Merge(worksheet.Cells, worksheet.Cells); //竖合并

myExcel.WriteRange(worksheet.Cells, worksheet.Cells, “haha”);//写单元格,特别在2个单元格相同

myExcel.WriteRange(worksheet.Cells, worksheet.Cells, “woria”);//写区域

myExcel.WriteCell(worksheet.Cells, “wo”); //写单元格

#endregion

tick = DateTime.Now.Ticks.ToString();

save_path = temp_path + “\\” + tick + “.xlsx”;//保存路径

myExcel.SaveAsExcel(save_path); //保存到服务器

myExcel.CloseExcel();//清理释放资源

OpenExcel(save_path);//打开服务器EXCEL文件,这里是关键拉.

}

private void OpenExcel(string save_path)

{

FileInfo file = new FileInfo(save_path);

Response.Clear();

Response.Charset = “GB2312”;

Response.ContentEncoding = System.Text.Encoding.UTF8;

Response.AddHeader(“Content-Disposition”, “attachment; filename=” + Server.UrlEncode(file.Name));

Response.AddHeader(“Content-Length”, file.Length.ToString());

Response.ContentType = “application/ms-excel”;

Response.WriteFile(file.FullName);

Response.Flush();

//删除文件

if (File.Exists(save_path))

{

File.Delete(save_path);

}

Response.End();

}

private System.Data.DataTable GetTable()

{

string sql = “select * from tb_Comapany”;

string connection = ConfigurationManager.AppSettings.ToString();

SqlConnection conn = new SqlConnection(connection);

conn.Open();

SqlCommand cmd = new SqlCommand(sql, conn);

SqlDataAdapter sdr = new SqlDataAdapter(cmd);

System.Data.DataSet ds = new System.Data.DataSet();

sdr.Fill(ds);

return ds.Tables;

}

}

}

关键是思路吧.首先写EXCEL文件,保存到服务器上,最后打开保存对话框,

最后把EXCEL文件删除.

这篇文章会对你有很耐侍册大的帮助 将谈闹数昌宏据导出到EXCEl

和导出到access一个薯败闷样，就是连接access和连接excel的字符串不一样数弯。其他基本完全相同。枯冲

asp.net数据库导出excel文件的介绍就聊到这里吧，感谢你花时间阅读本站内容，更多关于asp.net数据库导出excel文件,实现ASP.NET数据库导出Excel功能，轻松管理数据,asp.net 导出Excel的信息别忘了在本站进行查找喔。