Method loadFromXmlFile

src/3rdparty/QXlsx/source/xlsxworksheet.cpp:2857–2970

}

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

	QXmlStreamReader reader(device);
    while (!reader.atEnd())
    {
		reader.readNextStartElement();
        if (reader.tokenType() == QXmlStreamReader::StartElement)
        {
            if (reader.name() == QLatin1String("dimension"))
            {
				QXmlStreamAttributes attributes = reader.attributes();
				QString range = attributes.value(QLatin1String("ref")).toString();
				d->dimension = CellRange(range);
            }
            else if (reader.name() == QLatin1String("sheetViews"))
            {
				d->loadXmlSheetViews(reader);
            }
            else if (reader.name() == QLatin1String("sheetFormatPr"))
            {
				d->loadXmlSheetFormatProps(reader);
            }
            else if (reader.name() == QLatin1String("cols"))
            {
				d->loadXmlColumnsInfo(reader);
            }
            else if (reader.name() == QLatin1String("sheetData"))
            {
				d->loadXmlSheetData(reader);
            }
            else if (reader.name() == QLatin1String("mergeCells"))
            {
				d->loadXmlMergeCells(reader);
            }
            else if (reader.name() == QLatin1String("dataValidations"))
            {
				d->loadXmlDataValidations(reader);
            }
            else if (reader.name() == QLatin1String("conditionalFormatting"))
            {
				ConditionalFormatting cf;
				cf.loadFromXml(reader, workbook()->styles());
				d->conditionalFormattingList.append(cf);
            }
            else if (reader.name() == QLatin1String("hyperlinks"))
            {
				d->loadXmlHyperlinks(reader);
            }
            else if(reader.name() == QLatin1String("pageSetup"))
            {
                QXmlStreamAttributes attributes = reader.attributes();

                d->PpaperSize = attributes.value(QLatin1String("paperSize")).toString().trimmed();
                d->Pscale = attributes.value(QLatin1String("scale")).toString().trimmed();
                d->PfirstPageNumber = attributes.value(QLatin1String("firstPageNumber")).toString().trimmed();
                d->Porientation = attributes.value(QLatin1String("orientation")).toString().trimmed();