diff options
| author | Ri Xu <xuri.me@gmail.com> | 2016-08-30 11:51:31 +0800 |
|---|---|---|
| committer | Ri Xu <xuri.me@gmail.com> | 2016-08-30 11:51:31 +0800 |
| commit | a9d3ee28693adfe920b3cd047f52862d8a79a00e (patch) | |
| tree | 564bde64a5229782c8a3a5e1f0d39e4bfc57cdb4 /excelize_test.go | |
Init commit.
Diffstat (limited to 'excelize_test.go')
| -rw-r--r-- | excelize_test.go | 55 |
1 files changed, 55 insertions, 0 deletions
diff --git a/excelize_test.go b/excelize_test.go new file mode 100644 index 0000000..c2848a0 --- /dev/null +++ b/excelize_test.go @@ -0,0 +1,55 @@ +package excelize + +import ( + "fmt" + "math/rand" + "sync" + "testing" + "time" +) + +var ( + once sync.Once +) + +func testSetup() { + rand.Seed(time.Now().UnixNano()) +} + +func TestExcelize(t *testing.T) { + // Test update a XLSX file + file, err := OpenFile("./test/Workbook1.xlsx") + if err != nil { + fmt.Println(err) + } + file = SetCellInt(file, "SHEET2", "B2", 100) + file = SetCellStr(file, "SHEET2", "C11", "Knowns") + file = NewSheet(file, 3, "TestSheet") + file = SetCellInt(file, "Sheet3", "A23", 10) + file = SetCellStr(file, "SHEET3", "b230", "10") + file = SetActiveSheet(file, 2) + if err != nil { + fmt.Println(err) + } + for i := 1; i <= 300; i++ { + file = SetCellStr(file, "SHEET3", fmt.Sprintf("c%d", i), randToken(5)) + } + err = Save(file, "./test/Workbook_2.xlsx") + + // Test create a XLSX file + file2 := CreateFile() + file2 = NewSheet(file2, 2, "SHEETxxx") + file2 = NewSheet(file2, 3, "asd") + file2 = SetCellInt(file2, "Sheet2", "A23", 10) + file2 = SetCellStr(file2, "SHEET1", "B20", "10") + err = Save(file2, "./test/Workbook_3.xlsx") + if err != nil { + fmt.Println(err) + } +} + +func randToken(length int) string { + b := make([]byte, length) + rand.Read(b) + return fmt.Sprintf("%x", b) +} |
