Hi, I have an Excel table of 18 columns and I want to iterate through the table row by row in ReFramework.
I want to do this without selecting the entire thing as a huge DataTable and iterating through the whole thing in memory. This is to limit how much RAM is used in the background while the process is running.
I am currently using Excel Read Row, but this returns an iEnumerable instead of a DataRow. This iEnumerable does not contain information on what each column means. I would rather not hardcode what each column title is because the workflow should be flexible in deciding which column title is in which column index.
How do I keep the Excel worksheet open and only read one row at a time, while preserving the information on column titles?