asp.net 将DataTable中的数据导出到Excel并下载方法

string WorkSheetName) {

DataTable dtExcel = new DataTable(); OleDbConnection con = new OleDbConnection(GetExcelConnection(FilePath)); OleDbDataAdapter adapter = new

OleDbDataAdapter(\\

//读取 con.Open();

adapter.FillSchema(dtExcel, SchemaType.Mapped);

adapter.Fill(dtExcel); con.Close();

dtExcel.TableName = WorkSheetName; //返回 return dtExcel; }

/// <summary> /// 获取链接字符串 /// </summary>

/// <param

name=\ /// <returns></returns> public string GetExcelConnection(string strFilePath) {

if (!File.Exists(strFilePath)) {

throw new Exception(\指定的Excel文件不存在！\ } return

\strFilePath + \8.0;Imex=1;HDR=Yes;\\\

//@\ //@\ //@\Convert.ToChar(34).ToString() +

//@\Convert.ToChar(34).ToString(); }