diff options
| -rw-r--r-- | excelize.go | 52 | ||||
| -rw-r--r-- | xmlWorksheet.go | 4 |
2 files changed, 28 insertions, 28 deletions
diff --git a/excelize.go b/excelize.go index 79f7534..258411e 100644 --- a/excelize.go +++ b/excelize.go @@ -162,24 +162,24 @@ func replaceWorkSheetsRelationshipsNameSpace(workbookMarshal string) string { // Check XML tags and fix discontinuous case, for example: // -// <row r="15" spans="1:22" x14ac:dyDescent="0.2"> -// <c r="A15" s="2" /> -// <c r="B15" s="2" /> -// <c r="F15" s="1" /> -// <c r="G15" s="1" /> -// </row> +// <row r="15" spans="1:22" x14ac:dyDescent="0.2"> +// <c r="A15" s="2" /> +// <c r="B15" s="2" /> +// <c r="F15" s="1" /> +// <c r="G15" s="1" /> +// </row> // // in this case, we should to change it to // -// <row r="15" spans="1:22" x14ac:dyDescent="0.2"> -// <c r="A15" s="2" /> -// <c r="B15" s="2" /> -// <c r="C15" s="2" /> -// <c r="D15" s="2" /> -// <c r="E15" s="2" /> -// <c r="F15" s="1" /> -// <c r="G15" s="1" /> -// </row> +// <row r="15" spans="1:22" x14ac:dyDescent="0.2"> +// <c r="A15" s="2" /> +// <c r="B15" s="2" /> +// <c r="C15" s="2" /> +// <c r="D15" s="2" /> +// <c r="E15" s="2" /> +// <c r="F15" s="1" /> +// <c r="G15" s="1" /> +// </row> // // Noteice: this method could be very slow for large spreadsheets (more than 3000 rows one sheet). func checkRow(xlsx xlsxWorksheet) xlsxWorksheet { @@ -223,20 +223,20 @@ func checkRow(xlsx xlsxWorksheet) xlsxWorksheet { // // For example: // -// <row r="19" spans="2:2"> -// <c r="B19"> -// <f>SUM(Sheet2!D2,Sheet2!D11)</f> -// <v>100</v> -// </c> -// </row> +// <row r="19" spans="2:2"> +// <c r="B19"> +// <f>SUM(Sheet2!D2,Sheet2!D11)</f> +// <v>100</v> +// </c> +// </row> // // to // -// <row r="19" spans="2:2"> -// <c r="B19"> -// <f>SUM(Sheet2!D2,Sheet2!D11)</f> -// </c> -// </row> +// <row r="19" spans="2:2"> +// <c r="B19"> +// <f>SUM(Sheet2!D2,Sheet2!D11)</f> +// </c> +// </row> func (f *File) UpdateLinkedValue() { for i := 1; i <= f.SheetCount; i++ { var xlsx xlsxWorksheet diff --git a/xmlWorksheet.go b/xmlWorksheet.go index fb3639d..975e40e 100644 --- a/xmlWorksheet.go +++ b/xmlWorksheet.go @@ -131,7 +131,7 @@ type xlsxSheetViews struct { type xlsxSheetView struct { // WindowProtection bool `xml:"windowProtection,attr"` // ShowFormulas bool `xml:"showFormulas,attr"` - // ShowGridLines bool `xml:"showGridLines,attr"` + ShowGridLines string `xml:"showGridLines,attr,omitempty"` // ShowRowColHeaders bool `xml:"showRowColHeaders,attr"` // ShowZeros bool `xml:"showZeros,attr"` // RightToLeft bool `xml:"rightToLeft,attr"` @@ -155,7 +155,7 @@ type xlsxSheetView struct { // as I need. type xlsxSelection struct { Pane string `xml:"pane,attr,omitempty"` - ActiveCell string `xml:"activeCell,attr"` + ActiveCell string `xml:"activeCell,attr,omitempty"` ActiveCellID int `xml:"activeCellId,attr"` SQRef string `xml:"sqref,attr"` } |