Golang的encoding/csv如何读写复杂数据 处理带BOM头的CSV文件方案

encoding/csv

\xEF\xBB\xBF

os.Open

csv.NewReader

file, err := os.Open("data.csv")
if err != nil {
    log.Fatal(err)
}
defer file.Close()

// 读取前几个字节判断是否是BOM
bom := make([]byte, 3)
n, _ := file.Read(bom)
if n >= 3 && bom[0] == 0xEF && bom[1] == 0xBB && bom[2] == 0xBF {
    // 跳过BOM
} else {
    file.Seek(0, io.SeekStart) // 没有BOM就回退指针
}

reader := csv.NewReader(file)
records, err := reader.ReadAll()

encoding/csv

type User struct {
    Name string
    Age  int
    City string
}

users := []User{
    {"Alice", 25, "Beijing"},
    {"Bob", 30, "Shanghai"},
}

file, _ := os.Create("users.csv")
writer := csv.NewWriter(file)

// 写入表头
writer.Write([]string{"Name", "Age", "City"})

for _, u := range users {
    writer.Write([]string{u.Name, strconv.Itoa(u.Age), u.City})
}

writer.Flush()

reader := csv.NewReader(file)
records, _ := reader.ReadAll()

for _, row := range records[1:] { // 跳过表头
    age, _ := strconv.Atoi(row[1])
    user := User{
        Name: row[0],
        Age:  age,
        City: row[2],
    }
    // 做你想做的操作
}

"Hello, world!",This is line one.
This is line two.,Some "quoted" text

writer.Write([]string{
    "Hello, world!",
    "This is line one.\nThis is line two.",
    "Some \"quoted\" text",
})

csv.Writer

Write()

encoding/csv