QXlsx读写

WriteXlsxFile

    QXlsx::Document xlsx;

    QStringList list = xlsx.sheetNames();

    for(int i =0; i < list.size(); ++i)//删除所有sheet
    {
        xlsx.deleteSheet(list[i]);
    }

    HStrTable* table;
    HStr str;
    QString qs;
    map<int, HNDimMtx<HStr>*>::iterator it;
    for(int i = 0; i < tables.size(); ++i)
    {
        table = tables[i];
        QString tableName = table->dmName.data();
        if(!xlsx.selectSheet(tableName)) //select 选中当前表（依据表名称）
        {
            xlsx.addSheet(tableName); //添加表
        }
        else
        {
            tableName= QObject::tr("sheet%1").arg(i);
            xlsx.addSheet(tableName);
        }


        int ik = 0,jk = 0;
        if(table->dmFieldNames.size() > 0)
        {
            for(jk =0; jk < table->dmFieldNames.size(); jk++)
            {
                str = table-&g