Finding Position of Excel Cell

Build
#1

Hi,
i want to formatting my excel files. but my data not in same position on the sheet.

For example seen on image,

image
image.png1115Ă—180 5.85 KB

Tables are fixed, but position is un stable.

i want to find the position (excel row column adress) of title cell, then i can assign select cell positions according to where the title positioned by.

how can i do that

1 Like
#2

@OmerODACI,

Welcome to our Community!!

Check this to convert the Numbers to excel column name

#3

Hi @OmerODACI - The best way to acheive this is get the first row(In your image row2) if your datatable is DT1.Rows(0) and save it in data row variable then iterate in the item of row and then make the condition like if contains(“Address”) return position.

I hope it will help you.

Best!!!
Anmol

1 Like