导入导出CSV

最新推荐文章于 2023-10-26 18:30:12 发布

anban5298

最新推荐文章于 2023-10-26 18:30:12 发布

阅读量159

点赞数

原文链接：http://www.cnblogs.com/xffy1028/p/4501353.html

版权

const string dataPath = @"D:\Users\jin_h\Documents\Visual Studio 2013\Projects\ConsoleApplication1\ConsoleApplication1\";



private static DataTable GetCsvData(string filePath, string fileName)
        {
            string connString = @"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" + filePath + ";Extensions=asc,csv,tab,txt;";
            try
            {
                using (var odbcConn = new OdbcConnection(connString))
                {
                    odbcConn.Open();
                    var oleComm = new OdbcCommand();
                    oleComm.Connection = odbcConn;
                    oleComm.CommandText = "select * from [" + fileName + "#csv]";
                    var adapter = new OdbcDataAdapter(oleComm);
                    var ds = new DataSet();
                    adapter.Fill(ds, fileName);
                    return ds.Tables[0];
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }



 private static string ExportCSV(IEnumerable<ErrorData> errorDate)
        {
            var sbBuilder = new StringBuilder();
            string[] title = { "ScenciSpotID", "DistrictNamePath", "GeographicRegionKeyword", "NoMatchField" };

            foreach (var t in title)
            {
                sbBuilder.Append(t + ",");
            }
            sbBuilder.Append("\n");
            foreach (var field in errorDate)
            {
                sbBuilder.Append(field.ScenciSpotID + ",");
                sbBuilder.Append(field.DistrictNamePath + ",");
                sbBuilder.Append(field.GeographicRegionKeyword + ",");
                sbBuilder.Append(field.NoMatchField + ",");
                sbBuilder.Append("\n");
            }
            return sbBuilder.ToString();
        }