private void btnOpen_Click(object sender, RoutedEventArgs e)
{
OpenFileDialog open = new OpenFileDialog();
open.Title = "打开文件";
open.Filter = "文件（.txt）|*.txt|所有文件|*.*";
if((bool)open.ShowDialog().GetValueOrDefault())
{
csvFilePath = open.FileName;
lblReulstMsg.Content = "文件导入成功，请查看导入文件内容";
using (SimpleCSVReader reader = new SimpleCSVReader(csvFilePath)) {
reader.Splitter = '\t';
reader.ReadHeader();
Dictionary<string, int> dict = reader.HeaderMap;
comBoxList.Items.Clear();
LogHelper.WriteLog("原文件中的列名：");
LogHelper.WriteLog("####################################################################");
foreach (var item in dict)
{
int index = (int)item.Value - 1;
comBoxList.Items.Add(index.ToString() + "<<-->>" + item.Key.ToString());
LogHelper.WriteLog(item.Key.ToString());
}
LogHelper.WriteLog("####################################################################");
}
}
}
public CSVHelper(string filePath, char spliter)
{
try
{
reader = new SimpleCSVReader(filePath);
reader.Splitter = spliter;
reader.ReadHeader();
Header = new List<string>();
foreach (var item in reader.HeaderMap)
{
Header.Add(item.Key.ToString());
}
DataTable dt = new DataTable();
foreach (var item in Header)
{
if (!dt.Columns.Contains(item))
dt.Columns.Add(item, Type.GetType("System.String"));
}
while (reader.ReadLine())
{
DataRow dr = dt.NewRow();
foreach (var item in Header)
{
dr[item] = reader[item];
}
dt.Rows.Add(dr);
}
CsVTable = dt;
}
catch (Exception ex)
{
LogHelper.WriteLog(ex.Message,ex);
}
}