Open Source Go Library for Reading Excel XLSX Files
Read XLSX documents via Open Source Go API.
Go-Excel is an an open source lightweight pure go library for reading Microsoft Excel documents. The API amis to proivide simple and easy way to read XLSX files as relate-db-like table. While reading an XLSX file, the API expects the first row as title row and rows as data rows.
The API provides set of tags to manipuplat Excel documents. The column tag maps to the feild name in the title row, default tag sets default value when no value is defined, split tag splits a string and convert them to slice, nil tag skips scan value in the cell and req tag returns error if the column title doesnot exist in Excel.
Getting Started with Go-Excel
The recommended way to install Go-Excel into your project is by using GitHub. Please use the following command for a smooth installation.
Install go-excel via GitHub
go get github.com/szyhf/go-excel
Read Excel File via Free Go API
The open source library Go-Excel allows computer programmers to read Excel files via GO. While reading excel file, you can use field name as default column name and you can map a column into more than one feild. Afte setting the reading options you open a new connection with Excel file using excel.NewConnector() method and successfull, connecting to a the excel file you can read its content using conn.NewReader() method.
Advance methods to Read Excel via GO API
The open source API Go-Excel provides basic as well as advance methods to read excel files. You can use th index row as title, e row before the tittle row will be ignored and default title row is set to 0. You can skip the empty rows, skip column larger than the title. The API allows setting empty cells with default values and you can set default values by using unmarshal via encoding.BinaryUnmarshaler