I'm new on the go lang.I want to read an excel file for procees it later, but I don't know how to read the file in go? Anyone can show me an example ?
To restore your new file without any saved updates, open Microsoft Excel first. Then, click Open on the File tab on the Ribbon. At the bottom of the page, after selecting Recent, click Recover Unsaved Workbooks. You'll then be able to select any unsaved file in the Open window.
In golang, Excelize is a library used to read and write Excel files. This package comes with the API for better working with the sheets and it supports various file formats like xlsx, xlsm, etc. Using @latest at the end is to get the latest version for ease.
Extracting data from a closed file in another workbook is a common request by most of the excel user. They would like to pull or consolidate data from closed files; however, this is not possible.
I haven't tried it but there's an xlsx package.
Install it with
go get -v github.com/tealeg/xlsx
Read the documentation and come back here with some code you've tried if you get stuck.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With