读取csv文件(C#,C++)

最新推荐文章于 2023-07-27 20:20:06 发布

todayq

最新推荐文章于 2023-07-27 20:20:06 发布

阅读量1.1k

点赞数 1

分类专栏： code

本文链接：https://blog.csdn.net/dan1900/article/details/17116591

版权

code 专栏收录该内容

91 篇文章 0 订阅

订阅专栏

C++代码

#include <fstream>
#include <sstream>
#include <iostream>

using namespace std;
void ReadCSV()
{
    ifstream inf;
    inf.open("test.csv", ifstream::in);         
  
    string line;	
    int j=0;   
    size_t comma = 0;
    size_t comma2 = 0;
      
    getline(inf,line);//第一行是列名，排除
	while (!inf.eof())
	{
		getline(inf,line);
		comma = line.find(',',0);//默认行内分割符为逗号，若为空格，做相应调整
		while (comma < line.size() && j != marknum+2)
			{
				comma2 = line.find(',',comma + 1);				
			
				cout<<atof(line.substr(comma + 1,comma2-comma-1).c_str())<<endl;//读出一个列元素，并将其转化成float类型
				
				comma = comma2;
				j++;
			}			
			j = 0;
			
		}


	}
  
    inf.close();
}

C#代码

  private DataTable GetCsvData(string filePath, string fileName)
        {

            string path = filePath + "\\" + fileName + ".csv";

            string connString = @"Driver={Microsoft Text Driver (*.txt; *.csv)};
            Dbq=" + filePath + ";Extensions=csv";
            try
            {
                using (OdbcConnection odbcConn = new OdbcConnection(connString))
                {

                    odbcConn.Open();

                    OdbcCommand oleComm = new OdbcCommand();

                    oleComm.Connection = odbcConn;

                    oleComm.CommandText = "select * from [" + fileName + "#csv]";

                    OdbcDataAdapter adapter = new OdbcDataAdapter(oleComm);

                    DataSet ds = new DataSet();

                    adapter.Fill(ds, fileName);

                    odbcConn.Close();

                    return ds.Tables[0];
                }
            }

            catch (Exception ex)
            {

                throw ex;
            }
        }
 private void ReadCSV()
        {
            DataTable dt = GetCsvData("path", "filename");
            int sidx = 0;           
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                DataRow drOperate = dt.Rows[i];
                for (int j = 0; j < drOperate.ItemArray.Length; j++)                   
                    {
                        cout<<drOperate[j])<<endl;
                    }                    
            }
        }