-->

读取与写入csv文件

2019-11-20 00:12发布

csv文件与txt文件一样,可以直接用stdio.h中的函数读取和写入

#pragma warning(disable:4996)
#include<cstdio>
#include<cstring>
#include<string>
#include<vector>

using namespace std;




int main()
{
	string path = "G:\\data\\QCFS\\";

	vector<string> csv(25);
	csv[0] = "150-magn-lowdata-2017-07-01~2017-08-01.csv";
	csv[1] = "150-magn-lowdata-2017-08-01~2017-09-01.csv";
	csv[2] = "150-magn-lowdata-2017-09-01~2017-10-01.csv";
	csv[3] = "150-magn-lowdata-2017-10-01~2017-11-01.csv";
	csv[4] = "150-magn-lowdata-2017-11-01~2017-12-01.csv";
	csv[5] = "150-magn-lowdata-2017-12-01~2018-01-01.csv";
	csv[6] = "150-magn-lowdata-2018-01-01~2018-02-01.csv";
	csv[7] = "150-magn-lowdata-2018-02-01~2018-03-01.csv";
	csv[8] = "150-magn-lowdata-2018-03-01~2018-04-01.csv";
	csv[9] = "150-magn-lowdata-2018-04-01~2018-05-01.csv";
	csv[10] = "150-magn-lowdata-2018-05-01~2018-06-01.csv";
	csv[11] = "150-magn-lowdata-2018-06-01~2018-07-01.csv";
	csv[12] = "150-magn-lowdata-2018-07-01~2018-08-01.csv";
	csv[13] = "150-magn-lowdata-2018-08-01~2018-09-01.csv";
	csv[14] = "150-magn-lowdata-2018-09-01~2018-10-01.csv";
	csv[15] = "150-magn-lowdata-2018-10-01~2018-11-01.csv";
	csv[16] = "150-magn-lowdata-2018-11-01~2018-12-01.csv";
	csv[17] = "150-magn-lowdata-2018-12-01~2019-01-01.csv";
	csv[18] = "150-magn-lowdata-2019-01-01~2019-02-01.csv";
	csv[19] = "150-magn-lowdata-2019-02-01~2019-03-01.csv";
	csv[20] = "150-magn-lowdata-2019-03-01~2019-04-01.csv";


	FILE* fp = fopen((path + "data.csv").c_str(), "w");
	//输入第一行索引
	fputs("Date,Average,Timestamp\n", fp);
	for (int i = 0; i <= 20; i++)
	{
		FILE* fcsv = fopen((path + csv[i]).c_str(), "r");
		char str[1024];
		//扔掉第一行索引
		fgets(str, sizeof(str), fcsv);
		while (fgets(str, sizeof(str), fcsv) != NULL)
			fputs(str, fp);
		fclose(fcsv);
	}
	fclose(fp);

}
标签: