Given: The ExportDataTable method can be very handy when you want to query for data in a worksheet.
Question: What if you want to query a worksheet, and return the cell reference(s) of the location for which your data resides?
Let's say I have a very simple sheet with header columns in the 1st row:
And I want to know the cell reference for 'First_Name' where 'Last_Name' is 'Manning'. (A2 in this example)
Can the Aspose Cells API help me?