summaryrefslogtreecommitdiff
path: root/sheet.go
diff options
context:
space:
mode:
authorRi Xu <xuri.me@gmail.com>2016-09-02 11:54:52 +0800
committerRi Xu <xuri.me@gmail.com>2016-09-02 11:54:52 +0800
commit192af02a40cc745d967be1c96fcc52569ca8e8df (patch)
tree7350c2c152b6df596759c214705f7a00eb30b573 /sheet.go
parent0a0a36bafd160752c2af914ab3bdb1d28665ebe3 (diff)
Format code with golint rules
Diffstat (limited to 'sheet.go')
-rw-r--r--sheet.go40
1 files changed, 20 insertions, 20 deletions
diff --git a/sheet.go b/sheet.go
index 9a3cf15..e5cee1f 100644
--- a/sheet.go
+++ b/sheet.go
@@ -7,12 +7,12 @@ import (
"strings"
)
-// Create a new sheet by given index, when creating a new XLSX file,
-// the default sheet will be create, when you create a new file, you
-// need to ensure that the index is continuous.
+// NewSheet provice function to greate a new sheet by given index, when
+// creating a new XLSX file, the default sheet will be create, when you
+// create a new file, you need to ensure that the index is continuous.
func NewSheet(file []FileList, index int, name string) []FileList {
// Update docProps/app.xml
- file = setAppXml(file)
+ file = setAppXML(file)
// Update [Content_Types].xml
file = setContentTypes(file, index)
// Create new sheet /xl/worksheets/sheet%d.xml
@@ -27,7 +27,7 @@ func NewSheet(file []FileList, index int, name string) []FileList {
// Read and update property of contents type of XLSX
func setContentTypes(file []FileList, index int) []FileList {
var content xlsxTypes
- xml.Unmarshal([]byte(readXml(file, `[Content_Types].xml`)), &content)
+ xml.Unmarshal([]byte(readXML(file, `[Content_Types].xml`)), &content)
content.Overrides = append(content.Overrides, xlsxOverride{
PartName: `/xl/worksheets/sheet` + strconv.Itoa(index) + `.xml`,
ContentType: "application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml",
@@ -44,7 +44,7 @@ func setSheet(file []FileList, index int) []FileList {
var xlsx xlsxWorksheet
xlsx.Dimension.Ref = "A1"
xlsx.SheetViews.SheetView = append(xlsx.SheetViews.SheetView, xlsxSheetView{
- WorkbookViewId: 0,
+ WorkbookViewID: 0,
})
output, err := xml.MarshalIndent(xlsx, "", "")
if err != nil {
@@ -57,14 +57,14 @@ func setSheet(file []FileList, index int) []FileList {
// Update workbook property of XLSX
func setWorkbook(file []FileList, index int, name string) []FileList {
var content xlsxWorkbook
- xml.Unmarshal([]byte(readXml(file, `xl/workbook.xml`)), &content)
+ xml.Unmarshal([]byte(readXML(file, `xl/workbook.xml`)), &content)
rels := readXlsxWorkbookRels(file)
- rId := len(rels.Relationships)
+ rID := len(rels.Relationships)
content.Sheets.Sheet = append(content.Sheets.Sheet, xlsxSheet{
Name: name,
- SheetId: strconv.Itoa(index),
- Id: "rId" + strconv.Itoa(rId),
+ SheetID: strconv.Itoa(index),
+ ID: "rId" + strconv.Itoa(rID),
})
output, err := xml.MarshalIndent(content, "", "")
if err != nil {
@@ -76,16 +76,16 @@ func setWorkbook(file []FileList, index int, name string) []FileList {
// Read and unmarshal workbook relationships of XLSX
func readXlsxWorkbookRels(file []FileList) xlsxWorkbookRels {
var content xlsxWorkbookRels
- xml.Unmarshal([]byte(readXml(file, `xl/_rels/workbook.xml.rels`)), &content)
+ xml.Unmarshal([]byte(readXML(file, `xl/_rels/workbook.xml.rels`)), &content)
return content
}
// Update workbook relationships property of XLSX
func addXlsxWorkbookRels(file []FileList, sheet int) []FileList {
content := readXlsxWorkbookRels(file)
- rId := len(content.Relationships) + 1
+ rID := len(content.Relationships) + 1
content.Relationships = append(content.Relationships, xlsxWorkbookRelation{
- Id: "rId" + strconv.Itoa(rId),
+ ID: "rId" + strconv.Itoa(rID),
Target: `worksheets/sheet` + strconv.Itoa(sheet) + `.xml`,
Type: "http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet",
})
@@ -97,8 +97,8 @@ func addXlsxWorkbookRels(file []FileList, sheet int) []FileList {
}
// Update docProps/app.xml file of XML
-func setAppXml(file []FileList) []FileList {
- return saveFileList(file, `docProps/app.xml`, TEMPLATE_DOCPROPS_APP)
+func setAppXML(file []FileList) []FileList {
+ return saveFileList(file, `docProps/app.xml`, templateDocpropsApp)
}
// Some tools that read XLSX files have very strict requirements about
@@ -125,14 +125,14 @@ func replaceRelationshipsID(workbookMarshal string) string {
return strings.Replace(rids, `<drawing rid="`, `<drawing r:id="`, -1)
}
-// Set default active sheet of XLSX by given index
+// SetActiveSheet provide function to set default active sheet of XLSX by given index
func SetActiveSheet(file []FileList, index int) []FileList {
var content xlsxWorkbook
if index < 1 {
index = 1
}
- index -= 1
- xml.Unmarshal([]byte(readXml(file, `xl/workbook.xml`)), &content)
+ index--
+ xml.Unmarshal([]byte(readXML(file, `xl/workbook.xml`)), &content)
if len(content.BookViews.WorkBookView) > 0 {
content.BookViews.WorkBookView[0].ActiveTab = index
} else {
@@ -146,12 +146,12 @@ func SetActiveSheet(file []FileList, index int) []FileList {
fmt.Println(err)
}
file = saveFileList(file, `xl/workbook.xml`, workBookCompatibility(replaceRelationshipsNameSpace(string(output))))
- index += 1
+ index++
for i := 0; i < sheets; i++ {
xlsx := xlsxWorksheet{}
sheetIndex := i + 1
path := `xl/worksheets/sheet` + strconv.Itoa(sheetIndex) + `.xml`
- xml.Unmarshal([]byte(readXml(file, path)), &xlsx)
+ xml.Unmarshal([]byte(readXML(file, path)), &xlsx)
if index == sheetIndex {
if len(xlsx.SheetViews.SheetView) > 0 {
xlsx.SheetViews.SheetView[0].TabSelected = true