Qt数据库应用之实现csv文件转xls

QString DataOther::csvToXls(DataContent &dataContent, const QString &csvFile, const QString &xlsFile, bool quatation, const QString &spliter)
{
    //为空则同名文件
    QString fileName = xlsFile;
    if (fileName.isEmpty()) {
        fileName = csvFile;
        fileName.replace("." + QFileInfo(csvFile).suffix(), ".xls");
    }

    //内容集合
    QStringList content;
    //字段名称
    QList<QString> columnNames;
    //字段宽度
    QList<int> columnWidths;

    //读取csv文件的内容
    QFile file(csvFile);
    if (file.open(QIODevice::ReadOnly | QFile::Text)) {
        //采用文件流的形式读取速度最快
        QTextStream stream(&file);
        DataCsv::initTextStream(csvFile, &stream);
        stream.seek(0);

        //循环读取文件
        int row = 0;
        while (!stream.atEnd()) {
            QString line = stream.readLine();
            if (line.isEmpty()) {
                continue;
            }

            //删除特殊字符,这个字符会导致读取不到内容TNND
            QString pattern = "[\\x200B]";
#if (QT_VERSION >= QT_VERSION_CHECK(6,0,0))
            line.remove(QRegularExpression(pattern));
#else
            line.remove(QRegExp(pattern));
#endif

            row++;
            QStringList list = line.split(spliter);
            //第一行是字段
            if (row == 1) {
                int count = list.count();
                for (int i = 0; i < count; ++i) {
                    //去掉空字段名
                    QString columnName = list.at(i);
                    if (columnName.isEmpty()) {
                        continue;
                    }

                    columnNames << columnName;
                    //设置过则取设置好的
                    if (dataContent.columnWidths.count() > i) {
                        columnWidths << dataContent.columnWidths.at(i);
                    } else {
                        columnWidths << 70;
                    }
                }
                continue;
            }

            QString separator = dataContent.separator;
            //每行数据作为一个整体字符串带分割符 ; 存入
            content << list.join(separator);
        }
    }

    if (content.count() > 0) {
        //填充内容
        dataContent.content = content;
        //设置列名列宽
        dataContent.columnNames = columnNames;
        dataContent.columnWidths = columnWidths;
        //设置文件名
        dataContent.fileName = fileName;
        //调用静态函数导出
        DataXls::saveXls(dataContent);
    }

    return fileName;
}