用Qt把数据写入Excel 中

Question

1. QString fileName = QFileDialog::getSaveFileName(this, tr("Save File"),
2.         "",
3.         tr("file ( *.CSV)"));
4. if(fileName == "")
5.         return;
7. QTextCodec *code;
8. code = QTextCodec::codecForName("gb18030");
10. std::string strbuffer = code->fromUnicode(fileName).data();
11. FILE *fileWrite = fopen( strbuffer.c_str(),"w");
12. QString strFemale = "Female Count";
13. QString strMale = "Male Count";
14. QString strPatientCount = "Patient Count";
15. QString str ="n";
16. std::string strCountbuffer = code->fromUnicode(strFemale+","+
17.         strMale+","+strPatientCount+str+QString().setNum(femaleCount)+","+
18.         QString().setNum(maleCount)+","+QString().setNum(patientCount)).data();
19. QFile file;
20. file.open(fileWrite, QIODevice::WriteOnly);
21. file.write(strCountbuffer.c_str(), qstrlen(strCountbuffer.c_str()));        
22. file.close();

复制代码

Answer 1

还不如写成xml格式的表格，只是文件要大些，但是格式好看得多。