如何创建schema.ini文件?我需要导出我的.csv文件到datagridview [英] How can I create schema.ini file? I need to export my .csv file to datagridview
本文介绍了如何创建schema.ini文件?我需要导出我的.csv文件到datagridview的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我要将 CSV 文件导出到datagridview。我需要创建文件 schema.ini
。但我不知道,我该如何创建呢?
I want to export a CSV file to a datagridview. I need to create the file schema.ini
. But I don't know, how can I create it?
有我的代码:
public DataTable exceldenAl(string excelFile)
{
try
{
string fileName = Path.GetFileName(excelFile);
string pathOnly = Path.GetDirectoryName(excelFile);
string cmd = "Select * From [" + fileName + "$]";
string cnstr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + pathOnly + "\\;Extended Properties=\"Text;HDR=Yes;FORMAT=Delimited\"";
OleDbConnection ocn = new OleDbConnection(cnstr);
ocn.Open();
OleDbCommand command = new OleDbCommand(cmd,ocn);
OleDbDataAdapter adap = new OleDbDataAdapter(command);
DataTable dt = new DataTable();
dt.Locale = CultureInfo.CurrentCulture;
adap.Fill(dt);
return dt;
}
finally {
}
}
private void btnExcelReader_Click(object sender, EventArgs e)
{
string dosya;
string cevap;
openFileDialog1.ShowDialog();
dosya = openFileDialog1.FileName.ToString();
ClsExcelReader er = new ClsExcelReader();
cevap = er.exceldenAl(dosya).ToString();
dataGridView1.DataSource = cevap;
//listViewExcelOku.DataBindings =
}
}
推荐答案
打开记事本并创建类似如下的文件:
Open up notepad and create a file similar to this:
[YourCSVFileName.csv]
ColNameHeader=True
Format=CSVDelimited
DateTimeFormat=dd-MMM-yyyy
Col1=A DateTime
Col2=B Text Width 100
Col3=C Text Width 100
Col4=D Long
Col5=E Double
修改上述文件以适合您的特定数据模式。
Modify the above file to fit your specific data schema. Save it as SCHEMA.ini in the same directory where your *.CSV file is located.
阅读此链接(将CSV文件导入数据库),这是一个很好的例子,让您了解Schema.ini的工作原理
Read this link (Importing CSV File Into Database), it is a good example to get you up and understanding how the Schema.ini works
这篇关于如何创建schema.ini文件?我需要导出我的.csv文件到datagridview的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文