文件操作——将数据导出到Excel

最新推荐文章于 2022-06-02 15:53:41 发布

南极圈

最新推荐文章于 2022-06-02 15:53:41 发布

阅读量932

点赞数

分类专栏：其他文章标签： CC++ excel 数据导出

本文链接：https://blog.csdn.net/barry8865/article/details/76584529

版权

其他专栏收录该内容

4 篇文章 0 订阅

订阅专栏

将数据导出到Excel（.csv）表格中

#include <string>
#include <fstream>
using namespace std;

void TestFileOut()
{
	OPENFILENAME ofn = { 0 };
	ofn.lStructSize = sizeof(OPENFILENAME);
	TCHAR strFileName[MAX_PATH] = { 0 };
	ofn.lpstrFile = strFileName;
	ofn.nMaxFile = MAX_PATH;
	ofn.lpstrFilter = L".csv";
	ofn.hwndOwner = GetHWND();
	ofn.lpstrDefExt = L"csv";
	ofn.Flags = OFN_PATHMUSTEXIST | OFN_HIDEREADONLY | OFN_OVERWRITEPROMPT;
	if (::GetSaveFileName(&ofn))
	{
		//TCHAR转string
		int iLen = WideCharToMultiByte(CP_ACP, 0, strFileName, -1, NULL, 0, NULL, NULL);
		char* chRtn = new char[iLen * sizeof(char)];
		WideCharToMultiByte(CP_ACP, 0, strFileName, -1, chRtn, iLen, NULL, NULL);
		std::string str(chRtn);

		//文件操作
		ofstream ofs;
		ofs.open(str.c_str(), ios::out | ios::trunc);

		ofs << "用户编号" << "," << "用户姓名" << "," << "操作对象" << "," << "操作类型" << "," << "操作时间" << endl;
		//string userId, userName, Obj, Type, Time;
		for (int i=0;i<5;i++)
		{
			ofs << "123" << "," << "马云" << "," << "锤子" << "," << "支付宝" << "," << "2017" << endl;
		}

		ofs.close();
	}
}