workbook.Worksheets[0].Range["E9"].Formula = "=RANK.AVG(10,A1:A6)";

//Default descending order
workbook.Worksheets[0].Range["E9"].Formula = "=RANK.EQ(10,A1:A6)";

workbook.Worksheets[0].Range["D2"].Formula = "=PERCENTILE.INC(\"\", 0.3)";

workbook.Worksheets[0].Range["D2"].Formula = "=PERCENTILE.EXC(\"\", 0.3)";

workbook.Worksheets[0].Range["D2"].Formula = "=BINOM.DIST(A7, A11, A12, FALSE)";

workbook.Worksheets[0].Range["D2"].Formula = "=BINOM.INV(A7, A12, A13)";

workbook.Worksheets[0].Range["C10"].Formula = "=NEGBINOM.DIST(10,5,1,TRUE)";

workbook.Worksheets[0].Range["C6"].Formula = "=BINOM.DIST.RANGE(10, 2, 5)";

workbook.Worksheets[0].Range["C7"].Formula = "=BETA.DIST(3, 0, 5, TRUE, 1, 5)";

workbook.Worksheets[0].Range["C7"].Formula = "=BETA.INV(0.685470581, 8, -1, 1, 3)";

workbook.Worksheets[0].Range["B3"].Formula = "=ROUNDBANK(1245585, -1)";

workbook.Worksheets[0].Range["B3"].Formula =  "=GAMMA(ss)";

workbook.Worksheets[0].Range["B10"].Formula = "=GAMMA.DIST(10.0001131, 9, 0, TRUE)";

workbook.Worksheets[0].Range["B10"].Formula = "=GAMMA.INV(0.068094, 0, 2)";

workbook.Worksheets[0].Range["J16"].Formula = "=TAKE(A1:F6,3)";

workbook.Worksheets[0].Range["G26"].Formula = "=HSTACK(E1:F7,G1:G6)";

Workbook wb = new Workbook();
Worksheet worksheet = wb.Worksheets[0];
worksheet.Range["A1"].Value = "fruit";
worksheet.Range["A2"].Value = "grape";
worksheet.Range["A3"].Value = "blueberry";
worksheet.Range["A4"].Value = "kiwi";
worksheet.Range["A5"].Value = "cherry";
worksheet.Range["A6"].Value = "grape";
worksheet.Range["A7"].Value = "blueberry";
worksheet.Range["A8"].Value = "kiwi";
worksheet.Range["A9"].Value = "cherry";

worksheet.Range["B1"].Value = "year";
worksheet.Range["B2"].Value2 = 2020;
worksheet.Range["B3"].Value2 = 2020;
worksheet.Range["B4"].Value2 = 2020;
worksheet.Range["B5"].Value2 = 2020;
worksheet.Range["B6"].Value2 = 2021;
worksheet.Range["B7"].Value2 = 2021;
worksheet.Range["B8"].Value2 = 2021;
worksheet.Range["B9"].Value2 = 2021;

worksheet.Range["C1"].Value = "amount";
worksheet.Range["C2"].Value2 = 50;
worksheet.Range["C3"].Value2 = 60;
worksheet.Range["C4"].Value2 = 70;
worksheet.Range["C5"].Value2 = 80;
worksheet.Range["C6"].Value2 = 90;
worksheet.Range["C7"].Value2 = 100;
worksheet.Range["C8"].Value2 = 110;
worksheet.Range["C9"].Value2 = 120;

// Get slicer collection
XlsSlicerCollection slicers = worksheet.Slicers;

//Create a super table with the data from the specific cell range.
IListObject table = worksheet.ListObjects.Create("Super Table", worksheet.Range["A1:C9"]);

int count = 3;
int index = 0;
foreach (SlicerStyleType type in Enum.GetValues(typeof(SlicerStyleType)))
{
	count += 5;
	//Add a Slicer through table data : here invoke Add(IListObject, string, int) api.
	String range = "E" + count;
	index = slicers.Add(table, range.ToString(), 0);

	//Style setting
	XlsSlicer xlsSlicer = slicers[index];
	xlsSlicer.Name = "slicers_" + count;
	xlsSlicer.StyleType = type;
}

