Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

When I read an excel sheet, an error occurred #715

Closed
Iamzz-cn opened this issue Oct 19, 2020 · 9 comments
Closed

When I read an excel sheet, an error occurred #715

Iamzz-cn opened this issue Oct 19, 2020 · 9 comments

Comments

@Iamzz-cn
Copy link

func main() {
	f, err := excelize.OpenFile("i18n.xlsx")
	if err != nil {
		fmt.Println(err)
		return
	}
	// 获取 Sheet1 上所有单元格
	rows, err := f.GetRows("Sheet1")

	if err != nil {
		fmt.Println(err)
		return
	}
	for _, row := range rows {
		for _, colCell := range row {
			fmt.Print(colCell, "\t")
		}
		fmt.Println()
	}
}

image

@Iamzz-cn
Copy link
Author

I can’t make a copy of the same excel.This i18n table has 14 columns and 13000+ rows

@Iamzz-cn
Copy link
Author

So I have no way to provide an excel file

@Iamzz-cn
Copy link
Author

go version go1.15.3 windows/amd64

@Iamzz-cn
Copy link
Author

The excelize version was downloaded yesterday using go get github.com/360EntSecGroup-Skylar/excelize

@Iamzz-cn
Copy link
Author

I want to know what is the specific cause of the problem, formula or cell format, etc.

@Iamzz-cn
Copy link
Author

When I copied the entire table as a value to another table, the problem disappeared, but my table is too big, and I have no way to determine which cell has the problem

@Iamzz-cn
Copy link
Author

I can read the value of a certain cell, but there will be problems when traversing the entire table

@Iamzz-cn
Copy link
Author

Thank you

@xuri xuri closed this as completed in 4834a05 Oct 19, 2020
@xuri
Copy link
Member

xuri commented Oct 19, 2020

Thanks for your feedback, I have fixed it, please try to use the master branch code.

EugeneAndrosovPaser pushed a commit to ceearrashee/excelize that referenced this issue Nov 14, 2020
…ex returned by NewSheet in some case, fix panic on formatted value with no built-in number format ID
jenbonzhang pushed a commit to jenbonzhang/excelize that referenced this issue Oct 22, 2023
…ex returned by NewSheet in some case, fix panic on formatted value with no built-in number format ID
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants