forked from nkryuchkov/gooxml
-
Notifications
You must be signed in to change notification settings - Fork 0
/
main.go
37 lines (29 loc) · 1.08 KB
/
main.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
// Copyright 2017 Baliance. All rights reserved.
package main
import (
"fmt"
"baliance.com/gooxml/spreadsheet"
"baliance.com/gooxml/spreadsheet/formula"
)
func main() {
fmt.Println("Currently support", len(formula.SupportedFunctions()), "functions")
fmt.Println(formula.SupportedFunctions())
ss := spreadsheet.New()
sheet := ss.AddSheet()
sheet.Cell("A1").SetNumber(1.2)
sheet.Cell("A2").SetNumber(2.3)
sheet.Cell("A3").SetNumber(2.3)
formEv := formula.NewEvaluator()
// the formula context allows the formula evaluator to pull data from a
// sheet
a1Cell := sheet.FormulaContext().Cell("A1", formEv)
fmt.Println("A1 is", a1Cell.Value())
// So that when evaluating formulas, live workbook data is used. Formulas
// can be evaluated directly in the context of a sheet.
result := formEv.Eval(sheet.FormulaContext(), "SUM(A1:A3)")
fmt.Println("SUM(A1:A3) is", result.Value())
// Or, stored in a cell and the cell evaulated.
sheet.Cell("A4").SetFormulaRaw("SUM(A1:A3)+SUM(A1:A3)")
a4Value := formEv.Eval(sheet.FormulaContext(), "A4")
fmt.Println("A4 is", a4Value.Value())
}