using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?Spire.Xls;
using?System.Drawing;

public?partial?class?Analysis?:?System.Web.UI.Page
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????
????????
????}
????protected?void?Btn_Click（object?sender?EventArgs?e）
????{
?Workbook?workbook?=?new?Workbook（）;
????????????workbook.CreateEmptySheets（1）;
????????????Worksheet?sheet?=?workbook.Worksheets[0];

????????????sheet.Name?=?“Design“;
????????????sheet.Range[“A1“].Value?=?“年份“;
????????????sheet.Range[“A2“].Value?=?“2012“;
????????????sheet.Range[“A3“].Value?=?“2013“;
????????????sheet.Range[“A4“].Value?=?“2014“;
????????????sheet.Range[“A5“].Value?=?“2015“;
????????????sheet.Range[“A6“].Value?=?“2016“;
????????????sheet.Range[“A7“].Value?=?“2017“;
????????????sheet.Range[“B1“].Value?=?“銷售量1“;
????????????sheet.Range[“B2“].NumberValue?=?3000;
????????????sheet.Range[“B3“].NumberValue?=?2500;
????????????sheet.Range[“B4“].NumberValue?=?200;
????????????sheet.Range[“B5“].NumberValue?=?150;
????????????sheet.Range[“B6“].NumberValue?=?3000;
????????????sheet.Range[“B7“].NumberValue?=?4900;
????????????sheet.Range[“C1“].Value?=?“產品2“;
????????????sheet.Range[“C2“].NumberValue?=?3800;
????????????sheet.Range[“C3“].NumberValue?=?3200;
????????????sheet.Range[“C4“].NumberValue?=?1700;
????????????sheet.Range[“C5“].NumberValue?=?3500;
????????????sheet.Range[“C6“].NumberValue?=?4500;
????????????sheet.Range[“C7“].NumberValue?=?4300;
????????????
????????????//設計師想查一個ID款式的銷售量（select?year_total?from?Sale?where?name=@name?）
????????????Chart?chart?=?sheet.Charts.Add（ExcelChartType.Line）;
????????????chart.DataRange?=?sheet.Range[“B1:B7“];
????????????chart.SeriesDataFromRange?=?false;
????????????chart.TopRow?=?6;
????????????chart.BottomRow?=?25;
????????????chart.LeftColumn?=?2;
????????????chart.RightColumn?=?9;
????????????chart.Charttitle?=?“年銷售量圖?款式：“;//name
????????????chart.CharttitleArea.IsBold?=?true;
????????????chart.CharttitleArea.Size?=?12;
????????????


????????????
????????????Spire.Xls.Charts.ChartSerie?cs1?=?chart.Series[0];
????????????cs1.CategoryLabels?=?sheet.Range[“A2:A7“];
????????????cs1.TrendLines.Add（TrendLineType.Logarithmic）;
????????????cs1.ErrorBar（true?ErrorBarIncludeType.Plus?ErrorBarType.Percentage?10）;

????????????Chart?chart2?=?sheet.Charts.Add（ExcelChartType.ColumnClustered）;
????????????chart2.DataRange?=?sheet.Range[“B1:C7“];
????????????chart2.SeriesDataFromRange?=?false;
????????????chart2.TopRow?=?600;
????????????chart2.BottomRow?=?2500;
????????????chart2.LeftColumn?=?10;
????????????chart2.RightColumn?=?17;
????????????chart2.Charttitle?=?“duibi“;
????????????chart2.CharttitleArea.IsBold?=?true;
????????????chart2.CharttitleArea.Size?=?12;
????????????Spire.Xls.Charts.ChartSerie?cs2?=?chart2.Series[0];
????????????cs2.CategoryLabels?=?sheet.Range[“A2:A7“];
????????????cs2.Erro

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-02-25?13:07??WebSite4\
?????文件?????????535??2017-06-23?22:38??WebSite4\Analysis.aspx
?????文件????????3500??2017-06-21?23:25??WebSite4\Analysis.aspx.cs
?????目錄???????????0??2017-06-12?09:52??WebSite4\App_Code\
?????文件?????????817??2017-06-12?09:52??WebSite4\App_Code\SqlHelper.cs
?????目錄???????????0??2017-06-21?22:11??WebSite4\Bin\
?????文件??????120320??2017-06-21?22:11??WebSite4\Bin\Spire.Common.dll
?????文件?????????262??2017-06-21?22:11??WebSite4\Bin\Spire.Common.dll.refresh
?????文件????????4731??2017-06-21?22:11??WebSite4\Bin\Spire.Common.xml
?????文件???????55808??2017-06-21?22:11??WebSite4\Bin\Spire.License.dll
?????文件?????????131??2017-06-21?22:11??WebSite4\Bin\Spire.License.dll.refresh
?????文件????15429632??2017-06-21?22:11??WebSite4\Bin\Spire.Pdf.dll
?????文件?????????127??2017-06-21?22:11??WebSite4\Bin\Spire.Pdf.dll.refresh
?????文件?????1170767??2017-06-21?22:11??WebSite4\Bin\Spire.Pdf.xml
?????文件????19324928??2017-06-21?22:11??WebSite4\Bin\Spire.XLS.dll
?????文件?????????127??2017-06-21?22:11??WebSite4\Bin\Spire.XLS.dll.refresh
?????文件??????883873??2017-06-21?22:11??WebSite4\Bin\Spire.XLS.xml
?????文件????????1399??2017-06-29?00:01??WebSite4\Default.aspx
?????文件????????2643??2017-06-29?00:58??WebSite4\Default.aspx.cs
?????文件????????1366??2017-06-29?01:16??WebSite4\Designer.aspx
?????文件????????1518??2017-06-28?23:45??WebSite4\Designer.aspx.cs
?????文件?????????265??2017-06-28?22:11??WebSite4\Html2.html
?????文件????????1039??2017-06-29?01:20??WebSite4\HtmlPage.html
?????目錄???????????0??2017-06-28?22:28??WebSite4\js\
?????文件???????26797??2016-05-18?07:28??WebSite4\js\imagesloaded.js
?????文件???????96383??2014-11-11?22:25??WebSite4\js\jquery-1.11.0.min.js
?????文件???????38742??2016-05-18?07:28??WebSite4\js\jquery.skidder.js
?????文件?????????873??2016-05-18?07:28??WebSite4\js\smartresize.js
?????文件?????????138??2017-06-21?22:11??WebSite4\packages.config
?????目錄???????????0??2018-02-25?13:04??WebSite4\pic\
?????文件??????113471??2017-06-28?23:34??WebSite4\pic\10.jpg
............此處省略25個文件信息