GO：使用GOLANG中的https://github.com/tealeg/xlsx库解析Excel数据的字节数组

Question

I want Parse byte array of excel data using https://github.com/tealeg/xlsx library in GOLANG. Actully i am getting data from the request(as byte array) to my GRPC server where I have to parse and process it.

I checked library API but it accepts file name as parameter.

"github.com/tealeg/xlsx"

func main(){
xlsx.OpenFile("file.xslx")
}

Any idea how do I pass byte array directly and process the same.

Answer 1

Got it. Used func OpenBinary(bs []byte) (*File, error)

Answer 2

分享一个功能丰富、兼容性好、高性能的专业 Excel 文档基础库 Excelize (https://github.com/xuri/excelize) —— 支持条件格式、数据验证、公式、图表、数据透视表、迷你图、富文本、冻结窗格、流式读写等复杂功能。