ExcelProvider
ExcelProvider copied to clipboard
Support for ranges specified at runtime
I'd like the ability to determine the range at runtime.
I have several files I need to import that contain "bands" of information on the same worksheet. Thus, the range I need to parse moves depending on how much information is in the band above it.
I have code in place to figure out where those ranges are, but don't have a way to specify them when I open the file via the type provider.
At present, I'm sticking with a terrible OleDB-based solution.