将来自多个单元格的数据合并到一个JSON对象中

Question

I am trying to combine data from multiple cells from an excel spreadsheet into one JSON encoded string. I cannot figure out how to do so, the code below is creating a new JSON object per cell. How do I differentiate the cells to combine into the same JSON string?

package main

import (
    "fmt"
    "github.com/tealeg/xlsx"
    "encoding/json"

)

func main() {
    excelFileName := "/Users/isaacmelton/Desktop/Test_Data.xlsx"
    xlFile, err := xlsx.OpenFile(excelFileName)
    if err != nil {
        fmt.Printf("Cannot parse data")
    }
    for _, sheet := range xlFile.Sheets {
        for _, row := range sheet.Rows {

            fmt.Printf("
")
            for x, cell := range row.Cells {
                if x == 3 || x == 5 {
                    data := map[string]string{"d_name": cell.String(), "name": cell.String()}
                    json_data, _ := json.Marshal(data)

                    fmt.Println(string(json_data))
                }
            }
        }
    }
}

Running the above code results in the following:

{"foo":"cell1","bar":"cell1"}
{"foo":"cell2","bar":"cell2"}

I expect something like this:

{"foo":"cell1", "bar":"cell2"}

Answer 1

If I right understand your request you just need to define root element, add cells into it and marshal this element rather than individual cells.

root := []map[string]string{}
for x, cell := range row.Cells {
    if x == 3 || x == 5 {
        root = append(root, map[string]string{"d_name": cell.String(), "name": cell.String()})
    }
}
json_data, _ := json.Marshal(root)
fmt.Println(string(json_data))

http://play.golang.org/p/SHnShHvW_0