ASP.NET MVC 導(dǎo)出Word報表
更新時間：2017年02月27日 11:12:23 作者：轉(zhuǎn)角VV
本文主要介紹了ASP.NET MVC 導(dǎo)出Word報表的方法，具有很好的參考價值，下面跟著小編一起來看下吧
最近要做MVC導(dǎo)出Word報表功能。查了查資料發(fā)現(xiàn)一個好用的插件就是Aspose.Word。這個插件也很有名氣,也很好用。
1.首先就是引用該插件
2.填充Word模版
3.后臺操作
private List<double> QuaterAirPM10AvgVolReport(string stns, DateTime start, DateTime end, Aspose.Words.DocumentBuilder builder, out DataTable dt, out List<double> widthList,string isMax)
{
dt = QuaterPM10AvgVol (stns, start, end,isMax);
widthList = new List<double>();
double[] colWidth = new double[] { 50, 118, 117, 50, 118, 117 };
string[] colName = new string[] { "排序", "城市", start.Year + "年" + start.Month + "～"+end.Month+"月濃度(μg/m3)", "排序", "城市", "較" + start.AddYears(-1).Year + "年同期增幅" };
builder.MoveToBookmark("table3");
Aspose.Words.Tables.Table table = builder.StartTable();//開始畫Table
builder.InsertCell();
builder.CellFormat.Borders.LineStyle = LineStyle.Single;
builder.CellFormat.Borders.Color = System.Drawing.Color.Black;
builder.CellFormat.VerticalMerge = CellMerge.First;
builder.CellFormat.Width = 285;
builder.ParagraphFormat.Alignment = ParagraphAlignment.Center;
// builder.CellFormat.VerticalAlignment = Aspose.Words.Tables.CellVerticalAlignment.Center;
builder.Write("按平均濃度排序");
builder.InsertCell();
builder.CellFormat.Borders.LineStyle = LineStyle.Single;
builder.CellFormat.Borders.Color = System.Drawing.Color.Black;
builder.ParagraphFormat.Alignment = ParagraphAlignment.Center;
// builder.CellFormat.VerticalAlignment = Aspose.Words.Tables.CellVerticalAlignment.Center;
builder.CellFormat.VerticalMerge = CellMerge.None;
builder.CellFormat.Width = 285;
builder.Write("按" + start.AddYears(-1).Year + "年同期增幅排序");
builder.EndRow();
AsposeCreateCell(builder, colWidth[0], colName[0]);
AsposeCreateCell(builder, colWidth[1], colName[1]);
AsposeCreateCell(builder, colWidth[2], colName[2]);
AsposeCreateCell(builder, colWidth[3], colName[3]);
AsposeCreateCell(builder, colWidth[4], colName[4]);
AsposeCreateCell(builder, colWidth[5], colName[5]);
builder.EndRow();
//開始添加值
for (var i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["CityName"] == "12個考核地市" || dt.Rows[i]["CityName"] == "全省")
{
builder.InsertCell();
builder.CellFormat.Borders.LineStyle = LineStyle.Single;
builder.CellFormat.Borders.Color = System.Drawing.Color.Black;
builder.CellFormat.VerticalMerge = CellMerge.First;
builder.CellFormat.Width = 168;
builder.ParagraphFormat.Alignment = ParagraphAlignment.Center;
builder.Write(dt.Rows[i]["CityName"].ToString());
builder.InsertCell();
builder.CellFormat.Borders.LineStyle = LineStyle.Single;
builder.CellFormat.Borders.Color = System.Drawing.Color.Black;
builder.ParagraphFormat.Alignment = ParagraphAlignment.Center;
builder.CellFormat.VerticalMerge = CellMerge.None;
builder.CellFormat.Width = 117;
builder.Write(dt.Rows[i]["PM10ATI"].ToString());
builder.InsertCell();
builder.CellFormat.Borders.LineStyle = LineStyle.Single;
builder.CellFormat.Borders.Color = System.Drawing.Color.Black;
builder.ParagraphFormat.Alignment = ParagraphAlignment.Center;
builder.CellFormat.VerticalMerge = CellMerge.None;
builder.CellFormat.Width = 168;
builder.Write(dt.Rows[i]["qnCityName"].ToString());
builder.InsertCell();
builder.CellFormat.Borders.LineStyle = LineStyle.Single;
builder.CellFormat.Borders.Color = System.Drawing.Color.Black;
builder.ParagraphFormat.Alignment = ParagraphAlignment.Center;
builder.CellFormat.VerticalMerge = CellMerge.None;
builder.CellFormat.Width = 117;
builder.Write(dt.Rows[i]["tqbh"].ToString() + "%");
}
else
{
AsposeCreateCell(builder, colWidth[0], dt.Rows[i]["Sort"].ToString());
AsposeCreateCell(builder, colWidth[1], dt.Rows[i]["CityName"].ToString());
AsposeCreateCell(builder, colWidth[2], dt.Rows[i]["PM10ATI"].ToString());
AsposeCreateCell(builder, colWidth[3], dt.Rows[i]["qnSort"].ToString());
AsposeCreateCell(builder, colWidth[4], dt.Rows[i]["qnCityName"].ToString());
AsposeCreateCell(builder, colWidth[5], dt.Rows[i]["tqbh"].ToString() + "%");
}
builder.EndRow();
}
builder.EndTable();
return widthList;
}
其中有幾個注意的地方 builder.CellFormat.VerticalMerge = CellMerge.None;CellMerge是枚舉類型，經(jīng)常用到畫復(fù)雜的表格，或者是合并單元格。還有First和Previous。先要得到DataTable數(shù)據(jù)，最后對數(shù)據(jù)進(jìn)行操作就行了。
4.輸出文檔
public JsonResult QuaterResponse()
{
bool result;
string quarter = Request["quarter"].ToString();
string stns = Request["stns"].ToString();
string isMax = Request["ismax"].ToString();
DateTime startTime = Convert.ToDateTime(Request["startdate"]);
DateTime endTime = Convert.ToDateTime(Request["enddate"]);
string tmppath = Server.MapPath("~/Document/Model/QuaterReport.docx");
string path = Server.MapPath("~/Document/Export/QuaterReport.doc");
Aspose.Words.Document doc = new Document(tmppath);
Aspose.Words.DocumentBuilder builder = new DocumentBuilder(doc);
doc.Range.Bookmarks["title"].Text = startTime.Year+"年"+quarter+"湖北省環(huán)境空氣質(zhì)量監(jiān)測情況綜述";
doc.Range.Bookmarks["title1"].Text = "表1 "+quarter+"空氣質(zhì)量等級";
doc.Range.Bookmarks["title2"].Text = "表2" +quarter+"優(yōu)良天數(shù)達(dá)標(biāo)率情況表";
doc.Range.Bookmarks["title3"].Text = "表3 "+quarter+"空氣可吸入顆粒物（PM10）平均濃度情況表";
doc.Range.Bookmarks["title4"].Text = "表4 "+quarter+"空氣可吸入顆粒物（PM2.5）平均濃度情況表";
doc.Range.Bookmarks["title5"].Text = "表5"+quarter+" 境空氣氣態(tài)污染物平均濃度情況表";
doc.Range.Bookmarks["title6"].Text = "表6 "+quarter+"環(huán)境空氣質(zhì)量綜合指數(shù)情況表";
DataTable dt;
List<double> widthList;
try
{
doc.Range.Bookmarks["table1"].Text = ""; // 清掉標(biāo)示
QuaterAirPerencetReport( stns, startTime, endTime, builder, out dt, out widthList,isMax);
doc.Range.Bookmarks["table2"].Text = "";
QuaterAirYldblReport(stns, startTime, endTime, builder,quarter, out dt, out widthList,isMax);
doc.Range.Bookmarks["table3"].Text = "";
QuaterAirPM10AvgVolReport(stns, startTime, endTime, builder, out dt, out widthList,isMax);
doc.Range.Bookmarks["table4"].Text = "";
QuaterAirPM25AvgVolReport(stns, startTime, endTime, builder, out dt, out widthList,isMax);
doc.Range.Bookmarks["table5"].Text = "";
QuaterOtherAvgVolReport(stns, startTime, endTime, builder, out dt, out widthList,isMax);
doc.Range.Bookmarks["table6"].Text = "";
QuaterZHIndexReport(stns, startTime, endTime, builder, out dt, out widthList,isMax);
doc.Save(path, Aspose.Words.SaveFormat.Doc);
// System.Diagnostics.Process.Start(path);//打開文檔
// return View("QuaterReport");
result = true;
}
catch (Exception)
{
result = false;
}
return Json(result);
}
以上就是本文的全部內(nèi)容，希望本文的內(nèi)容對大家的學(xué)習(xí)或者工作能帶來一定的幫助，同時也希望多多支持腳本之家！
相關(guān)文章
Asp.net基于ajax和jquery-ui實現(xiàn)進(jìn)度條
這篇文章主要介紹了Asp.net基于ajax和jquery-ui實現(xiàn)進(jìn)度條,文中通過示例代碼介紹的非常詳細(xì)，對大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價值,需要的朋友可以參考下2020-12-12
基于MVC4+EasyUI的Web開發(fā)框架之附件上傳組件uploadify的使用
這篇文章主要介紹了基于MVC4+EasyUI的Web開發(fā)框架之附件上傳組件uploadify的使用,需要的朋友可以參考下2017-08-08
asp.net 保存、修改沒有 runat=server控件的控件值的一個解決方案
asp.net 保存、修改沒有 runat=server控件的控件值的一個解決方案,需要的朋友可以參考下。2011-10-10
我最新一直在和新手和入手級開發(fā)人員打交道，我注意到一些開發(fā)人員（甚至是老手）在粗心時常犯的錯誤。這些錯誤各不相同，從工具的使用到網(wǎng)絡(luò)服務(wù)的適當(dāng)應(yīng)用都有。以下是六個主要的開發(fā)錯誤。2009-03-03
這篇文章介紹了ASP.NET Core使用NLog記錄日志的方法，對大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價值，需要的朋友們下面隨著小編來一起學(xué)習(xí)學(xué)習(xí)吧2022-03-03
RichTextBox 顯示圖片和word的代碼，需要的朋友可以參考一下2013-02-02
好多朋友想學(xué)習(xí)后臺編程語言，但請注意的事，學(xué)習(xí)后臺是個循序漸進(jìn)的過程，不可能一下就到位，其實不只是asp.net其它的編程語言都需要下面的一些知識。2009-06-06
.net 運用二進(jìn)制位運算進(jìn)行數(shù)據(jù)庫權(quán)限管理
.net 運用二進(jìn)制位運算進(jìn)行數(shù)據(jù)庫權(quán)限管理 ，需要的朋友可以參考一下2013-02-02
近幾天對DataSet的新認(rèn)識...2007-04-04
asp.net repeater實現(xiàn)批量刪除時注冊多選框id到客戶端
repeater批量刪除時注冊多選框id到客戶端的實現(xiàn)代碼2008-11-11