//Save to file
wb.SaveToFile("output.xlsx", ExcelVersion.Version2013);

Workbook wb = new Workbook();
Worksheet worksheet = wb.Worksheets[0];
worksheet.Range["A1"].Value = "fruit";
worksheet.Range["A2"].Value = "grape";
worksheet.Range["A3"].Value = "blueberry";
worksheet.Range["A4"].Value = "kiwi";
worksheet.Range["A5"].Value = "cherry";
worksheet.Range["A6"].Value = "grape";
worksheet.Range["A7"].Value = "blueberry";
worksheet.Range["A8"].Value = "kiwi";
worksheet.Range["A9"].Value = "cherry";

worksheet.Range["B1"].Value = "year";
worksheet.Range["B2"].Value2 = 2020;
worksheet.Range["B3"].Value2 = 2020;
worksheet.Range["B4"].Value2 = 2020;
worksheet.Range["B5"].Value2 = 2020;
worksheet.Range["B6"].Value2 = 2021;
worksheet.Range["B7"].Value2 = 2021;
worksheet.Range["B8"].Value2 = 2021;
worksheet.Range["B9"].Value2 = 2021;

worksheet.Range["C1"].Value = "amount";
worksheet.Range["C2"].Value2 = 50;
worksheet.Range["C3"].Value2 = 60;
worksheet.Range["C4"].Value2 = 70;
worksheet.Range["C5"].Value2 = 80;
worksheet.Range["C6"].Value2 = 90;
worksheet.Range["C7"].Value2 = 100;
worksheet.Range["C8"].Value2 = 110;
worksheet.Range["C9"].Value2 = 120;

// Get pivot table collection
Spire.Xls.Collections.PivotTablesCollection pivotTables = worksheet.PivotTables;

//Add a PivotTable to the worksheet
CellRange dataRange = worksheet.Range["A1:C9"];
PivotCache cache = wb.PivotCaches.Add(dataRange);

//Cell to put the pivot table
Spire.Xls.PivotTable pt = worksheet.PivotTables.Add("TestPivotTable", worksheet.Range["A12"], cache);

//Drag the fields to the row area.
PivotField pf = pt.PivotFields["fruit"] as PivotField;
pf.Axis = AxisTypes.Row;
PivotField pf2 = pt.PivotFields["year"] as PivotField;
pf2.Axis = AxisTypes.Column;

//Drag the field to the data area.
pt.DataFields.Add(pt.PivotFields["amount"], "SUM of Count", SubtotalTypes.Sum);

//Set PivotTable style
pt.BuiltInStyle = PivotBuiltInStyles.PivotStyleMedium10;

pt.CalculateData();

//Get slicer collection
XlsSlicerCollection slicers = worksheet.Slicers;

//Add a Slicer through pivot table data: here invoke Add(IPivotTable, string, int) api.
int index = slicers.Add(pt, "E12", 0);

XlsSlicer xlsSlicer = slicers[index];
xlsSlicer.Name = "test_xlsSlicer";
xlsSlicer.Width = 100;
xlsSlicer.Height = 120;
xlsSlicer.StyleType = SlicerStyleType.SlicerStyleLight2;
xlsSlicer.PositionLocked = true;

//Get SlicerCache object of current slicer
XlsSlicerCache slicerCache = xlsSlicer.SlicerCache;
slicerCache.CrossFilterType = SlicerCacheCrossFilterType.ShowItemsWithNoData;

//Style setting
XlsSlicerCacheItemCollection slicerCacheItems = xlsSlicer.SlicerCache.SlicerCacheItems;
XlsSlicerCacheItem xlsSlicerCacheItem = slicerCacheItems[0];
xlsSlicerCacheItem.Selected = false;

