QT中将standmodel数据写入excel

 

void ImportToExcel(QStandardItemModel *model)
{
    QString fileName = QFileDialog::getSaveFileName(this, tr("Save File"),"",tr("file(*.CSV)"));
    if(fileName == "")
        return;

    QTextCodec *code;
    code = QTextCodec::codecForName("gb18030");
    std::string strbuffer = code->fromUnicode(fileName).data();
    FILE *fileWrite = fopen( strbuffer.c_str(),"w");

    QString strStream;
    for(int i=0; i< model->columnCount(); i++)
        strStream += model->headerData(i,Qt::Horizontal,0).toString()+",";
    strStream +="\n";

    for(int i=0; i<model->rowCount(); i++)
    {
        QString value;
        for(int j=0; j<model->columnCount(); j++)
        {

            value +=model->item(i,j)->text()+",";

        }
        strStream += value+"\n";

    }

    std::string strCountbuffer = code->fromUnicode(strStream).data();
    QFile file;
    file.open(fileWrite, QIODevice::WriteOnly);
    file.write(strCountbuffer.c_str(), qstrlen(strCountbuffer.c_str()));
    file.close();
}