xlsReader
xlsReader copied to clipboard
shakinm
Go - lib for read xls (Excel) file
2022/07/16 17:03:48 Identification signature for the compound file structure, and MUST be set to the value 0xD0, 0xCF, 0x11, 0xE0, 0xA1, 0xB1, 0x1A, 0xE1 --- FAIL: TestReadXls (0.01s) panic: Identification...
How to extract Hyperlink from an excel cell??
Version: 0.9.10 Stack trace: ``` panic: runtime error: slice bounds out of range [:17861] with capacity 3993 goroutine 1 [running]: github.com/shakinm/xlsReader/xls.(*Workbook).read(0xc000110240, 0xc00012b000, 0xf99, 0xf99, 0xf99, 0x0) /Users/juris/Work/golang/pkg/mod/github.com/shakinm/[email protected]/xls/workbook.go:87 +0x159f github.com/shakinm/xlsReader/xls.readStream(0x1147ae8, 0xc00007a360,...
Version 0.9.7 Stack trace ``` panic: runtime error: index out of range [18963] with length 17388 goroutine 75 [running]: github.com/shakinm/xlsReader/xls/record.(*LabelSSt).GetString(0xc0004033a0, 0xc15b6c, 0x10) /gocode/pkg/mod/github.com/shakinm/[email protected]/xls/record/labelSst.go:43 +0x70 github.com/shakinm/xlsReader/xls/record.(*Format).GetFormatString(0xc0000aaa20, 0x1043a20, 0xc0004033a0, 0x16d6740, 0x1) /gocode/pkg/mod/github.com/shakinm/[email protected]/xls/record/format.go:125...
println(sheet.GetNumberRows()) returned 16384, but in file 26065 rows!!!
When the program parses some corrupt Excel files, a memory overflow occurs, causing an error in the program。 Error like: ```txt goroutine 68 [running]: runtime.systemstack_switch() runtime/asm_amd64.s:459 fp=0xc0008136e0 sp=0xc0008136d8 pc=0x468140 runtime.(*mheap).alloc(0x1fd980000?,...
fix:fix record.GetString panic bug because of out range of index of r.sst.Rgb
rk-num is a signed int32 or float64 in `xlsReader/xls/structure/RKNum.go line: 14` it shout be ```go var val int32 binary.Read(bytes.NewBuffer(r[:]), binary.LittleEndian, &val) val >>= 2 ```
Decoding of compressed characters is not handled correclty: ``` func (r *LabelBIFF8) GetString() string { if int(r.grbit[0]) == 1 { name := helpers.BytesToUints16(r.rgb[:]) runes := utf16.Decode(name) return string(runes) } else...
