C# (CSharp) ExcelFormulaParser.EPPlus EPPlusExcelDataProvider示例

示例#1

文件： ExtensionMethods.cs 项目： guojianbin/ExcelFormulaParser

        public static void Calculate(this ExcelWorksheet worksheet, ExcelPackage package)
        {
            var provider = new EPPlusExcelDataProvider(package);
            var parser   = new FormulaParser(provider);

            ParseFormulas(provider, parser, worksheet);
        }

示例#2

文件： ExtensionMethods.cs 项目： swmal/ExcelFormulaParser

 private static void ParseFormulas(EPPlusExcelDataProvider provider, FormulaParser parser, ExcelWorksheet worksheet)
 {
     var formulas = provider.GetWorksheetFormulas(worksheet.Name);
     foreach (var formulaAddress in formulas.Keys)
     {
         var result = parser.ParseAt(formulaAddress);
         provider.SetCellValue(formulaAddress, result);
     }
 }

示例#3

文件： ExtensionMethods.cs 项目： swmal/ExcelFormulaParser

 public static void Calculate(this ExcelWorkbook workbook, ExcelPackage package)
 {
     var provider = new EPPlusExcelDataProvider(package);
     var parser = new FormulaParser(provider);
     foreach (var worksheet in workbook.Worksheets)
     {
         ParseFormulas(provider, parser, worksheet);
     }
 }

示例#4

文件： ExtensionMethods.cs 项目： guojianbin/ExcelFormulaParser

        private static void ParseFormulas(EPPlusExcelDataProvider provider, FormulaParser parser, ExcelWorksheet worksheet)
        {
            var formulas = provider.GetWorksheetFormulas(worksheet.Name);

            foreach (var formulaAddress in formulas.Keys)
            {
                var result = parser.ParseAt(formulaAddress);
                provider.SetCellValue(formulaAddress, result);
            }
        }

示例#5

文件： ExtensionMethods.cs 项目： guojianbin/ExcelFormulaParser

        public static void Calculate(this ExcelWorkbook workbook, ExcelPackage package)
        {
            var provider = new EPPlusExcelDataProvider(package);
            var parser   = new FormulaParser(provider);

            foreach (var worksheet in workbook.Worksheets)
            {
                ParseFormulas(provider, parser, worksheet);
            }
        }

示例#6

文件： ExtensionMethods.cs 项目： swmal/ExcelFormulaParser

 public static void Calculate(this ExcelWorksheet worksheet, ExcelPackage package)
 {
     var provider = new EPPlusExcelDataProvider(package);
     var parser = new FormulaParser(provider);
     ParseFormulas(provider, parser, worksheet);
 }