XlsSlicerCollection slicers_2 = worksheet.Slicers;

IPivotField r1 = pt.PivotFields["year"];
int index_2 = slicers_2.Add(pt, "I12", r1);

XlsSlicer xlsSlicer_2 = slicers[index_2];
xlsSlicer_2.RowHeight = 40;
xlsSlicer_2.StyleType = SlicerStyleType.SlicerStyleLight3;
xlsSlicer_2.PositionLocked = false;

//Get SlicerCache object of current slicer
XlsSlicerCache slicerCache_2 = xlsSlicer_2.SlicerCache;
slicerCache_2.CrossFilterType = SlicerCacheCrossFilterType.ShowItemsWithDataAtTop;

//Style setting
XlsSlicerCacheItemCollection slicerCacheItems_2 = xlsSlicer_2.SlicerCache.SlicerCacheItems;
XlsSlicerCacheItem xlsSlicerCacheItem_2 = slicerCacheItems_2[1];
xlsSlicerCacheItem_2.Selected = false;
pt.CalculateData();

//Save to file
wb.SaveToFile("out.xlsx", ExcelVersion.Version2013);

Workbook wb = new Workbook();
wb.LoadFromFile(inputFile);
//Get slicer collection of first worksheet 
Worksheet worksheet = wb.Worksheets[0];
XlsSlicerCollection slicers = worksheet.Slicers;
//Remove the first slicer by index
slicers.RemoveAt(0);
Worksheet worksheet_2 = wb.Worksheets[1];
//Remove all slicers
worksheet_2.Slicers.Clear();
wb.SaveToFile(outputFile, ExcelVersion.Version2013);

Workbook wb = new Workbook();
wb.LoadFromFile("in.xlsx");

//Get the first worksheet of workbook
Worksheet worksheet = wb.Worksheets[0];

//Get slicer collection
XlsSlicerCollection slicers = worksheet.Slicers;

//Style setting
XlsSlicer xlsSlicer = slicers[0];

xlsSlicer.StyleType = SlicerStyleType.SlicerStyleDark4;
xlsSlicer.Caption = "Slicer";
xlsSlicer.PositionLocked = true;

XlsSlicerCacheItemCollection slicerCacheItems = xlsSlicer.SlicerCache.SlicerCacheItems;
XlsSlicerCacheItem xlsSlicerCacheItem = slicerCacheItems[0];
xlsSlicerCacheItem.Selected = false;
string displayValue = xlsSlicerCacheItem.DisplayValue;

//Get SlicerCache object of current slicer
XlsSlicerCache slicerCache = xlsSlicer.SlicerCache;
slicerCache.CrossFilterType = SlicerCacheCrossFilterType.ShowItemsWithNoData;

//Save to file
wb.SaveToFile("out.xlsx", ExcelVersion.Version2013);

Workbook wb = new Workbook();
wb.LoadFromFile("in.xlsx");
//Get slicer collection of first worksheet 
Worksheet worksheet = wb.Worksheets[0];

XlsSlicerCollection slicers = worksheet.Slicers;
StringBuilder builder = new StringBuilder();
builder.AppendLine("slicers.Count：" + slicers.Count);

XlsSlicer xlsSlicer = slicers[1];

builder.AppendLine("xlsSlicer.Name：" + xlsSlicer.Name);
builder.AppendLine("xlsSlicer.Caption：" + xlsSlicer.Caption);
builder.AppendLine("xlsSlicer.NumberOfColumns：" + xlsSlicer.NumberOfColumns);
builder.AppendLine("xlsSlicer.ColumnWidth：" + xlsSlicer.ColumnWidth);
builder.AppendLine("xlsSlicer.RowHeight：" + xlsSlicer.RowHeight);
builder.AppendLine("xlsSlicer.ShowCaption：" + xlsSlicer.ShowCaption);
builder.AppendLine("xlsSlicer.PositionLocked：" + xlsSlicer.PositionLocked);
builder.AppendLine("xlsSlicer.Width：" + xlsSlicer.Width);
builder.AppendLine("xlsSlicer.Height：" + xlsSlicer.Height);

