Install

go get github.com/devlights/goxcel@latest

Usage

Import statement

package mainimport ("github.com/devlights/goxcel")funcinit() {log.SetFlags(0)}// main is entry point of this app.funcmain() {ret,xlsx:=run()ifret==0 {// Launch EXCEL_=exec.Command("cmd","/C",xlsx).Run()}os.Exit(ret)}funcrun() (int,string) {// 0. Initialize Goxcelquit:=goxcel.MustInitGoxcel()deferquit()// 1. Create new Goxcel instance.excel,release:=goxcel.MustNewGoxcel()// must call goxcel release function when function exited// otherwise excel process was remained.deferrelease()// optional settingsvisible:=falseexcel.MustSilent(visible)// 2. Get Workbooks instance.wbs:=excel.MustWorkbooks()// 3. Add Workbookwb,wbRelease:=wbs.MustAdd()// call workbook's release functiondeferwbRelease()// 4. Get Worksheetws:=wb.MustSheets(1)// 5. Get Cellc:=ws.MustCells(1,1)// 6. Set the value to cellc.MustSetValue("こんにちはWorld")p:=filepath.Join(os.TempDir(),"helloworld.xlsx")log.Printf("SAVE FILE: %s\n",p)// 7. Savewb.MustSaveAs(p)// Workbook::SetSaved(true) and Workbook::Close() is automatically called when `defer wbReleaseFn()`.// Excel::Quit() and Excel::Release() is automatically called when `defer release()`.return0,p}