xls

xls copied to clipboard

多个sheet栏位解析错误

1

.xls文件存在多个sheet栏位 例如想解析sheet2栏位 if xlFile, err := xls.Open(filePath, "utf-8"); err == nil { //第一个sheet sheet := xlFile.GetSheet(1) fmt.Println(sheet.Name) fmt.Println(sheet.MaxRow) } 打印： Sheet2 6 这看起来没什么问题，然而只是多加了一句代码输出行数据时，整个sheet获取就会错乱 if xlFile, err := xls.Open(filePath, "utf-8"); err...

AncestorDragon

Col(i) return empty string even when there has value

8

When I read the data from xls file with function **func (r *Row) Col(i int) string** , I got empty string in some rows. I found that because I insert...

qitianchan

oushu1zhangxiangxuan1

fankane

读到空行能否返回给上层处理

2

 如30-32这么处理

yangge2333

当excel不同的文本值过多时，会读不到单元格文本值

7

[test_data_2.xls.zip](https://github.com/extrame/xls/files/4665830/test_data_2.xls.zip) 读取附件中的文件，读取到253行附近开始无法获得后面文本单元格的文本值。  问题出现在workbook.go第118行，在读不到数据的循环中，binary.Read(buf_item, binary.LittleEndian, &size)开始返回err==EOF，但是分支并没有处理。

liuxinghen

How to write an XLS file

4

We can use addSheet addRow to create a WorkBook, but how to write the content of a WorkBook to an XLS file?

lixiaoxi-coder

WorkSheet.Row(i int) method panic

3

#### WorkSheet.Row(i int) method panic 0

xiaoxfan

format key might not right, so need check if the key is exist

1

/* func (c *NumberCol) String(wb *WorkBook) []string { if fNo := wb.Xfs[c.Index].formatNo(); fNo != 0 { t := timeFromExcelTime(c.Float, wb.dateMode == 1) if value,ok:=wb.Formats[fNo];ok{ return []string{yymmdd.Format(t, value.str)} }else { return...

liuguodong15

## Optimize some binary.Read(), the parsing speed is increased by 10x - before parse excel with row 65535 cost 139s - after parse excel with row 65535 cost 13s @extrame

tiptok