
Writing Excel Files in Go With Excelize Step by Step
Write and read Excel files in Go with Excelize: create a workbook, typed cells and styles, the stream writer for big exports and a row iterator.
Tag
6 posts

Write and read Excel files in Go with Excelize: create a workbook, typed cells and styles, the stream writer for big exports and a row iterator.

Go ignores unknown JSON members by default. Reject them with DisallowUnknownFields, keep them with a raw map, and see where each option stops working.

Unmarshal XML into Go structs with tags, use a pointer for absent versus empty, catch bad booleans, and stream 200,000 orders in 0.8 seconds.

Decode JSON into Go structs with struct tags: null versus missing with pointers, case-insensitive keys, int64 ids, wrong-type errors and the omitempty trap.

Read and write CSV in Go with encoding/csv: quoting, field-count errors, LazyQuotes, the BOM it leaves in, ReuseRecord and 2,000,000 rows in 7 MB.

Ten languages read the same awkward CSV files: speed on 2,000,000 rows, BOM, bad quotes, ragged rows, leading zeros and defaults that bite, plus a test list.