getSpreadSheetDetails method

Implementation

void getSpreadSheetDetails(ArchiveFile workbookFile, SpreadSheet spreadSheet) {
  final fileContent = utf8.decode(workbookFile.content);
  final workbookDoc = xml.XmlDocument.parse(fileContent);
  var sheetsRoot = workbookDoc.findAllElements("sheets");
  if (sheetsRoot.isNotEmpty) {
    var allSheets = sheetsRoot.first.findAllElements("sheet");
    if (allSheets.isNotEmpty) {
      for (var sheets in allSheets) {
        String sName = "";
        String sId = "";
        String rId = "";
        var tempName = sheets.getAttribute("name");
        if (tempName != null) {
          sName = tempName;
        }
        var tempId = sheets.getAttribute("sheetId");
        if (tempId != null) {
          sId = tempId;
        }
        var tempRId = sheets.getAttribute("r:id");
        if (tempRId != null) {
          rId = tempRId;
        }
        spreadSheet.sheets.add(Sheet(sName, sId, rId));
      }
    }
  }
}