I want to get datas from Excel file without Excel Macro

[oitot]

Hi, I want to get datas from Excel file without Excel Macro.
Like attached below.
Question.xls (147 KB)

[skini76]

Please refer the tutorial.

[PAD]

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

Get value from the last non empty cell in an excel row

I have an excel file which consists of a table which is unstructured and I’m trying to extract the value from last non empty cell of each row. I tried using Get Row Item activity with column index as finalDT.Columns.Count - 1 in For each row, but this returns empty values as well. Any help would be appreciated. Please find the attached excel file (Sheet 2). invoice.xlsx (9.3 KB)

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?

[oitot]

Thanks for your rply.I used assin activity ”inLastColumn= Dt.Columns.count"
and use the number in ”For Each Row” like row(inLastColumn-1).
Your way also worked! I meant the second right cell.

The data can be sprated by blank cells, and I found another way to solve them(I negociated with my client…).

[PAD]

Awesome, so I take it that your problems are now solved

[oitot]

Yes the Problem is solved .
Thanks for your sharing the link "Get value from the last non empty cell in an excel row”！

[PAD]

No probs