CODEWITHSUNDEEP
c#excelsmartxls
Blue Cross
Blue Cross

Reputation: 73

Get Cells position with SmartXLS workbook

I'm using SmartXLS workbook to read an excel file, I can access to the data at index like ::

              var workbook = new WorkBook();
                workbook.read(filePath); //read from Excel File
                var dataTable = workbook.ExportDataTable(); //export to DataTable

                var tenderResponseLineData = new List<TenderResponseLine>();

                for (int i = 1; i < dataTable.Rows.Count; i++)
                { 

Code = dataTable.Rows[i].ItemArray[3].ToString().Trim(), //Get code
    ProductName = dataTable.Rows[i].ItemArray[5].ToString().Trim(), //get ProductName
    }

Now I want to get the cell position (column letter, position-line) of data such as L4, or B3. I don't know if SmartXLS has this function or not ? I have searched on SmartXLS site but I haven't found information about this

Thanks,

Upvotes: 0

Views: 977

Answers (0)

Related Questions