首页 > 代码库 > 一个操作cvs格式的c++类
一个操作cvs格式的c++类
经常需要使用excel,或者把有的数据用excel打开,程序可以生成cvs格式的文件,这样就可以excel打开并处理了,于是找了一个处理cvs的c++类跟大家分享
代码出处找不到了:
代码如下:
StringParser.h
#pragma once #include <process.h> #include <Windows.h> #include <map> #include <vector> #include <queue> #include <set> #include <string> #include <list> typedef char i8; typedef unsigned char u8; typedef short i16; typedef unsigned short u16; typedef long int i32; typedef unsigned long u32; namespace StringParser{ //从分隔符中获得数据 inline int GetParamFromString(std::string Str, std::vector<i32>& IntVec, char Delim = ',') { char* p = strtok((char*)Str.c_str(), &Delim); while (p) { IntVec.push_back(atoi(p)); p = strtok(NULL, &Delim); } return IntVec.size(); } inline int GetParamFromString(std::string Str, std::vector<float>& FloatVec, char Delim = ',') { char* p = strtok((char*)Str.c_str(), &Delim); while (p) { FloatVec.push_back(atof(p)); p = strtok(NULL, &Delim); } return FloatVec.size(); } inline int GetParamFromString(std::string Str, std::vector<u32>& uiIntVec, char Delim = ',') { char* p = strtok((char*)Str.c_str(), &Delim); while (p) { uiIntVec.push_back(strtoul(p, NULL, 10)); p = strtok(NULL, &Delim); } return uiIntVec.size(); } inline int GetParamFromString(std::string Str, std::vector<std::string>& StringVec, char Delim = ',') { char* p = strtok((char*)Str.c_str(), &Delim); while (p) { std::string buffer = p; StringVec.push_back(buffer); p = strtok(NULL, &Delim); } return StringVec.size(); } //以左右符号得到括号中的数据ex:[3.1415;0.125][1000;9999] template<typename T> int GetParamFromArea(std::string Str, std::vector<std::vector<T> >& IntVec, char left = '[', char right = ']', char Delim = ';') { char* pTarget = (char*)Str.c_str(); for (;;) { char* pLeft = strchr(pTarget, left); char* pRight = strchr(pTarget, right); if (pLeft && pRight) { std::string strbuff; strbuff.insert(0, ++pLeft, pRight-pLeft); std::vector<T> Intbuff; if (GetParamFromString(strbuff, Intbuff, Delim)) { IntVec.push_back(Intbuff); } pTarget = ++pRight; } else { break; } } return IntVec.size(); } };
CCSVOperator.h
#pragma once #include "StringParser.h" class CCSVOperator { public: CCSVOperator(){}; ~CCSVOperator(){}; CCSVOperator(const char* path); bool LoadCSV(const char* path); bool SaveCSV(const char* path = NULL); bool GetInt(u32 uiLine, u32 uiRow, int& iValue); bool GetFloat(u32 uiLine, u32 uiRow, float& fValue); std::string* GetString(u32 uiLine, u32 uiRow); bool SetNumber(u32 uiLine, u32 uiRow, int iValue); bool SetNumber(u32 uiLine, u32 uiRow, float fValue); bool SetString(u32 uiLine, u32 uiRow, const char* pStr); std::map<u32, std::map<u32, std::string> >& GetCSVMap(){return m_StringKeyMap;} protected: std::string m_CSVName; std::map<u32, std::map<u32, std::string> > m_StringKeyMap; public: int indexOfLines; //行数 int indexOfColumn; //列数,有可能出现列长不一样的情况 };
CSVOperator.cpp
#include "CSVOperator.h" ////////////////////////////////////////////////////////////////////////// //CSV operator CCSVOperator::CCSVOperator(const char* path) { LoadCSV(path); } bool CCSVOperator::LoadCSV(const char* path) { indexOfLines = 0; indexOfColumn = 0; FILE* pfile = fopen(path, "r"); if (pfile) { fseek(pfile,0,SEEK_END); u32 dwsize = ftell(pfile); rewind(pfile);// 指针回到文件开头 char* filebuffer = new char[dwsize]; fread(filebuffer, 1, dwsize, pfile); std::map<u32, std::string> StringMap; char* pBegin = filebuffer; char* pEnd = strchr(filebuffer, '\n');//查找换行首次出现的位置 u32 uiIndex = 1; while (pEnd != NULL) { std::string strbuff; strbuff.insert(0, pBegin, pEnd-pBegin); if (!strbuff.empty()) { StringMap[uiIndex] = strbuff; } pBegin = pEnd + 1; pEnd = strchr(pEnd + 1, '\n'); ++uiIndex; } indexOfLines = uiIndex - 1; delete[] filebuffer; std::map<u32, std::string>::iterator iter = StringMap.begin(); for (; iter != StringMap.end(); ++iter) { std::vector<std::string> StringVec; std::map<u32, std::string> l_StringMap; StringParser::GetParamFromString(iter->second, StringVec); if (indexOfColumn< StringVec.size()) { indexOfColumn = StringVec.size();//保存最大的列数 } for (int i = 0; i < StringVec.size(); ++i) { l_StringMap[i+1] = StringVec.at(i); } m_StringKeyMap[iter->first] = l_StringMap; } fclose(pfile); m_CSVName = path; return true; } return false; } bool CCSVOperator::GetInt(u32 uiLine, u32 uiRow, int& iValue) { std::string* pKey = GetString(uiLine, uiRow); if (pKey) { iValue = http://www.mamicode.com/atoi(pKey->c_str());>
CVS_OP.CPP
// CSV_OP.cpp : 定义控制台应用程序的入口点。 // #include "stdafx.h" #include "CSVOperator.h" #include <iostream> using namespace std; int _tmain(int argc, _TCHAR* argv[]) { CCSVOperator CSVOperator; CSVOperator.LoadCSV("画图数据.csv"); cout<<"line: "<<CSVOperator.indexOfLines<<endl; cout<<"column: "<<CSVOperator.indexOfColumn<<endl; std::string* pString = CSVOperator.GetString(1,600); if (pString) { std::cout<< pString->c_str() << '\n'; } pString = CSVOperator.GetString(2,4); if (pString) { std::cout<< pString->c_str() << '\n'; } //std::string* pString = NULL; int j = 0; for (int i = 0,nColConut = CSVOperator.indexOfColumn;i < nColConut ; ++i) { if(pString = CSVOperator.GetString(1,i+1)) { //m_listctrl.InsertColumn(j ,pString->c_str(), LVCFMT_CENTER, 50); // 添加第1列, //cout<<"\t"<<&pString; cout<<"\t"; printf(pString->c_str()); ++j; } } // int _int = 0; // if (CSVOperator.GetInt(3,1,_int)) // { // std::cout<< _int <<'\n'; // } // float _float = 0.0f; if (CSVOperator.GetFloat(4,1, _float)) { std::cout<< _float<<'\n'; } system("pause"); return 0; }
效果如下:
一个操作cvs格式的c++类
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。