I am currently using ExportDataTableAsString in order to retrieve values from an Excel template. Is there an easier way (or can one be added) to extract a single value from an Excel cell? The existing parameters only accept an integer to identify the column which requires the developer to convert the varchar column description used by excel to a number. Could this function be overloaded to accept a string so that I don’t have to convert “AQ” to the ordinal position of the column?
It would be nice if there was an ExportCellValueAsString function which accepts an integer parameter to identify the row and a string parameter to identify the column and returns a string rather than having to accept the data into a datatable, dataview or array and then retrieving the string.
Thanks in advance for the help.