计算Excel 2016 MINIFS和MAXIFS函数
Contents
[
Hide
]
可能的使用场景
Microsoft Excel 2016支持MINIFS和MAXIFS函数。这些函数不受Excel 2013或更早版本支持。Aspose.Cells也支持对这些函数进行计算。以下屏幕截图展示了这些函数的使用情况。请阅读屏幕截图中的红色注释,了解这些函数的工作原理。
计算Excel 2016的MINIFS和MAXIFS函数
以下示例代码加载sample excel file并调用Workbook.CalculateFormula()方法通过Aspose.Cells执行公式计算,然后将结果保存在output PDF 中。
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
// Load your source workbook containing MINIFS and MAXIFS functions | |
Workbook workbook = new Workbook(sourceDir + "sampleMINIFSAndMAXIFS.xlsx"); | |
// Perform Aspose.Cells formula calculation | |
workbook.CalculateFormula(); | |
// Save the calculations result in pdf format | |
PdfSaveOptions options = new PdfSaveOptions(); | |
options.OnePagePerSheet = true; | |
workbook.Save(outputDir + "outputMINIFSAndMAXIFS.pdf", options); |