From dad8f490cc2df664bf1e7c6770ecd89a0c0e7fe4 Mon Sep 17 00:00:00 2001 From: xuri Date: Thu, 9 Sep 2021 23:43:16 +0800 Subject: This closes #417 and closes #520, new API `GetCellType` has been added --- cell_test.go | 13 +++++++++++++ 1 file changed, 13 insertions(+) (limited to 'cell_test.go') diff --git a/cell_test.go b/cell_test.go index d56854b..5467e43 100644 --- a/cell_test.go +++ b/cell_test.go @@ -244,6 +244,19 @@ func TestGetCellValue(t *testing.T) { assert.NoError(t, err) } +func TestGetCellType(t *testing.T) { + f := NewFile() + cellType, err := f.GetCellType("Sheet1", "A1") + assert.NoError(t, err) + assert.Equal(t, CellTypeUnset, cellType) + assert.NoError(t, f.SetCellValue("Sheet1", "A1", "A1")) + cellType, err = f.GetCellType("Sheet1", "A1") + assert.NoError(t, err) + assert.Equal(t, CellTypeString, cellType) + _, err = f.GetCellType("Sheet1", "A") + assert.EqualError(t, err, `cannot convert cell "A" to coordinates: invalid cell name "A"`) +} + func TestGetCellFormula(t *testing.T) { // Test get cell formula on not exist worksheet. f := NewFile() -- cgit v1.2.1