利用basicExcel在qt中实现对xls文件的读取和另存为操作。

 1 errcode ExcelParse::xlsControl(const char *pathfile,QString outPutPath)
 2 {
 3     //1 路径中文处理
 4     QString cpath =  QString::fromUtf8(pathfile);
 5     //cpath.replace(‘/‘, ‘\\‘);
 6     qDebug()<<"after replace : " <<cpath<<" "<<cpath.length();
 7     //输出文件调试信息
 8     char outbuf[255];
 9     utf8_unicode((unsigned char*)cpath.toUtf8().constData(), (unsigned char*)outbuf, -1);
10     qDebug()<<"the outbuf " <<QTextCodec::codecForName("gbk")->toUnicode(outbuf);
11 
12     QString strT3 = QTextCodec::codecForName("UTF-8")->toUnicode(cpath.toUtf8());
13     QByteArray gbkstr = QTextCodec::codecForName("GB18030")->fromUnicode(strT3);
14 
15     //2 文件打开
16     if (parse.Load(gbkstr.constData()))
17     {
18         int sheetcnt = parse.GetTotalWorkSheets();
19         qDebug()<<"sheet count"<<sheetcnt;
20         char sheetname[255];
21         QByteArray sheetgbkstr;
22         //3 获取表单名称
23         wchar_t wsheetname[255] = {0};
24         if (!parse.GetSheetName(0, sheetname))
25         {
26             parse.GetSheetName(0, wsheetname);
27             sheetgbkstr = QTextCodec::codecForName("GB18030")->fromUnicode((QChar*)&wsheetname[0], 255);
28             qDebug()<<"sheet gbkstr"<<sheetgbkstr<<QString::fromWCharArray(wsheetname);
29         }
30         //4 打开表单
31         BasicExcelWorksheet* sheet = parse.GetWorksheet(wsheetname);
32         if(sheet==NULL)
33         {
34             qDebug()<<"sheet null"<<parse.GetTotalWorkSheets();
35             return ERR_SMALL_WORKSEET;
36         }
37         //5 写入数据
38         for(int i=0;i<10;i++)
39         {
40             QString cc=QString::number(i);//tableTitle.split(‘,‘).at(i).left(tableTitle.split(‘,‘).at(i).count()-1);
41             wchar_t mm[100];
42             mm[cc.toWCharArray(mm)]=0;
43             sheet->Cell(7,i)->SetWString(mm);
44         }
45         //6 文件保存
46         QTextCodec *code = QTextCodec::codecForName("gbk");
47         std::string name = code->fromUnicode(outPutPath).data();
48         qDebug()<<"xls save="<<parse.SaveAs(name.c_str());
49         return ERR_NORMAL;
50     }
51     else
52     {
53         qDebug()<<"bad xls";
54     }
55     return ERR_BAD_FILE;
56 }