目的：
1.根据模板里面的excel数据信息，动态创建line chart
2.linechart 的样式改为灰色
3.以流的形式写到客户端，不管客户端是否装excel，都可以导出到到客户端
4.使用Aspose.Cells的基本功能
5.使用mvc测试代码
导出到excel里面的效果图
excel里面的数据源sheet2
20012002中原地产10203040507080上海中原308044558890120河北中原24455566889070南京中原44556677889990背景中原11343637333221中原地产210203040507080上海中原3308044558890120上海中原424455566889070上海中原544556677889990上海中原611343637333221上海中原710203040507080上海中原8308044558890120上海中原924455566889070上海中原1044556677889990上海中原1111343637333221中原地产1210203040507080上海中原13308044558890120上海中原1424455566889070上海中原1544556677889990上海中原1611343637333221上海中原1710203040507080上海中原18308044558890120上海中原1924455566889070上海中原2144556677889990上海中原2211343637333221
入口方法：
public ActionResult excels(){WorkbookDesigner designer = new WorkbookDesigner();string path = Server.MapPath("/Templete/11111.xls"); designer.Workbook.Open(path); Workbook workbook = designer.Workbook;//创建一个chart到页面CreateStaticReport1(workbook);designer.Process();//将流文件写到客户端流的形式写到客户端，名称是_report.xlsdesigner.Save("_report.xls", SaveType.OpenInExcel, FileFormatType.Excel, System.Web.HttpContext.Current.Response);Response.Flush();Response.Close();designer = null;// Response.End();return View("getexcel");}
生成chart方法
private void CreateStaticReport1(Workbook workbook){//创建一个折线图workbook.Worksheets[0].Charts.Add(ChartType.Line, 1, 1, 25, 10);Aspose.Cells.Chart chart = workbook.Worksheets[0].Charts[0];//折线区域竖线设置为显示颜色设置为灰色chart.CategoryAxis.MajorGridLines.IsVisible = true;chart.CategoryAxis.MajorGridLines.Color = Color.Gray;//折线区域设置横着的网格线显示 chart.MajorGridLines.IsVisible = true;chart.MajorGridLines.Color = Color.Gray;//设置title样式chart.Title.Text = "Sales By Region For Years";chart.Title.TextFont.Color = Color.Gray;chart.Title.TextFont.IsBold = true;chart.Title.TextFont.Size = 12;//Set Properties of nserieschart.NSeries.Add("Sheet2!B2:H26", false);//Set NSeries Category Datasourcechart.NSeries.CategoryData = "Sheet2!B1:H1";Cells cells = workbook.Worksheets[1].Cells;//loop over the Nseriesefor (int i = 0; i < chart.NSeries.Count; i++){//设置每条折线的名称chart.NSeries[i].Name = cells[i + 1, 0].Value.ToString();//设置线的宽度chart.NSeries[i].Line.Weight = WeightType.MediumLine;//设置每个值坐标点的样式chart.NSeries[i].MarkerStyle = ChartMarkerType.Circle;chart.NSeries[i].MarkerSize = 5;chart.NSeries[i].MarkerBackgroundColor = Color.White;chart.NSeries[i].MarkerForegroundColor = Color.Gray;//每个折线向显示出值chart.NSeries[i].DataLabels.IsValueShown = true;chart.NSeries[i].DataLabels.TextFont.Color = Color.Gray;}//设置x轴上数据的样式为灰色chart.CategoryAxis.TickLabels.Font.Color = Color.Gray; chart.CategoryAxis.TickLabelPosition = TickLabelPositionType.NextToAxis;//设置y轴的样式chart.ValueAxis.TickLabelPosition = TickLabelPositionType.Low;chart.ValueAxis.TickLabels.Font.Color = Color.Gray;// chart.ValueAxis.TickLabels.TextDirection = TextDirectionType.LeftToRight;//设置Legend位置以及样式chart.Legend.Position = LegendPositionType.Bottom;chart.Legend.TextFont.Color = Color.Gray;chart.Legend.Border.Color = Color.Gray;}
