I'm working on a method of identifying and storing the location of certain datum in a spreadsheet. For example, when a spreadsheet is displayed, the user is prompted to 'Select all cells containing names." My hope is that the user will select the appropriate worksheet in the workbook, then using Ctrl+Click select each cell containing a name. Once they've done this, I want to iterate through each of the selected cells of the entire workbook and capture the worksheet index, column and row index, as well as the value for each of those cells from code-behind. Ideally, I'll use this data to create a database table with column names based upon the values of the selected cells. I'll also add rows to another table that store the location of each selected name, i.e., the cell containing the name 'Jane Doe' is in column 'M', row '11', on worksheet '6'.
All of the database stuff I can handle without trouble, but I cannot find an effective way to capture the cell locations or values in an iterative sort of way across the whole workbook from code-behind.
I'm sorry if this turns out to be a trivially simple problem. I only started using Telerik a few days ago. I look forward to your response!