EPPlus - 操作Excel

look at me

Some common mistakes

• Don't use localized function names. Only english names (such as SUM, IF, VLOOKUP, etc) are supported.

• Don't use semicolon as a separator between function arguments. Only comma is supported.

• Don't add the leading = sign in your formula. "=SUM(A1:A2)" is wrong, "SUM(A1:A2)" is correct.

• The .Calculate() methods are available on Workbook, Worksheet and Range level only after a using OfficeOpenXml;. Alternatively, you might call method OfficeOpenXml.CalculationExtension.Calculate()

Value与Text

        // 摘要:
        //     Set the range to a specific value
        public object Value { get; set; }
        //
        // 摘要:
        //     Returns the formatted value.
        public string Text { get; }