Case issues with Named Ranges

May 24, 2013 at 5:03 PM

I am very pleased with the library overall, but am having one issue converting my application to this method vs. OLEDB. I have an application that goes after specific named ranges in a series of spreadsheets and reformats the data. The OLEDB connections were not case sensitive, so the users have been lax about case when naming the ranges. It appears from my testing that your range functions are case sensitive, at least by default. Is there any way to override this and make a range extraction case insensitive? There are dozens of these spreadsheets, so reworking all of the ranges to a uniform case is not a trivial thing.


Jim Reinardy