C++直接读取Excel文档比较麻烦,这里用了一直取巧的方式(因为紧紧是处理一些URL)。首先把.xls格式另存为.csv格式,然后就可以直接读取文件了。
C++代码如下:
int main(int argc,char *argv[])
{
ifstream fin("E:/c++_python/zte/Example_test.csv");
string line;
string linkURL;
string fromlinkURL;
if (fin.is_open())
{
int count=0;
while (fin>>line)
{
linkURL = line.substr(0,line.find(',',0));
cout<<linkURL<<endl;
fromlinkURL = line.substr(line.find(',',0)+1,line.length()-line.find(',',0));
cout<<linkURL<<" "<<fromlinkURL<<endl;
count+=1;
// Sleep(1000);
}
cout<<count<<endl;
}
return 0;
}