Method getSpreadsheetByName

src/backend/datasources/projects/OriginProjectParser.cpp:205–236

get Origin::Spreadsheet from container name (may be a spreadsheet or workbook)

// get Origin::Spreadsheet from container name (may be a spreadsheet or workbook)
Origin::SpreadSheet OriginProjectParser::getSpreadsheetByName(QString& containerName) {
	DEBUG(Q_FUNC_INFO)
	int sheetIndex = 0; // which sheet? "@X"
	const int atIndex = containerName.indexOf(QLatin1Char('@'));
	if (atIndex != -1) {
		sheetIndex = containerName.mid(atIndex + 1).toInt() - 1;
		containerName.truncate(atIndex);
	}
	// DEBUG("CONTAINER = " << STDSTRING(containerName) << ", SHEET = " << sheetIndex)

	// check if workbook
	int workbookIndex = findWorkbookByName(containerName);
	// if workbook not found, findWorkbookByName() returns 0: check this
	if (workbookIndex == 0 && (m_originFile->excelCount() == 0 || containerName.toStdString() != m_originFile->excel(0).name))
		workbookIndex = -1;
	// DEBUG("WORKBOOK  index = " << workbookIndex)

	// comment of y column is used in legend (if not empty), else the column name
	Origin::SpreadSheet sheet;
	if (workbookIndex != -1) { // container is a workbook
		sheet = m_originFile->excel(workbookIndex).sheets[sheetIndex];
	} else { // container is a spreadsheet?
		int spreadsheetIndex = findSpreadsheetByName(containerName);
		// if spreadsheet not found, findSpreadsheetByName() returns 0: check this
		if (spreadsheetIndex == 0 && (m_originFile->spreadCount() == 0 || containerName.toStdString() != m_originFile->spread(0).name))
			spreadsheetIndex = -1;
		if (spreadsheetIndex != -1)
			sheet = m_originFile->spread(spreadsheetIndex);
	}

	return sheet;
}

// ##############################################################################
// ############## Deserialization from Origin's project tree ####################