//Get SlicerCache object of current slicer
XlsSlicerCache slicerCache = xlsSlicer.SlicerCache;

builder.AppendLine("slicerCache.SourceName：" + slicerCache.SourceName);
builder.AppendLine("slicerCache.IsTabular：" + slicerCache.IsTabular);
builder.AppendLine("slicerCache.Name：" + slicerCache.Name);

XlsSlicerCacheItemCollection slicerCacheItems = slicerCache.SlicerCacheItems;
XlsSlicerCacheItem xlsSlicerCacheItem = slicerCacheItems[1];


builder.AppendLine("xlsSlicerCacheItem.Selected：" + xlsSlicerCacheItem.Selected);

File.WriteAllText("out.txt", builder.ToString());
wb.Dispose();

Workbook wb = new Workbook();
wb.LoadFromFile(inputFile);            
Worksheet worksheet = wb.Worksheets[0];            
XlsSlicerCollection slicers = worksheet.Slicers;           
XlsSlicer xlsSlicer = slicers[0];
xlsSlicer.Caption = "Name1";            
wb.SaveToFile(outputFile, ExcelVersion.Version2013);

ExportTableOptions op = new ExportTableOptions();
op.ExportColumnNames = true;
op.KeepDataType = true;
var r = sheet.Range["A1:M7"]; 

Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["C2"].Formula = "=MUNIT(5)";
workbook.Worksheets[0].Range["C8"].Formula = "=MUNIT(0)";
workbook.Worksheets[0].Range["A1"].Formula = "=FLOOR.PRECISE(3.2)";
workbook.Worksheets[0].Range["D1"].Formula = "CSC(-2)";
workbook.Worksheets[0].Range["A3"].Formula = "=IMCSCH(\"4 + 3i\")";
workbook.CalculateAllValue();

PrstGeomShapeCollection prstGeomShapeType = worksheet.PrstGeomShapes;
for (int i = 0; i < prstGeomShapeType.Count; i++)
{
    XlsPrstGeomShape shape = (XlsPrstGeomShape)prstGeomShapeType[i];
    shape.HyLink.Address = "https://www.baidu.com/";
}

