Read Excel Sheets and Files

Read Excel Sheets and Files, Golang Example

colDesc := make(map[string]string)
colDesc["int"] = "int"
colDesc["num"] = "num"
colDesc["date"] = "date"
rows, warn, err := u.ReadExcelS("types.xlsx", colDesc, "Sheet1")
log.Println(rows, err)
log.Println(warn)

colDesc2 := map[string]string{
"Pool ID" :  "char", "*" : "char" }
sheets, warnNew, err := u.ReadExcel("pool-logic.xlsx", colDesc2)
log.Println(sheets)
log.Println("Error", err)
log.Println(warnNew)

colDesc2 := map[string]string{"*" : "*" }
sheets, warnNew, err := u.ReadExcel("pool-logic.xlsx", colDesc2)
log.Println(sheets)
log.Println("Error", err)
log.Println(warnNew)

Read Excel Sheets and Files, Python Example

from sdk import excel

colDesc2=dict()
colDesc2["Pool ID"] = "char"
colDesc2["Logic 1"] = "char"
colDesc2["Logic 2"] = "char"
colDesc2["Logic 3"] = "char"
colDesc2["Logic 4"] = "char"
colDesc2["Logic 5"] = "char"
colDesc2["Logic 6"] = "char"
sheets, warn, err = excel.ReadExcel("pool-logic.xlsx", colDesc2, 0)
print(sheets)