在c# WPF中高效地转置csv文件中的行和列。

using System;
using System.IO;

public class CSVTransposer
{
    public static void TransposeCSV(string inputFilePath, string outputFilePath)
    {
        // 读取CSV文件
        string[] lines = File.ReadAllLines(inputFilePath);

        // 获取行数和列数
        int rowCount = lines.Length;
        int colCount = lines[0].Split(',').Length;

        // 创建转置后的二维数组
        string[,] transposedData = new string[colCount, rowCount];

        // 解析CSV数据并转置
        for (int i = 0; i < rowCount; i++)
        {
            string[] cells = lines[i].Split(',');
            for (int j = 0; j < colCount; j++)
            {
                transposedData[j, i] = cells[j];
            }
        }

        // 写入转置后的数据到新的CSV文件
        using (StreamWriter writer = new StreamWriter(outputFilePath))
        {
            for (int i = 0; i < colCount; i++)
            {
                for (int j = 0; j < rowCount; j++)
                {
                    writer.Write(transposedData[i, j]);
                    if (j != rowCount - 1)
                    {
                        writer.Write(",");
                    }
                }
                writer.WriteLine();
            }
        }
    }
}

// 使用示例
string inputFilePath = "input.csv";
string outputFilePath = "output.csv";
CSVTransposer.TransposeCSV(inputFilePath, outputFilePath);