Workbook wb = new Workbook();
 wb.LoadFromFile(inputFile);
 Worksheet pivotSheet = wb.Worksheets[0]; 
 XlsPivotTable pivot = (XlsPivotTable)pivotSheet.PivotTables[0]; PivotField dateBaseField = pivot.PivotFields["number"] as PivotField;
 dateBaseField.CreateGroup(3000, 3800, 1);
 pivot.CalculateData();
 wb.SaveToFile(outputFile);
 wb.Dispose();

Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Text = "True";
workbook.Worksheets[0].Range["A2"].Text = "1234.01234";
workbook.Worksheets[0].Range["A3"].Text = "Hello";
workbook.Worksheets[0].Range["B1"].Text = "#VALUE!";
workbook.Worksheets[0].Range["B2"].Text = "Seattle";
workbook.Worksheets[0].Range["B3"].Text = "$1，123.00";          
workbook.Worksheets[0].Range["D1"].FormulaArray = "=ARRAYTOTEXT(A1：B4，0)"; 
workbook.Worksheets[0].Range["D3"].FormulaArray = "=ARRAYTOTEXT(A1：B4，1)";    
workbook.SaveToFile(outputFile, ExcelVersion.Version2013);

Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Value2 = "mcmxii";             
workbook.Worksheets[0].Range["C1"].Formula = "=ARABIC(A1)";
workbook.Worksheets[0].Range["C2"].Formula = "=ARABIC(\"LVII\")"; 
workbook.Worksheets[0].Range["C3"].Formula = "=ARABIC(\"mcmxii\")"; 
workbook.Worksheets[0].Range["C4"].Formula = "=ARABIC(\"\")"; 
workbook.Worksheets[0].Range["C5"].Formula = "=ARABIC(\"-LVII\")";
workbook.Worksheets[0].Range["C6"].Formula = "=ARABIC(\"57\")"; 
workbook.Worksheets[0].Range["C7"].Formula = "=ARABIC(\"2024/10/15\")"; 
workbook.Worksheets[0].Range["C8"].Formula = "=ARABIC(\"Text\")";

Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Value2 = 7;           
workbook.Worksheets[0].Range["C1"].Formula = "=BASE(A1,2)";
workbook.Worksheets[0].Range["C2"].Formula = "=BASE(7,2)"; 
workbook.Worksheets[0].Range["C3"].Formula = "=BASE(100,16))";
workbook.Worksheets[0].Range["C4"].Formula = "=BASE(15,2,10)"; 
workbook.Worksheets[0].Range["C5"].Formula = "=BASE(Text,16))"; 
workbook.Worksheets[0].Range["C6"].Formula = "=BASE(-7,2)";

Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Value2 = 4; 
workbook.Worksheets[0].Range["C1"].Formula = "=COMBINA(A1,3)";
workbook.Worksheets[0].Range["C2"].Formula = "=COMBINA(4,3)"; 
workbook.Worksheets[0].Range["C3"].Formula = "=COMBINA(10,3)"; 
workbook.Worksheets[0].Range["C4"].Formula = "=COMBINA(3,10)";
workbook.Worksheets[0].Range["C5"].Formula = "=COMBINA(Text,16))";

Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Value2 = 3;
workbook.Worksheets[0].Range["A2"].Value2 = 0;
workbook.Worksheets[0].Range["C1"].Formula = "=XOR(A1>A2)";
workbook.Worksheets[0].Range["C2"].Formula = "=XOR(2>9)"; 
workbook.Worksheets[0].Range["C3"].Formula = "=XOR(3>0,2<9)"; 
workbook.Worksheets[0].Range["C4"].Formula = "=XOR(3>12,2<9)"; 
workbook.Worksheets[0].Range["C5"].Formula = "=XOR(3>12,2<9,4>6)"; 
workbook.Worksheets[0].Range["A6"].Value2 = 3>0;
workbook.Worksheets[0].Range["C6"].Formula = "=XOR(A6)";

worksheet.Range["B1"].InsertOrUpdateCellImage("D:\\vs1.png",true); 

Workbook workbook = new Workbook();
workbook.LoadFromFile(inputFile);
var result = workbook.Worksheets[0].Range["A1"].GetNamedRange();
System.Console.WriteLine(result);
var result1 = workbook.Worksheets[0].Range["A2"].GetNamedRange();
System.Console.WriteLine(result1);
File.WriteAllText(outputFile_T, result.ToString()+ "\r
");
File.AppendAllText(outputFile_T, result1.ToString()+ "\r
");
var result2 = workbook.Worksheets[0].Range["A3"].GetNamedRange();
if (result2 == null)
{
    System.Console.WriteLine("null");
    File.AppendAllText(outputFile_T, "null");
}

XlsPivotTable pt1 = workbook.Worksheets["PivotTable_1"].PivotTables[0] as XlsPivotTable;
pt1.RowFields[0].AddValueFilter(PivotValueFilterType.Between, pt1.DataFields[0], 100000, 1000000);
pt1.ColumnFields[0].AddValueFilter(PivotValueFilterType.Between, pt1.DataFields[0], 100000, 1000000);
pt1.CalculateData();

workbook.Worksheets[0].Range["A1"].Formula = "=TEXTBEFORE(\"Red riding hood's, red hood\", \"hood\")";

Supports the issue that the TEXTSPLIT formula is now available. 
workbook.Worksheets[0].Range["B2:D2"].FormulaArray = "=TEXTSPLIT(A2, \" \")";

workbook.Worksheets[0].Range["A3"].Formula = "=TEXTAFTER(\"Red riding hood’s, red hood\", \"\")";