This closes #417 and closes #520, new API `GetCellType` has been added

1 files changed, 13 insertions, 0 deletions

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()