Qt写Excel文件程序代码 

 1 void writeDataToExcel::process()
 2 {
 3     QString fileName = QFileDialog::getSaveFileName(0, QObject::tr("Save File"), "", QObject::tr("file (*.csv)"));
 4     if ("" == fileName)
 5     {
 6         return;
 7     }
 8 
 9     QTextCodec *code = 0;
10     code = QTextCodec::codecForName("gb18030");
11     if (0 == code)
12     {
13         return;
14     }
15     std::string fileBuffer = code->fromUnicode(fileName).data();
16     FILE *fileWrite = fopen(fileBuffer.c_str(), "w");
17 
18     QString carryOut = "\n";
19     std::string content = code->fromUnicode(QString("Female") + "," + QString("Male") + "," + QString("NoMale") + carryOut +
20                                               QString().setNum(100) + "," + QString().setNum(101) + "," + QString().setNum(102)).data();
21 
22     QFile file;
23     file.open(fileWrite, QIODevice::WriteOnly);
24     file.write(content.c_str(), qstrlen(content.c_str()));
25     file.close();
26 }

posted on 2011-05-24 16:13  ActiveChange  阅读(2607)  评论(0)  编辑  收藏  举报

导航