如何将.CSV文件读取到类(C#)的数组中

本文关键字:数组 CSV 文件 读取 | 更新日期: 2023-09-27 18:00:37

我正试图将.csv文件中的3个值拉入一个名为PizzaOrder的类数组中。.csv文件是使用同一程序创建的。我在弄清楚如何将.csv中的值插入PizzaOrder数组时遇到了问题。

这是到目前为止表单的代码:

 public partial class Form1 : Form
{
    PizzaOrder[] pizzaArray = new PizzaOrder[4];
    PizzaOrder[] ReadPizzaArray = new PizzaOrder[4];
    public Form1()
    {
        InitializeComponent();
    }
    private void Form1_Load(object sender, EventArgs e)
    {
        //this is just creating the values and inserting into the array
        PizzaOrder p1 = new PizzaOrder(12, "Pepperoni", 14.88m);
        PizzaOrder p2 = new PizzaOrder(15, "Mushrooms", 15.69m);
        PizzaOrder p3 = new PizzaOrder(13, "Bacon", 15.33m);
        PizzaOrder p4 = new PizzaOrder(16, "Olives", 17.47m);
        pizzaArray[0] = p1;
        pizzaArray[1] = p2;
        pizzaArray[2] = p3;
        pizzaArray[3] = p4;
    }
    private void btnDisplay_Click(object sender, EventArgs e)
    {
       //this is just displaying the contents of the array in a listbox
        lstOrders.Items.Clear();
        for(int loop = 0; loop < pizzaArray.Length; loop++)
        {
            lstOrders.Items.Add(pizzaArray[loop].ShowOrder());
        }
    }
    private void btnSave_Click(object sender, EventArgs e)
    {
     //this is where the .csv file is being created and saved to
        StreamWriter SavePizza = new StreamWriter("PizzaFile.csv", true);
        try
        {
            for (int loop = 0; loop < pizzaArray.Length; loop++)
            {
                SavePizza.Write(pizzaArray[loop].ShowOrder()+ Environment.NewLine);
            }
        }
        catch(System.Exception)
        {
            MessageBox.Show("A file write error has occured...", "File Error");
        }
        finally
        {
            SavePizza.Close();   
        }
    }
    private void button1_Click(object sender, EventArgs e)
    {
      //this is where I am attempting to read from the .csv
        StreamReader ReadPizza = new StreamReader(File.OpenRead("PizzaFile.csv"));
        try
        {
            string input = ReadPizza.ReadToEnd();
            string[] PizzaRead = input.Split(',');
            for (int loop2 = 0; loop2 < ReadPizzaArray.Length; loop2++)
            {
             //this is where I'm trying to insert from the .csv into the array again, where the problem is
                ReadPizzaArray[loop2] = (PizzaRead[0], PizzaRead[1], PizzaRead[2]);
            }
        }
        catch(System.Exception)
        {
            MessageBox.Show("An error occured during the file read...","File Read Error");
        }
        finally
        {
            ReadPizza.Close();
        }
    }
}

PizzaOrder类接受按该顺序排列的int、sting和decimal。.csv中的信息需要按原样添加。

如有任何信息和/或指导,我们将不胜感激!谢谢

如何将.CSV文件读取到类(C#)的数组中

您需要创建一个新的PizzaOrder对象来完成此操作。除此之外,您还需要转换为正确的数据类型。以下是示例代码:

for (int loop2 = 0; loop2 < ReadPizzaArray.Length; loop2++)
        {
            ReadPizzaArray[loop2] = new PizzaOrder(Convert.ToInt32(PizzaRead[0]), PizzaRead[1].ToString(), Convert.ToDecimal(PizzaRead[3]));
        }

除此之外,您还应该了解一些编码标准。局部变量通常不大写。列表可能比数组更有效,因为您不知道不同CSV文件会有多少条目。

除了oppasum的答案之外,似乎在用逗号分隔每一行之前,您没有按行分隔csv。

        string input = ReadPizza.ReadToEnd();
        string[] lines = input.Split(new[] { Environment.NewLine}, StringSplitOptions.RemoveEmptryEntries);
        foreach (string line in lines)
        {
           string[] PizzaRead = line.Split(',');
           //Insert oppassum's answer here...
        }

使用file.ReadAllLines()读取文件,并使用String.Splitt()和String.Trim():

var lines = File.ReadAllLines("PizzaFile.csv")
List<PizzaOrder> orders = new List<PizzaOrder>();
foreach (var line in lines)
{
    var fields = line.Split(',');
    PizzaOrder order = new PizzaOrder()
    {
        Id = Convert.ToInt32(fields[0].Trim());
        Type = fields[1].Trim();
        // etc.
    }
}
var result = orders.ToArray();