Web DataSet To Excel

该DLL 可以中文DataSet内容导入到Excel中用法如下。 using CarlosAg.ExcelXmlWriter; //导入事件 MHDataSet = (System.Data.DataSet)ViewState["DS"]; ExcelBook eb = new ExcelBook(MHDataSet.Tables["Tables"], "WeldingCheckPointReport"); ExcelBook eb = new ExcelBook(MHDataSet.Tables["Tables"], "WeldingCheckPointReport"); eb.Author = Page.User.Identity.Name;//作者 eb.LastAuthor = Page.User.Identity.Name;//最后作者 eb.Company = "FWC";//公司 eb.Version = "1.0";//版本 ExcelColumnCollection ec = new ExcelColumnCollection();//第一层表头 eb.AddColumnNamesCollection(ec); ec.Add(new ExcelColumn("查询日期:" + SetSearchDate(TxBMonth.Text.Trim()), 2)); ec.Add(new ExcelColumn("生成日期:" + System.DateTime.Now.ToShortDateString(), 2)); ec.Add(new ExcelColumn("制表人:" + Page.User.Identity.Name, 2)); ExcelColumnCollection ec2 = new ExcelColumnCollection();//第二层表头 eb.AddColumnNamesCollection(ec2); ec2.Add(new ExcelColumn("工号")); ec2.Add(new ExcelColumn("姓名")); ec2.Add(new ExcelColumn("工种")); eb.IsAutoFitWidth = true;//自定适用列宽 eb.WriteExcelToClient();//下载Excel文件