From ebea684ae5c60776d4d8364b7360d0c0603cb3b0 Mon Sep 17 00:00:00 2001 From: xuri Date: Mon, 18 Jul 2022 00:21:34 +0800 Subject: Fix potential file corrupted and change worksheet name case-insensitive - Using sheet ID instead of sheet index when delete the cell in calculation chain - Update documentation for exported functions - Using `sheet` represent the sheet name in the function parameters --- rows.go | 19 +++++++++++-------- 1 file changed, 11 insertions(+), 8 deletions(-) (limited to 'rows.go') diff --git a/rows.go b/rows.go index f83d425..853c8f7 100644 --- a/rows.go +++ b/rows.go @@ -26,13 +26,16 @@ import ( "github.com/mohae/deepcopy" ) -// GetRows return all the rows in a sheet by given worksheet name -// (case sensitive), returned as a two-dimensional array, where the value of -// the cell is converted to the string type. If the cell format can be applied -// to the value of the cell, the applied value will be used, otherwise the -// original value will be used. GetRows fetched the rows with value or formula -// cells, the continually blank cells in the tail of each row will be skipped, -// so the length of each row may be inconsistent. For example: +// GetRows return all the rows in a sheet by given worksheet name, returned as +// a two-dimensional array, where the value of the cell is converted to the +// string type. If the cell format can be applied to the value of the cell, +// the applied value will be used, otherwise the original value will be used. +// GetRows fetched the rows with value or formula cells, the continually blank +// cells in the tail of each row will be skipped, so the length of each row +// may be inconsistent. +// +// For example, get and traverse the value of all cells by rows on a worksheet +// named 'Sheet1': // // rows, err := f.GetRows("Sheet1") // if err != nil { @@ -233,7 +236,7 @@ func (rows *Rows) rowXMLHandler(rowIterator *rowXMLIterator, xmlElement *xml.Sta // } // func (f *File) Rows(sheet string) (*Rows, error) { - name, ok := f.sheetMap[trimSheetName(sheet)] + name, ok := f.getSheetXMLPath(sheet) if !ok { return nil, ErrSheetNotExist{sheet} } -- cgit v1.2.1