diff options
author | li <liying0721@vip.126.com> | 2021-11-05 00:01:34 +0800 |
---|---|---|
committer | GitHub <noreply@github.com> | 2021-11-05 00:01:34 +0800 |
commit | 60b13affbda954261888a7829c88a32993edb5b2 (patch) | |
tree | f0d4cedb6003eb8c57c20f36407ca2d4084dd505 /col_test.go | |
parent | e64775fdcc38a9bc882ef32b4d4d491ad63acbdd (diff) |
Support get current row/col and total rows/cols in the stream reader (#1054)
Diffstat (limited to 'col_test.go')
-rw-r--r-- | col_test.go | 26 |
1 files changed, 12 insertions, 14 deletions
diff --git a/col_test.go b/col_test.go index 213c370..08f0eca 100644 --- a/col_test.go +++ b/col_test.go @@ -59,39 +59,37 @@ func TestCols(t *testing.T) { } func TestColumnsIterator(t *testing.T) { - const ( - sheet2 = "Sheet2" - expectedNumCol = 9 - ) - + sheetName, colCount, expectedNumCol := "Sheet2", 0, 9 f, err := OpenFile(filepath.Join("test", "Book1.xlsx")) require.NoError(t, err) - cols, err := f.Cols(sheet2) + cols, err := f.Cols(sheetName) require.NoError(t, err) - var colCount int for cols.Next() { colCount++ + assert.Equal(t, colCount, cols.CurrentCol()) + assert.Equal(t, expectedNumCol, cols.TotalCols()) require.True(t, colCount <= expectedNumCol, "colCount is greater than expected") } assert.Equal(t, expectedNumCol, colCount) assert.NoError(t, f.Close()) - f = NewFile() + f, sheetName, colCount, expectedNumCol = NewFile(), "Sheet1", 0, 4 cells := []string{"C2", "C3", "C4", "D2", "D3", "D4"} for _, cell := range cells { - assert.NoError(t, f.SetCellValue("Sheet1", cell, 1)) + assert.NoError(t, f.SetCellValue(sheetName, cell, 1)) } - cols, err = f.Cols("Sheet1") + cols, err = f.Cols(sheetName) require.NoError(t, err) - colCount = 0 for cols.Next() { colCount++ + assert.Equal(t, colCount, cols.CurrentCol()) + assert.Equal(t, expectedNumCol, cols.TotalCols()) require.True(t, colCount <= 4, "colCount is greater than expected") } - assert.Equal(t, 4, colCount) + assert.Equal(t, expectedNumCol, colCount) } func TestColsError(t *testing.T) { @@ -130,8 +128,8 @@ func TestGetColsError(t *testing.T) { f = NewFile() cols, err := f.Cols("Sheet1") assert.NoError(t, err) - cols.totalRow = 2 - cols.totalCol = 2 + cols.totalRows = 2 + cols.totalCols = 2 cols.curCol = 1 cols.sheetXML = []byte(`<worksheet><sheetData><row r="1"><c r="A" t="str"><v>A</v></c></row></sheetData></worksheet>`) _, err = cols.Rows() |