- Handle pre-defined number format set of cell when set cell value with `time.Time` data type, related issue #62;

- go doc updated

1 files changed, 49 insertions, 4 deletions

diff --git a/excelize.go b/excelize.go
index 39c2fad..8c7365b 100644
--- a/excelize.go
+++ b/excelize.go
@@ -65,7 +65,23 @@ func OpenReader(r io.Reader) (*File, error) {
 	}, nil
 }
 
-// SetCellValue provides function to set int or string type value of a cell.
+// SetCellValue provides function to set value of a cell. The following shows
+// the supported data types:
+//
+//    int
+//    int8
+//    int16
+//    int32
+//    int64
+//    float32
+//    float64
+//    string
+//    []byte
+//    time.Time
+//    nil
+//
+// Note that default date format is m/d/yy h:mm of time.Time type value. You can
+// set numbers format by SetCellStyle() method.
 func (f *File) SetCellValue(sheet, axis string, value interface{}) {
 	switch t := value.(type) {
 	case int:
@@ -88,7 +104,7 @@ func (f *File) SetCellValue(sheet, axis string, value interface{}) {
 		f.SetCellStr(sheet, axis, string(t))
 	case time.Time:
 		f.SetCellDefault(sheet, axis, strconv.FormatFloat(float64(timeToExcelTime(timeToUTCTime(value.(time.Time)))), 'f', -1, 32))
-		f.SetCellStyle(sheet, axis, axis, `{"number_format": 22}`)
+		f.setDefaultTimeStyle(sheet, axis)
 	case nil:
 		f.SetCellStr(sheet, axis, "")
 	default:
@@ -96,6 +112,34 @@ func (f *File) SetCellValue(sheet, axis string, value interface{}) {
 	}
 }
 
+// getCellStyle provides function to get cell style index by given worksheet
+// name and cell coordinates.
+func (f *File) getCellStyle(sheet, axis string) int {
+	xlsx := f.workSheetReader(sheet)
+	axis = strings.ToUpper(axis)
+	f.mergeCellsParser(xlsx, axis)
+	col := string(strings.Map(letterOnlyMapF, axis))
+	row, _ := strconv.Atoi(strings.Map(intOnlyMapF, axis))
+	xAxis := row - 1
+	yAxis := titleToNumber(col)
+
+	rows := xAxis + 1
+	cell := yAxis + 1
+
+	completeRow(xlsx, rows, cell)
+	completeCol(xlsx, rows, cell)
+
+	return f.prepareCellStyle(xlsx, cell, xlsx.SheetData.Row[xAxis].C[yAxis].S)
+}
+
+// setDefaultTimeStyle provides function to set default numbers format for
+// time.Time type cell value by given worksheet name and cell coordinates.
+func (f *File) setDefaultTimeStyle(sheet, axis string) {
+	if f.getCellStyle(sheet, axis) == 0 {
+		f.SetCellStyle(sheet, axis, axis, `{"number_format": 22}`)
+	}
+}
+
 // workSheetReader provides function to get the pointer to the structure after
 // deserialization by given worksheet index.
 func (f *File) workSheetReader(sheet string) *xlsxWorksheet {
@@ -119,7 +163,8 @@ func (f *File) workSheetReader(sheet string) *xlsxWorksheet {
 	return worksheet
 }
 
-// SetCellInt provides function to set int type value of a cell.
+// SetCellInt provides function to set int type value of a cell by given
+// worksheet name, cell coordinates and cell value.
 func (f *File) SetCellInt(sheet, axis string, value int) {
 	xlsx := f.workSheetReader(sheet)
 	axis = strings.ToUpper(axis)
@@ -141,7 +186,7 @@ func (f *File) SetCellInt(sheet, axis string, value int) {
 }
 
 // prepareCellStyle provides function to prepare style index of cell in
-// worksheet by given column index.
+// worksheet by given column index and style index.
 func (f *File) prepareCellStyle(xlsx *xlsxWorksheet, col, style int) int {
 	if xlsx.Cols != nil && style == 0 {
 		for _, v := range xlsx.Cols.Col {