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

//創建一個Workbook類對象并加載Excel文檔Workbook workbook = new Workbook();workbook.LoadFromFile(@"C:/Users/Administrator/Desktop/Sample.xlsx"); //獲取第一個工作表，在特定單元格添加文本并設置格式Worksheet sheet = workbook.Worksheets[0];sheet.Range["H2"].Text = "外貿進/出口額走勢";sheet.Range["H2"].Style.Font.FontName = "Arial Narrow";sheet.Range["H2"].Style.Font.Color = Color.Black;sheet.Range["A1:H5"].Columns[7].ColumnWidth = 15F;sheet.Range["H2"].Style.Font.IsBold = true;sheet.Range["H2:H5"].BorderInside(LineStyleType.Thin);sheet.Range["H2:H5"].BorderAround(LineStyleType.Thin);//添加折線迷你圖SparklineGroup sparklineGroup1 = sheet.SparklineGroups.AddGroup();sparklineGroup1.SparklineType = SparklineType.Line;//設置折折線迷你圖格式sparklineGroup1.SparklineColor = Color.Tomato;sparklineGroup1.HighPointColor = Color.Red;//設置添加折現迷你圖表的單元格以及圖表生成的數據范圍SparklineCollection sparklines1 = sparklineGroup1.Add();sparklines1.Add(sheet["B3:G3"], sheet["H3"]);//添加柱形迷你圖并設置圖表顏色SparklineGroup sparklineGroup2 = sheet.SparklineGroups.AddGroup();sparklineGroup2.SparklineType = SparklineType.Column;sparklineGroup2.SparklineColor = Color.PaleGreen;sparklineGroup2.HighPointColor = Color.SeaGreen;//設置添加柱形迷你圖表的單元格以及圖表生成的數據范圍SparklineCollection sparklines2 = sparklineGroup2.Add();sparklines2.Add(sheet["B4:G4"], sheet["H4"]);//添加盈虧迷你圖并設置顏色SparklineGroup sparklineGroup3 = sheet.SparklineGroups.AddGroup();sparklineGroup3.SparklineType = SparklineType.Stacked;sparklineGroup3.SparklineColor = Color.SkyBlue;sparklineGroup3.HighPointColor = Color.Blue;//設置盈虧迷你圖表的單元格以及圖表生成的數據范圍SparklineCollection sparklines3 = sparklineGroup3.Add();sparklines3.Add(sheet["B5:G5"], sheet["H5"]); //保存文檔workbook.SaveToFile("添加迷你圖.xlsx", ExcelVersion.Version2010);

using System;using Spire.Xls;using Spire.Xls.Core.Spreadsheet;

//實例化一個Workbook類，加載Excel文檔Workbook workbook = new Workbook();workbook.LoadFromFile("添加迷你圖.xlsx");//獲取第一個工作表Worksheet sheet = workbook.Worksheets[0];//修改第一個迷你圖組中迷你圖表類型和數據范圍ISparklineGroup sparklineGroup = sheet.SparklineGroups[0];sparklineGroup.SparklineType = SparklineType.Column;ISparklines sparklines = sparklineGroup[0];sparklines.RefreshRanges(sheet.Range["C3:G3"], sheet.Range["H3"]);//保存文檔workbook.SaveToFile("修改迷你圖.xlsx", ExcelVersion.Version2010);

using System;using Spire.Xls;using Spire.Xls.Core.Spreadsheet;

//實例化一個Workbook類，加載Excel文檔Workbook workbook = new Workbook();workbook.LoadFromFile("添加迷你圖.xlsx");//獲取第一個工作表Worksheet sheet = workbook.Worksheets[0];//獲取第2個迷你圖ISparklineGroup sparklineGroup = sheet.SparklineGroups[1];//從工作表中刪除圖表sheet.SparklineGroups.Remove(sparklineGroup);//保存文件workbook.SaveToFile("刪除迷你圖.xlsx", ExcelVersion.Version2010);