基于 Golang 的 xls 读取类库:xls

jopen 9年前

Golang 编写的 xls 读取类库,能够实现 xls 表格的读取功能

部分代码:

func (w *WorkBook) ReadAllCells() (res [][]string) {      for _, sheet := range w.Sheets {          w.PrepareSheet(sheet)          if sheet.MaxRow != 0 {              temp := make([][]string, sheet.MaxRow+1)              for k, row := range sheet.Rows {                  data := make([]string, 0)                  if len(row.Cols) > 0 {                      for _, col := range row.Cols {                          if uint16(len(data)) <= col.LastCol() {                              data = append(data, make([]string, col.LastCol()-uint16(len(data))+1)...)                          }                          str := col.String(w)                          for i := uint16(0); i < col.LastCol()-col.FirstCol()+1; i++ {                              data[col.FirstCol()+i] = str[i]                          }                      }                      temp[k] = data                  }              }              res = append(res, temp...)          }      }      return  }

项目主页:http://www.open-open.com/lib/view/home/1427120300840