Simple .xlsx (Excel XML document) template based document generator using handlebars.
Takes input .xlsx documents with mustache sippets in it and renders new document with snippets replaced by provided context.
Thanks to github.com/tealeg/xlsx and github.com/aymerick/raymond for useful libs.
go get -u "github.com/ivahaev/go-xlsx-templater"
import "github.com/ivahaev/go-xlsx-templater"Filename may be any of course. For slices use dot notation {{items.name}}. When parser meets dot notation it will repeats contains row. If you need repeat few rows, or have nested slices, you can use range start {{range groups}} and {{end}}.
ctx := map[string]interface{}{
"name": "Github User",
"groupHeader": "Group name",
"nameHeader": "Item name",
"quantityHeader": "Quantity",
"groups": []map[string]interface{}{
{
"name": "Work",
"total": 3,
"items": []map[string]interface{}{
{
"name": "Pen",
"quantity": 2,
},
{
"name": "Pencil",
"quantity": 1,
},
},
},
{
"name": "Weekend",
"total": 36,
"items": []map[string]interface{}{
{
"name": "Condom",
"quantity": 12,
},
{
"name": "Beer",
"quantity": 24,
},
},
},
},
}Error processing omited in example.
doc := xlst.New()
doc.ReadTemplate("./template.xlsx")
doc.Render(ctx)
doc.Save("./report.xlsx")
type Xlst struct {
// contains filtered or unexported fields
}Xlst Represents template struct
func New() *XlstNew() creates new Xlst struct and returns pointer to it
func (m *Xlst) ReadTemplate(path string) errorReadTemplate() reads template from disk and stores it in a struct
func (m *Xlst) Render(ctx map[string]interface{}) errorRender() renders report and stores it in a struct
func (m *Xlst) Save(path string) errorSave() saves generated report to disk
func (m *Xlst) Write(writer io.Writer) errorWrite() writes generated report to provided writer
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent