Microsoft Open XML Read Excel file using SAX method row by row and finding cell data

Question

I've looked through a number of posts on stockoverflow, but neither what I'm searching for nor posts that are similar to it appear to work for me. Rows cannot be read using OpenXmlReader since it never seems to expose the sheet data to a row element type.

I have to utilise OpenXmlPartReader's SAX function. I want to open the Excel file and read each row individually. I need to select a few cells for each row either by index number or id and the value in those cells. Because I am aware of which cells I need, I don't need to loop through all of them.

Answer 1

I faced a comparable challenge. A bespoke Sax reader that can extract all rows from the first sheet was created by me after integrating a number of relevant SO replies.

Please let me know how my xlsx-sax-exporter github project works for you by taking a look at it.

The reader opens the worksheet very quickly and determines its dimensions by using the SheetDimensions reference while building.

After examining the workbook's cell and numbering formats, it may additionally format numbers and dates. Even the normal numbering format scenarios are attempted to be covered.

Because I wanted to allow pulling paged results from the server and because it works best when all pages are retrieved sequentially, the reader uses paging. Sax streaming makes it blazingly fast as predicted, and memory utilisation is maintained to a minimum. Benchmarking this, it never uses more than 10 MB while avoiding holding rows in memory (release build).

If you have a change you'd like to suggest, feel free to fork and send a pull request. You can also just post an issue, and I'll attempt to fix it when I have time.