B24126_033      DETAILED OCCUPATION FOR THE FULL-TIME, YEAR-ROUND CIVILIAN EMPLOYED FEMALE POPULATION 16 YEARS AND OVER% Buyers and purchasing agents, farm products
B24126_034      DETAILED OCCUPATION FOR THE FULL-TIME, YEAR-ROUND CIVILIAN EMPLOYED FEMALE POPULATION 16 YEARS AND OVER% Wholesale and retail buyers, except farm products
B24126_035      DETAILED OCCUPATION FOR THE FULL-TIME, YEAR-ROUND CIVILIAN EMPLOYED FEMALE POPULATION 16 YEARS AND OVER% Purchasing agents, except wholesale, retail, and farm products
B24126_036      䕄䅔䱉䑅传䍃偕呁佉⁎但⁒䡔⁅商䱌吭䵉ⱅ夠䅅ⵒ佒乕⁄䥃䥖䥌乁䔠偍佌䕙⁄䕆䅍䕌倠偏䱕呁佉⁎㘱夠䅅卒䄠䑎传䕖╒䌠慬浩⁳摡番瑳牥ⱳ愠灰慲獩牥ⱳ攠慸業敮獲‬湡⁤湩敶瑳杩瑡牯米䕄䅔䱉䑅传䍃偕呁佉⁎但⁒䡔⁅商䱌吭䵉ⱅ 夠䅅ⵒ佒乕⁄䥃䥖䥌乁䔠偍佌䕙⁄䕆䅍䕌倠偏䱕呁佉⁎㘱夠䅅卒䄠䑎传䕖╒䌠浯汰慩据⁥景楦散獲x䐀呅䥁䕌⁄䍏啃䅐䥔乏䘠剏吠䕈䘠䱕ⵌ䥔䕍‬

func readXLSFile(filename string) ([][]string, error) {
	result := [][]string{}

	log.Println("Get into readXlsFile")

	xlFile, err := xls.Open(filename, "utf-8")
	if err != nil {
		return nil, err
	}

	sheet1 := xlFile.GetSheet(0)
	//str := ""
	log.Println("Max Row ", int(sheet1.MaxRow))
	for i := 0; i <= (int(sheet1.MaxRow)); i++ {
		row1 := sheet1.Row(i)
		temp := []string{}
		for j := 0; j <= int(row1.LastCol()); j++ {
			temp = append(temp, row1.Col(j))

			log.Println("Max Col", int(row1.LastCol()), "Of row ", i+1)
			//str += fmt.Sprintf("column %d data = %s ", j+1, row1.Col(j))
		}
		//log.Printf("row %d data : %s \n", i+1, str)
		//str = ""
		result = append(result, temp)
	}

	return result, nil
}

2018/03/12 19:24:24 service.inquiry.go:4557: row 1836 data : column 1 data = :61:171218C59000NMSC column 2 data =   
2018/03/12 19:24:24 service.inquiry.go:4557: row 1837 data : column 1 data = :86: column 2 data =  column 3 data =  column 4 data =  column 5 data =  column 6 data =  column 7 data =  column 8 data =  column 9 data =  column 10 data =  column 11 data =  column 12 data = PLS10299 column 13 data =  column 14 data = 22162- column 15 data =   
2018/03/12 19:24:24 service.inquiry.go:4557: row 1838 data : column 1 data = :61:171218D300NMSC column 2 data =   
2018/03/12 19:24:24 service.inquiry.go:4557: row 1839 data : column 1 data = :86: column 2 data =  column 3 data =  column 4 data =  column 5 data =  column 6 data =  column 7 data =  column 8 data =  column 9 data =  column 10 data =  column 11 data =  column 12 data = PLS10299 column 13 data =  column 14 data = 22162- column 15 data =   
2018/03/12 19:24:24 service.inquiry.go:4557: row 1840 data : column 1 data = :61:171218D700NMSC column 2 data =   
2018/03/12 19:24:24 service.inquiry.go:4557: row 1841 data : column 1 data = :86: column 2 data =  column 3 data =  column 4 data =  column 5 data =  column 6 data =  column 7 data =  column 8 data =  column 9 data =  column 10 data =  column 11 data =  column 12 data = PLS10299 column 13 data =  column 14 data = 22162- column 15 data =   

		var bts1 = make([]uint16, size)//此处err为EOF的情况下，make的大小应该取n而不是size，否则获取到的字符串会出现多余的0

