using Spire.Xls;
using Spire.Xls.Charts;
using System.Drawing;

public class ColumnChartCreator
{
    public static void CreateSimpleColumnChart(string filePath)
    {
        // 1. 新建一個Excel工作簿和工作表
        Workbook workbook = new Workbook();
        Worksheet sheet = workbook.Worksheets[0];
        sheet.Name = "產(chǎn)品銷售數(shù)據(jù)";

        // 2. 向工作表中寫入適合柱狀圖演示的樣本數(shù)據(jù)
        // 數(shù)據(jù)標(biāo)題
        sheet.Range["A1"].Text = "產(chǎn)品";
        sheet.Range["B1"].Text = "銷售額 (萬元)";
        
        // 數(shù)據(jù)內(nèi)容
        sheet.Range["A2"].Text = "產(chǎn)品A";
        sheet.Range["B2"].NumberValue = 120.5;

        sheet.Range["A3"].Text = "產(chǎn)品B";
        sheet.Range["B3"].NumberValue = 150.0;

        sheet.Range["A4"].Text = "產(chǎn)品C";
        sheet.Range["B4"].NumberValue = 90.7;

        sheet.Range["A5"].Text = "產(chǎn)品D";
        sheet.Range["B5"].NumberValue = 180.2;

        // 自動調(diào)整列寬
        sheet.AutoFitColumn(1);
        sheet.AutoFitColumn(2);

        // 3. 使用Spire.XLS API創(chuàng)建柱狀圖
        // 將圖表添加到工作表，并指定其位置和大小（左上角行、列，右下角行、列）
        Chart chart = sheet.Charts.Add(6, 1, 20, 8); // 從F1開始，到T8結(jié)束的區(qū)域

        // 設(shè)置圖表類型為簇狀柱形圖
        chart.ChartType = ChartType.ColumnClustered;

        // 4. 設(shè)置圖表的數(shù)據(jù)源范圍
        // 數(shù)據(jù)范圍包括標(biāo)題行，以便自動識別系列名稱和類別標(biāo)簽
        chart.DataRange = sheet.Range["A1:B5"];
        chart.Series.CategoryLabels = sheet.Range["A2:A5"]; // 設(shè)置類別標(biāo)簽（產(chǎn)品名稱）

        // 添加數(shù)據(jù)系列
        ChartSeries series = chart.Series.Add("銷售額 (萬元)");
        series.Values = sheet.Range["B2:B5"]; // 設(shè)置系列值（銷售額）
        series.Format.Fill.ForeColor = Color.DarkCyan; // 設(shè)置柱子顏色

        // 5. 添加圖表標(biāo)題、系列名稱、X/Y軸標(biāo)題
        chart.ChartTitle.Text = "各產(chǎn)品銷售額對比";
        chart.ChartTitle.Font.IsBold = true;
        chart.ChartTitle.Font.Size = 12;

        chart.PrimaryCategoryAxis.Title.Text = "產(chǎn)品類別";
        chart.PrimaryValueAxis.Title.Text = "銷售額 (萬元)";
        
        // 顯示數(shù)據(jù)標(biāo)簽
        chart.Series[0].DataPoints.DefaultDataPoint.DataLabels.HasValue = true;
        chart.Series[0].DataPoints.DefaultDataPoint.DataLabels.Position = DataLabelPositionType.OutsideEnd;

        // 隱藏圖例（因?yàn)橹挥幸粋€系列，圖例意義不大）
        chart.HasLegend = false;

        // 6. 將圖表嵌入到工作表中的指定位置（已在Add方法中指定）

        // 7. 保存Excel文件
        workbook.SaveToFile(filePath, ExcelVersion.Version2016);
        System.Diagnostics.Process.Start(filePath); // 打開文件查看效果
    }
}

using Spire.Xls;
using Spire.Xls.Charts;
using System.Drawing;

