Method loadFromXmlFile

src/3rdparty/QXlsx/source/xlsxworkbook.cpp:558–684

}

bool Workbook::loadFromXmlFile(QIODevice *device)
{
    Q_D(Workbook);

    QXmlStreamReader reader(device);
    while (!reader.atEnd())
    {
         QXmlStreamReader::TokenType token = reader.readNext();
         if (token == QXmlStreamReader::StartElement)
         {
             if (reader.name() == QLatin1String("sheet"))
             {
                 QXmlStreamAttributes attributes = reader.attributes();

                 const auto& name = attributes.value(QLatin1String("name")).toString();

                 int sheetId = attributes.value(QLatin1String("sheetId")).toInt();

                 const auto& rId = attributes.value(QLatin1String("r:id")).toString();

                 const auto& stateString = attributes.value(QLatin1String("state"));

                 AbstractSheet::SheetState state = AbstractSheet::SS_Visible;
                 if (stateString == QLatin1String("hidden"))
                     state = AbstractSheet::SS_Hidden;
                 else if (stateString == QLatin1String("veryHidden"))
                     state = AbstractSheet::SS_VeryHidden;

                 XlsxRelationship relationship = d->relationships->getRelationshipById(rId);

                 AbstractSheet::SheetType type = AbstractSheet::ST_WorkSheet;
                 if (relationship.type.endsWith(QLatin1String("/worksheet")))
                 {
                     type = AbstractSheet::ST_WorkSheet;
                 }
                 else if (relationship.type.endsWith(QLatin1String("/chartsheet")))
                 {
                     type = AbstractSheet::ST_ChartSheet;
                 }
                 else if (relationship.type.endsWith(QLatin1String("/dialogsheet")))
                 {
                     type = AbstractSheet::ST_DialogSheet;
                 }
                 else if (relationship.type.endsWith(QLatin1String("/xlMacrosheet")))
                 {
                     type = AbstractSheet::ST_MacroSheet;
                 }
                 else
                 {
                     qWarning() << "unknown sheet type : " << relationship.type ;
                 }

                 AbstractSheet *sheet = addSheet(name, sheetId, type);
                 sheet->setSheetState(state);
                 QString strFilePath = filePath();

                 // const QString fullPath = QDir::cleanPath(splitPath(strFilePath).constFirst() + QLatin1String("/") + relationship.target);
                 const auto parts = splitPath(strFilePath);