func Foo() {
	for {
		xlFile, err := xls.Open("example.xls", "utf-8")
                // when it done.memory does not free
		if err != nil || xlFile == nil {
			fmt.Println(err)
		}
		sheets := xlFile.NumSheets()
		for i := 0; i < sheets; i++ {
			if sheet := xlFile.GetSheet(i); sheet != nil {
				for i := 0; i <= (int(sheet.MaxRow)); i++ {
					row1 := sheet.Row(i)
					if row1 == nil {
						continue
					}
					for i := row1.FirstCol(); i <= row1.LastCol(); i++ {
						colCell := row1.Col(i)
						fmt.Println(colCell)
					}
				}
			}
		}
	}
}

func (rk RK) number() (intNum int64, floatNum float64, isFloat bool) {
	multiplied := rk & 1
	isInt := rk & 2
	val := rk >> 2
	if isInt == 0 {
		isFloat = true
		floatNum = math.Float64frombits(uint64(val) << 34)
		if multiplied != 0 {
			floatNum = floatNum / 100
		}
		return
	}
        //+++ add lines from here
        if multiplied !=0 {
		isFloat = true
		floatNum = float64(val)/100
                return
        }
        //+++end
	return int64(val), 0, false
}

"github.com/extrame/xls"

err := updateOrderFromFile(*filePath)
fmt.Println(err)

sheet1 := xlFile.GetSheet(0)
if sheet1 == nil {
	err := errors.New("empty sheet")
	fmt.Println(err)
	return err
}

fmt.Println("Total Lines ", sheet1.MaxRow, sheet1.Name)

fmt.Println(sheet1)

for i := 1; i <= int(sheet1.MaxRow); i++ {
	for ci := sheet1.Row(0).FirstCol(); ci < sheet1.Row(0).LastCol(); ci++ {
		fmt.Println(ci)
		fmt.Println("name---", sheet1.Row(0).Col(ci), "---value-------------->>>>", sheet1.Row(i).Col(ci))

		estimatedEffect := sheet1.Row(i).Col(ci)
		fmt.Println(estimatedEffect)
	}
}
return nil

import (
	"errors"
	"flag"
	"fmt"

	"github.com/extrame/xls"
)

func main() {
	filePath := flag.String("file", "/root/Downloads/90.xls", "order file")
	flag.Parse()

	xlFile, err := xls.Open(*filePath, "utf-8")
	if err != nil {
		fmt.Println(err)
		return
	}

	sheet1 := xlFile.GetSheet(0)
	if sheet1 == nil {
		err := errors.New("empty sheet")
		fmt.Println(err)
		return
	}

	for i := 1; i <= int(sheet1.MaxRow); i++ {
		for ci := sheet1.Row(0).FirstCol(); ci < sheet1.Row(0).LastCol(); ci++ {
			fmt.Println(ci)
			fmt.Println("name---", sheet1.Row(0).Col(ci), "---value-------------->>>>", sheet1.Row(i).Col(ci))

			estimatedEffect := sheet1.Row(i).Col(ci)
			fmt.Println(estimatedEffect)
			break
		}
	}
	return
}

    d:/go/bin/project/src/github.com/extrame/xls/col.go:104 +0xb8

    }
}

package main

import (
	"fmt"

	"github.com/extrame/xls"
)

func main() {
	if xlFile, err := xls.Open("file.xls", "utf-8"); err == nil {
		if sheet := xlFile.GetSheet(0); sheet != nil {

			for i := 2; i <= (int(sheet.MaxRow)); i++ {
				row := sheet.Row(i)
				if row != nil {
					col := row.Col(3)
					fmt.Print("\n", col)
				}
			}
		}
	}

}

for i := 0; i < xlFile.NumSheets(); i++ {
	if sheet1 := xlFile.GetSheet(i); sheet1 != nil {
		for j := 0; j < (int(sheet1.MaxRow)); j++ {
			row1 := sheet1.Row(j) // panic
			for k := row1.FirstCol(); k < row1.LastCol(); k++ {
				fmt.Print(row1.Col(k), "\t")
			}
			fmt.Print("\n")
		}
	}
}
func (w *WorkSheet) Row(i int) *Row {
	row := w.rows[uint16(i)] // sometimes row is nil
	row.wb = w.wb
	return row
}

panic: runtime error: index out of range

