sheet.PivotTables[0].RowFields[0].CustomName = "rowName";
sheet.PivotTables[0].ColumnFields[0].CustomName = "colName";
sheet.PivotTables[0].PivotFields[0].CustomName = "fieldName1";
sheet.PivotTables[0].DataFields[0].CustomName = "dataName";

Workbook workbook = new Workbook();
workbook.LoadFromFile(inputFile);
Worksheet sheet = workbook.Worksheets[0];
//convert shapes to images
SaveShapeTypeOption shapelist = new SaveShapeTypeOption();
//save the shapes in worksheet to images.
shapelist.SaveAll = true;
Dictionary images = sheet.SaveAndGetShapesToImage(shapelist);
foreach (KeyValuePair pair in images)
{
    IShape shape = pair.Key;
    Bitmap bitmap = pair.Value;
    bitmap.Save(outputFile+shape.Name + "_" + shape.Height + "_" + shape.Width +"_" + shape.ShapeType + ".png");
}

sheet.PageSetup.SetCustomPaperSize(224, (float)25.4); 
sheet.PageSetup.Orientation = PageOrientationType.Portrait;

sheet.Range["A1"].AddSignatureLine("e-iceblue","E-iceblue","[email protected]", "description" ,false, true);

Spire.Xls.Core.IShapes shapes = sheet.Shapes;

sheet.PageSetup.PaperSize = PaperSizeType.PaperA0;

workbook.ConverterSetting.GrayLevelForPrint = true;

workbook.Chartsheets[int index1].MoveSheet(int index2);
workbook.Chartsheets[int index1].MoveChartsheet(int index2)

Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "ISO.CEILING(12.69,2)";
workbook.CalculateAllValue();
workbook.SaveToFile("result.xlsx",ExcelVersion.Version2016);

Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "=WORKDAY.INTL(DATE(2023,3,17),25,1,DATE(2023,3,20))";
workbook.CalculateAllValue();
workbook.SaveToFile("result.xlsx",ExcelVersion.Version2016);

Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "BITXOR(12,58)";
workbook.CalculateAllValue();
workbook.SaveToFile("result.xlsx");

Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "ISFORMULA(A1)";
workbook.CalculateAllValue();
workbook.SaveToFile("result.xlsx");