c#读取csv文件显示在timetable中
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.IO;
using Csv;
namespace Excel
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
var Lines=CsvReader.ReadFromText(File.ReadAllText(@"C:\result2.csv"),
new CsvOptions(){HeaderMode=HeaderMode.HeaderPresent});
foreach (var item in Lines.ElementAt(0).Headers)
{
dataGridView1.Columns.Add(item, item);
}
foreach(var item in Lines)
{
var RowIndex=dataGridView1.Rows.Add();
for (var ColumnIndex = 0;
ColumnIndex < dataGridView1.Columns.Count; ColumnIndex++)
{
dataGridView1.Rows[RowIndex].Cells[ColumnIndex].Value = item[ColumnIndex];
}
}
}
}
}