迷你图是Excel 2010及以上版本所支持的功能，它是绘制在单元格中的一种微型图表，用迷你图可以清晰直观地反映数据的变化趋势。本文将介绍如何使用Spire.XLS组件在Excel中添加迷你图、修改现有迷你图以及删除迷你图。

添加迷你图

Spire.XLS支持Excel目前所提供的三种迷你图类型，即“折线迷你图”、“柱形迷你图”和“盈亏迷你图”，这里我们将介绍如何使用Spire.XLS添加这三种迷你图到Excel文档。

//创建Workbook实例
Workbook workbook = new Workbook();
//载入Excel文档
workbook.LoadFromFile("Sample.xlsx");

//获取第一个工作表
Worksheet sheet = workbook.Worksheets[0];

//添加折线迷你图组
SparklineGroup sparklineGroup1 = sheet.SparklineGroups.AddGroup();
sparklineGroup1.SparklineType = SparklineType.Line;
//设置迷你图组的颜色
sparklineGroup1.SparklineColor = Color.Orange;
//设置迷你图组最高点的颜色
sparklineGroup1.HighPointColor = Color.Red;
//添加迷你图到图组
SparklineCollection sparklines1 = sparklineGroup1.Add();
sparklines1.Add(sheet["B3:M3"], sheet["N3"]);

//添加柱形迷你图组
SparklineGroup sparklineGroup2 = sheet.SparklineGroups.AddGroup();
sparklineGroup2.SparklineType = SparklineType.Column;
//设置迷你图组的颜色
sparklineGroup2.SparklineColor = Color.BlueViolet;
//设置迷你图组最高点的颜色
sparklineGroup2.HighPointColor = Color.Red;
//添加迷你图到图组
SparklineCollection sparklines2 = sparklineGroup2.Add();
sparklines2.Add(sheet["B4:M4"], sheet["N4"]);
            

//添加盈亏迷你图组
SparklineGroup sparklineGroup3 = sheet.SparklineGroups.AddGroup();
sparklineGroup3.SparklineType = SparklineType.Stacked;
//设置迷你图组的颜色
sparklineGroup3.SparklineColor = Color.DarkBlue;
//设置迷你图组最高点的颜色
sparklineGroup3.HighPointColor = Color.Red;
//添加迷你图到图组
SparklineCollection sparklines3 = sparklineGroup3.Add();
sparklines3.Add(sheet["B5:M5"], sheet["N5"]);

//保存文档
workbook.SaveToFile("添加迷你图.xlsx", ExcelVersion.Version2010);

'创建Workbook实例
Dim workbook As New Workbook()
'载入Excel文档
workbook.LoadFromFile("Sample.xlsx")

'获取第一个工作表
Dim sheet As Worksheet = workbook.Worksheets(0)

'添加折线迷你图组
Dim sparklineGroup1 As SparklineGroup = sheet.SparklineGroups.AddGroup()
sparklineGroup1.SparklineType = SparklineType.Line
'设置迷你图组的颜色
sparklineGroup1.SparklineColor = Color.Orange
'设置迷你图组最高点的颜色
sparklineGroup1.HighPointColor = Color.Red
'添加迷你图到图组
Dim sparklines1 As SparklineCollection = sparklineGroup1.Add()
sparklines1.Add(sheet("B3:M3"), sheet("N3"))

'添加柱形迷你图组
Dim sparklineGroup2 As SparklineGroup = sheet.SparklineGroups.AddGroup()
sparklineGroup2.SparklineType = SparklineType.Column
'设置迷你图组的颜色
sparklineGroup2.SparklineColor = Color.BlueViolet
'设置迷你图组最高点的颜色
sparklineGroup2.HighPointColor = Color.Red
'添加迷你图到图组
Dim sparklines2 As SparklineCollection = sparklineGroup2.Add()
sparklines2.Add(sheet("B4:M4"), sheet("N4"))


'添加盈亏迷你图组
Dim sparklineGroup3 As SparklineGroup = sheet.SparklineGroups.AddGroup()
sparklineGroup3.SparklineType = SparklineType.Stacked
'设置迷你图组的颜色
sparklineGroup3.SparklineColor = Color.DarkBlue
'设置迷你图组最高点的颜色
sparklineGroup3.HighPointColor = Color.Red
'添加迷你图到图组
Dim sparklines3 As SparklineCollection = sparklineGroup3.Add()
sparklines3.Add(sheet("B5:M5"), sheet("N5"))

'保存文档
workbook.SaveToFile("添加迷你图.xlsx", ExcelVersion.Version2010)

修改现有迷你图

//创建Workbook实例
Workbook workbook = new Workbook();
//载入Excel文档
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["B3:G3"], sheet.Range["N3"]);

//保存文档
workbook.SaveToFile("修改迷你图.xlsx", ExcelVersion.Version2010);

'创建Workbook实例
Dim workbook As New Workbook()
'载入Excel文档
workbook.LoadFromFile("添加迷你图.xlsx")

'获取第一个工作表
Dim sheet As Worksheet = workbook.Worksheets(0)

'修改第一个迷你图组中迷你图的类型和数据范围
Dim sparklineGroup As ISparklineGroup = sheet.SparklineGroups(0)
sparklineGroup.SparklineType = SparklineType.Column
Dim sparklines As ISparklines = sparklineGroup(0)
sparklines.RefreshRanges(sheet.Range("B3:G3"), sheet.Range("N3"))

'保存文档
workbook.SaveToFile("修改迷你图.xlsx", ExcelVersion.Version2010)

删除迷你图

Spire.XLS支持从迷你图组中删除指定的迷你图，也支持将整个迷你图组从工作表中删除。

//创建Workbook实例
Workbook workbook = new Workbook();
//载入Excel文档
workbook.LoadFromFile("添加迷你图.xlsx");

//获取第一个工作表
Worksheet sheet = workbook.Worksheets[0];

//获取第一个迷你图组
ISparklineGroup sparklineGroup = sheet.SparklineGroups[0];

////删除图组中第一个迷你图
//ISparklines sparklines = sparklineGroup[0];
//sparklines.Remove(sparklines[0]);

//从工作表中删除第一个迷你图组
sheet.SparklineGroups.Remove(sparklineGroup);
      
//保存文档
workbook.SaveToFile("删除迷你图.xlsx", ExcelVersion.Version2010);

'创建Workbook实例
Dim workbook As New Workbook()
'载入Excel文档
workbook.LoadFromFile("添加迷你图.xlsx")

'获取第一个工作表
Dim sheet As Worksheet = workbook.Worksheets(0)

'获取第一个迷你图组
Dim sparklineGroup As ISparklineGroup = sheet.SparklineGroups(0)

'删除图组中第一个迷你图
'ISparklines sparklines = sparklineGroup[0];
'sparklines.Remove(sparklines[0]);

'从工作表中删除第一个迷你图组
sheet.SparklineGroups.Remove(sparklineGroup)

'保存文档
workbook.SaveToFile("删除迷你图.xlsx", ExcelVersion.Version2010)