ASP.NET MVC 導出Word報表

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;
 }

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+"湖北省環境空氣質量監測情況綜述";
 doc.Range.Bookmarks["title1"].Text = "表1 "+quarter+"空氣質量等級";
 doc.Range.Bookmarks["title2"].Text = "表2" +quarter+"優良天數達標率情況表";
 doc.Range.Bookmarks["title3"].Text = "表3 "+quarter+"空氣可吸入顆粒物（PM10）平均濃度情況表";
 doc.Range.Bookmarks["title4"].Text = "表4 "+quarter+"空氣可吸入顆粒物（PM2.5）平均濃度情況表";
 doc.Range.Bookmarks["title5"].Text = "表5"+quarter+" 境空氣氣態污染物平均濃度情況表";
 doc.Range.Bookmarks["title6"].Text = "表6 "+quarter+"環境空氣質量綜合指數情況表";
 DataTable dt;
 List<double> widthList;
 try
 {
 doc.Range.Bookmarks["table1"].Text = ""; // 清掉標示 
 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);
 }