I want to get datas from Excel file without Excel Macro

Hi @oitot,
Just to confirm: you have stated: “I want to get most right cell in rows 3 In this pattern,column G)”. Do you mean the most right cell with data? In your example the field with the date is in fact not in the last column, so to get the text I have used: “exlDatatable(exlDatatable.Rows.IndexOf(row)+2)(exlDatatable.Columns.Count-2).ToString”, where exlDatatable was the output of Read Range in the Excel Application Scope.


To look for the most under cell in the column G you can probably use a part of the solution proposed by @ranjith

As for the data you want to pull out from the last section, it would depend e.g. on how your spreadsheet may be changing. Is it always going to be the last column and the last code section for you? Can the data be separated by blank cells?