Free Support Forum -

Import DataCell

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.

We already provide this feature. If you want to retrieve data from a cell, please try this:

Cells oCells = excel.Worksheets[0].Cells;

Cell oCell = oCells["AQ1"];

string exportValue = oCell.StringValue;

[Visual Basic]

Dim oCells as Cells = excel.Worksheets(0).Cells

Dim oCell as Cell = oCells("AQ1")

Dim exportValue as string = oCell.StringValue

Thanks for the great support and quick response!