From 3c4ad28db75108dfd974b994df26ec7f33a69be7 Mon Sep 17 00:00:00 2001
From: Ri Xu <xuri.me@gmail.com>
Date: Tue, 30 Aug 2016 21:54:28 +0800
Subject: - Get cell value support - Optimisation code use fmt package - Update
 README - Remove useless function

---
 cell.go | 40 ++++++++++++++++++++++++++++++++++++++++
 1 file changed, 40 insertions(+)
 create mode 100644 cell.go

(limited to 'cell.go')

diff --git a/cell.go b/cell.go
new file mode 100644
index 0000000..4ce9619
--- /dev/null
+++ b/cell.go
@@ -0,0 +1,40 @@
+package excelize
+
+import (
+	"encoding/xml"
+	"strconv"
+	"strings"
+)
+
+// Get value from cell by given sheet index and axis in XLSX file
+func GetCellValue(file []FileList, sheet string, axis string) string {
+	axis = strings.ToUpper(axis)
+	var xlsx xlsxWorksheet
+	row := getRowIndex(axis)
+	xAxis := row - 1
+	name := `xl/worksheets/` + strings.ToLower(sheet) + `.xml`
+	xml.Unmarshal([]byte(readXml(file, name)), &xlsx)
+	rows := len(xlsx.SheetData.Row)
+	if rows <= xAxis {
+		return ``
+	}
+	for _, v := range xlsx.SheetData.Row[xAxis].C {
+		if xlsx.SheetData.Row[xAxis].R == row {
+			if axis == v.R {
+				switch v.T {
+				case "s":
+					shardStrings := xlsxSST{}
+					xlsxSI := 0
+					xlsxSI, _ = strconv.Atoi(v.V)
+					xml.Unmarshal([]byte(readXml(file, `xl/sharedStrings.xml`)), &shardStrings)
+					return shardStrings.SI[xlsxSI].T
+				case "str":
+					return v.V
+				default:
+					return v.V
+				}
+			}
+		}
+	}
+	return ``
+}
-- 
cgit v1.2.1