goroutine 1 [running]:
github.com/extrame/ole2.(*StreamReader).Read(0xc82006a1e0, 0xc90b242150, 0x4, 0x4, 0xe2300, 0x0, 0x0)
    /Users/samuelstarling/Development/go/src/github.com/extrame/ole2/stream_reader.go:34 +0x3a6
io.ReadAtLeast(0x424328, 0xc82006a1e0, 0xc90b242150, 0x4, 0x4, 0x4, 0x0, 0x0, 0x0)
    /usr/local/Cellar/go/1.5.1/libexec/src/io/io.go:298 +0xe6
io.ReadFull(0x424328, 0xc82006a1e0, 0xc90b242150, 0x4, 0x4, 0x4, 0x0, 0x0)
    /usr/local/Cellar/go/1.5.1/libexec/src/io/io.go:316 +0x62
encoding/binary.Read(0x424328, 0xc82006a1e0, 0x4242d0, 0x2091a0, 0x108b20, 0xc820068590, 0x0, 0x0)
    /usr/local/Cellar/go/1.5.1/libexec/src/encoding/binary/binary.go:216 +0x1336
github.com/extrame/xls.(*WorkBook).Parse(0xc820124000, 0x424350, 0xc82006a1e0)
    /Users/samuelstarling/Development/go/src/github.com/extrame/xls/workbook.go:44 +0x145
github.com/extrame/xls.newWorkBookFromOle2(0x424350, 0xc82006a1e0, 0x424350)
    /Users/samuelstarling/Development/go/src/github.com/extrame/xls/workbook.go:34 +0x127
github.com/extrame/xls.parse(0xc820092000, 0x7eb90, 0x7ed90, 0x137e88, 0x5, 0x0, 0x0, 0x0)
    /Users/samuelstarling/Development/go/src/github.com/extrame/xls/xls.go:46 +0x27c
github.com/extrame/xls.Open(0x161fa0, 0x32, 0x137e88, 0x5, 0x4b27, 0x0, 0x0)
    /Users/samuelstarling/Development/go/src/github.com/extrame/xls/xls.go:12 +0xa6
main.main()
    /Users/samuelstarling/Development/personal/xls-test/test.go:9 +0x48
exit status 2

func main() {
    xlsFile, err := xls.Open("full.xls", "utf-8")
    if err != nil {
        panic(err)
    }
    fmt.Println(xlsFile)
}

➜ $?=0 /tmp [ 8:37AM] % cat main.go
package main

import "fmt"
import "github.com/extrame/xls"

func main() {
        if xlFile, err := xls.Open("expenses.xls", "utf-8"); err == nil {
                if sheet1 := xlFile.GetSheet(0); sheet1 != nil {
                        fmt.Print("Total Lines ", sheet1.MaxRow, sheet1.Name)
                        col1 := sheet1.Rows[0].Cols[0]
                        col2 := sheet1.Rows[0].Cols[0]
                        for i := 0; i <= (int(sheet1.MaxRow)); i++ {
                                row1 := sheet1.Rows[uint16(i)]
                                col1 = row1.Cols[0]
                                col2 = row1.Cols[1]
                                fmt.Print("\n", col1.String(xlFile), ",", col2.String(xlFile))
                        }
                }
        }
}

>>>  0s elasped...
➜ $?=0 /tmp [ 8:37AM] % go run main.go
Total Lines 1Transactions
[Sr. No. ],[Date]panic: runtime error: invalid memory address or nil pointer dereference
[signal SIGSEGV: segmentation violation code=0x1 addr=0x30 pc=0x243d]

goroutine 1 [running]:
panic(0xb96e0, 0xc42000a110)
        /usr/local/Cellar/go/1.7.3/libexec/src/runtime/panic.go:500 +0x1a1
main.main()
        /tmp/main.go:16 +0x3fd
exit status 2

>>>  0s elasped...
➜ $?=1 /tmp [ 8:37AM] %

			//return t.Format(time.RFC3339) //TODO it should be international and format as the describled style
		}
		// see http://www.openoffice.org/sc/excelfileformat.pdf
	} else if 14 <= fNo && fNo <= 17 || fNo == 22 || 27 <= fNo && fNo <= 36 || 50 <= fNo && fNo <= 58 { // jp. date format
		i, f, isFloat := xf.Rk.number()
		if !isFloat {
			f = float64(i)
		}
		return strconv.FormatFloat(f, 'f', -1, 32)
		//t := timeFromExcelTime(f, wb.dateMode == 1)
		//return t.Format("2006.01") //TODO it should be international
	}
}
return xf.Rk.String()