public class LineChartCreator
{
    public static void CreateLineChart(string filePath)
    {
        Workbook workbook = new Workbook();
        Worksheet sheet = workbook.Worksheets[0];
        sheet.Name = "月度業(yè)績數(shù)據(jù)";

        // 寫入適合折線圖演示的樣本數(shù)據(jù)
        sheet.Range["A1"].Text = "月份";
        sheet.Range["B1"].Text = "銷售額 (萬元)";
        sheet.Range["C1"].Text = "利潤 (萬元)";

        string[] months = { "一月", "二月", "三月", "四月", "五月", "六月" };
        double[] sales = { 100, 110, 105, 120, 130, 125 };
        double[] profits = { 30, 35, 32, 40, 45, 42 };

        for (int i = 0; i < months.Length; i++)
        {
            sheet.Range[i + 2, 1].Text = months[i];
            sheet.Range[i + 2, 2].NumberValue = sales[i];
            sheet.Range[i + 2, 3].NumberValue = profits[i];
        }
        sheet.AutoFitColumns();

        // 創(chuàng)建折線圖
        Chart chart = sheet.Charts.Add(9, 1, 23, 9);
        chart.ChartType = ChartType.Line;
        chart.DataRange = sheet.Range["A1:C7"];
        chart.Series.CategoryLabels = sheet.Range["A2:A7"];

        // 添加銷售額系列
        ChartSeries salesSeries = chart.Series.Add("銷售額 (萬元)");
        salesSeries.Values = sheet.Range["B2:B7"];
        salesSeries.Border.Color = Color.Blue; // 設(shè)置線條顏色
        salesSeries.Format.Line.Weight = 2; // 設(shè)置線條粗細(xì)
        salesSeries.Format.Line.DashStyle = ChartLineDashStyleType.Solid;
        salesSeries.Format.MarkerStyle = ChartMarkerType.Circle; // 設(shè)置標(biāo)記點(diǎn)樣式
        salesSeries.Format.MarkerSize = 6;

        // 添加利潤系列
        ChartSeries profitSeries = chart.Series.Add("利潤 (萬元)");
        profitSeries.Values = sheet.Range["C2:C7"];
        profitSeries.Border.Color = Color.DarkGreen;
        profitSeries.Format.Line.Weight = 2;
        profitSeries.Format.Line.DashStyle = ChartLineDashStyleType.Dash;
        profitSeries.Format.MarkerStyle = ChartMarkerType.Diamond;
        profitSeries.Format.MarkerSize = 6;

        chart.ChartTitle.Text = "月度銷售額與利潤趨勢";
        chart.ChartTitle.Font.IsBold = true;
        chart.PrimaryCategoryAxis.Title.Text = "月份";
        chart.PrimaryValueAxis.Title.Text = "金額 (萬元)";
        
        // 顯示圖例
        chart.HasLegend = true;
        chart.Legend.Position = LegendPositionType.Bottom;

        workbook.SaveToFile(filePath, ExcelVersion.Version2016);
        System.Diagnostics.Process.Start(filePath);
    }
}

using Spire.Xls;
using Spire.Xls.Charts;
using System.Drawing;

public class PieChartCreator
{
    public static void CreatePieChart(string filePath)
    {
        Workbook workbook = new Workbook();
        Worksheet sheet = workbook.Worksheets[0];
        sheet.Name = "市場份額數(shù)據(jù)";

        // 寫入適合餅圖演示的樣本數(shù)據(jù)
        sheet.Range["A1"].Text = "產(chǎn)品類別";
        sheet.Range["B1"].Text = "市場份額 (%)";

        sheet.Range["A2"].Text = "電子產(chǎn)品";
        sheet.Range["B2"].NumberValue = 35;

        sheet.Range["A3"].Text = "服裝鞋帽";
        sheet.Range["B3"].NumberValue = 25;

        sheet.Range["A4"].Text = "家居用品";
        sheet.Range["B4"].NumberValue = 20;

        sheet.Range["A5"].Text = "食品飲料";
        sheet.Range["B5"].NumberValue = 15;

        sheet.Range["A6"].Text = "其他";
        sheet.Range["B6"].NumberValue = 5;
        sheet.AutoFitColumns();

        // 創(chuàng)建餅圖
        Chart chart = sheet.Charts.Add(8, 1, 22, 9);
        chart.ChartType = ChartType.Pie;
        chart.DataRange = sheet.Range["A1:B6"];
        chart.Series.CategoryLabels = sheet.Range["A2:A6"];

        ChartSeries series = chart.Series.Add("市場份額 (%)");
        series.Values = sheet.Range["B2:B6"];

        chart.ChartTitle.Text = "各產(chǎn)品類別市場份額";
        chart.ChartTitle.Font.IsBold = true;

        // 進(jìn)階：顯示數(shù)據(jù)標(biāo)簽和百分比
        series.DataPoints.DefaultDataPoint.DataLabels.HasValue = true;
        series.DataPoints.DefaultDataPoint.DataLabels.HasPercentage = true;
        series.DataPoints.DefaultDataPoint.DataLabels.Position = DataLabelPositionType.BestFit;
        series.DataPoints.DefaultDataPoint.DataLabels.SeparatorValue = "\n"; // 值和百分比之間換行

        chart.HasLegend = true;
        chart.Legend.Position = LegendPositionType.Right;

        workbook.SaveToFile(filePath, ExcelVersion.Version2016);
        System.Diagnostics.Process.Start(filePath);
    }
}