diff options
Diffstat (limited to 'pkg/datamaps/writer.go')
-rw-r--r-- | pkg/datamaps/writer.go | 40 |
1 files changed, 40 insertions, 0 deletions
diff --git a/pkg/datamaps/writer.go b/pkg/datamaps/writer.go new file mode 100644 index 0000000..9a7015b --- /dev/null +++ b/pkg/datamaps/writer.go @@ -0,0 +1,40 @@ +package datamaps + +import ( + "log" + "path/filepath" + + "github.com/tealeg/xlsx/v3" +) + +func ExportMaster(opts *Options) error { + // A master represents a set of file data from the database. Actually, in terms of the database, + // it should represent a "return". + // + // The meat of the master is of the format: + // Key 1 | Key_1_Value_for_FD_1 | Key_1_Value_for_FD_2 | Key_1_Value_for_FD_3 | ... etc + // Key 2 | Key_2_Value_for_FD_1 | Key_2_Value_for_FD_2 | Key_2_Value_for_FD_3 | ... etc + // Key 3 | Key_3_Value_for_FD_1 | Key_3_Value_for_FD_2 | Key_3_Value_for_FD_3 | ... etc + // ... + // Could be represented as a slice or a map[string][]string + + // filename := filepath.Join(opts.MasterOutPutPath, "master.xlsx") + wb := xlsx.NewFile() + sh, err := wb.AddSheet("Master Data") + + testRow, err := sh.Row(1) + if err != nil { + log.Fatal(err) + } + if sl := testRow.WriteSlice([]string{"Hello", "Bollocks", "Knackers", "Bottyies"}, -1); sl == -1 { + log.Printf("not a slice type") + } + log.Printf("writing slice to row\n") + + log.Printf("saving master at %s", opts.MasterOutPutPath) + if err := wb.Save(filepath.Join(opts.MasterOutPutPath, "master.xlsx")); err != nil { + log.Fatalf("cannot save file to %s", opts.MasterOutPutPath) + } + sh.Close() + return nil +} |