我有一些数据被写入CSV文件。当我在Excel文件中打开它们时，我看到它们在2列中。有没有一种方法可以添加多个标题并将值写入这些列？
随机数据：

public class DataTimeSeriesValues
{
    public string Name { get; set; }
    public string Unit { get; set; }
    public ICollection<DataValue> Values { get; set; }

    public static List<DataTimeSeriesValues> Get()
    {
        var tags = new List<DataTimeSeriesValues>();
        var random = new Random();
        var oil = new DataTimeSeriesValues
        {
            Name = "Oil",
            Unit = "bbl",
            Values = new List<DataValue>()
        };
        var gas = new DataTimeSeriesValues
        {
            Name = "Gas",
            Unit = "mmscf",
            Values = new List<DataValue>()
        };
        var water = new DataTimeSeriesValues
        {
            Name = "Water",
            Unit = "bbl",
            Values = new List<DataValue>()
        };

        for (int i = 0; i < 2; i++)
        {
            oil.Values.Add(new DataValue
            {
                Timestamp = DateTime.UtcNow.AddMinutes(i),
                Value = random.Next(1, 100).ToString()
            });
            gas.Values.Add(new DataValue
            {
                Timestamp = DateTime.UtcNow.AddMinutes(i),
                Value = random.Next(1, 100).ToString()
            });
            water.Values.Add(new DataValue
            {
                Timestamp = DateTime.UtcNow.AddMinutes(i),
                Value = random.Next(1, 100).ToString()
            });
        }

        tags.Add(oil);
        tags.Add(gas);
        tags.Add(water);

        return tags;
    }
}

public class DataValue
{
    public DateTime Timestamp { get; set; }

    public string Value { get; set; }
}

这就是我如何将数据写入CSV文件。

string csvPath = Path.Combine(folderPath, $ "{task.Name}_{DateTime.UtcNow:ddMMyyyyHHmmss}.csv");
var streamWriter = new StreamWriter(csvPath);

var csvWriter = new CsvWriter(streamWriter, CultureInfo.InvariantCulture);
List < DataTimeSeriesValues > tags = DataTimeSeriesValues.Get();

foreach(DataTimeSeriesValues tag in tags) {
  csvWriter.WriteField("Timestamp (UTC)");
  csvWriter.WriteField($ "{tag.Name} ({tag.Unit})");
  csvWriter.NextRecord();

  foreach(DataValue value in tag.Values) {
    csvWriter.WriteField(value.Timestamp);
    csvWriter.WriteField(value.Value);
    csvWriter.NextRecord();
  }
}

streamWriter.Flush();
streamWriter.Close();

这将产生如下输出fine：

Timestamp UTC,Oil (bbl)
09/12/2023 05:52:03,72
09/12/2023 05:53:03,98
Timestamp UTC,Gas (mmscf)
09/12/2023 05:52:03,21
09/12/2023 05:53:03,20
Timestamp UTC,Water (bbl)
09/12/2023 05:52:03,37
09/12/2023 05:53:03,45

但是，我需要新的标签被添加到下一列比在同一列时如下：

Timestamp UTC,Oil (bbl),Timestamp UTC,Gas (mmscf),Timestamp UTC,Water (bbl)
09/12/2023 05:52:03,72,09/12/2023 05:52:03,21,09/12/2023 05:52:03,37
09/12/2023 05:53:03,98,09/12/2023 05:53:03,20,09/12/2023 05:53:03,45

有没有办法做到这一点？