Gibt es einen SAX-Weg, um eine Schleife durch OpenXML-Zeilen?

Der Schlüssel ist, verwenden Sie die Skip() und ReadNextSibling() Methoden des Lesers...

 using (SpreadsheetDocument myDoc = SpreadsheetDocument.Open("BigFile.xlsx", true))
 {
     WorkbookPart workbookPart = myDoc.WorkbookPart;
     WorksheetPart worksheetPart = workbookPart.WorksheetParts.First();
     OpenXmlReader reader = OpenXmlReader.Create(worksheetPart);
     String rowNum;
     while (reader.Read())
     {
         if (reader.ElementType == typeof(Row))
         {
             do
             {
                 if (reader.HasAttributes)
                     rowNum = reader.Attributes.First(a => a.LocalName == "r").Value;

             } while (reader.ReadNextSibling()); //Skip to the next row
             break; //We just looped through all the rows so no need to continue reading the worksheet
         }

         if (reader.ElementType != typeof(Worksheet)) //Dont' want to skip the contents of the worksheet
             reader.Skip(); //Skip contents of any node before finding the first row.
     }
}