Checking if Column Name exists C#

[lmoham]

Hi please advise, what am I doing wrong?
DT.Columns.Contains used to work with dates down to the specific format but now I’m confused as to what I have done wrong

[NIVED_NAMBIAR (NIVED N)]

Use the condition like this
DT.Columns.Contains(help.ToString(“dd-MMMM”))

it would work

Regards,

Nived N
Happy Automation

[lmoham]

Thanks for your response but I
still can’t detect it…
the format is actually “dd-MMM” so I don’t understand why it isnt picking anything up

[Pankaj.Patil (Robot Master)]

@lmoham

the format is actually “dd-MMM” so I don’t understand why it isnt picking anything up

@lmoham,

Can you just select Preserve Format of read range activity and run it?

[lmoham]

same result

[NIVED_NAMBIAR (NIVED N)]

Hi @lmoham , below i am attaching the workflow and sample excel sheet, check this
Main.xaml (10.4 KB)
sample.xlsx (7.8 KB)

it is working fine

Regards,

Nived N
Happy Automation

[lmoham]

I don’t understand… why doesn’t mine work
Main.xaml (9.9 KB)
project.json (1.3 KB)
dummy.xlsx (8.5 KB)

[NIVED_NAMBIAR (NIVED N)]

Hi @lmoham

check this file

i had made the workflow according to the requirement
Main.xaml (11.7 KB)

Regards,

Nived N
Happy Automation

[lmoham]

Hello again, I tried implementing the array into my main file but came up with errors is there a way to do it in C#?

I’m not familiar with the code you used for the array could you elaborate on dc, Cast and CDate?

[NIVED_NAMBIAR (NIVED N)]

Hi @lmoham
in c# u can use this to columnnames as array

(from dc in dt.Columns.Cast()
select ConvertToDateTime(dc.ColumnName).ToString(“dd-MMM”)).ToArray();

[lmoham]

Got back these errors

[NIVED_NAMBIAR (NIVED N)]

Hi @lmoham
just edited my response , check above

[lmoham]

Hi,

got rid of most errors, decided to use a new datatable by the name of dates which only contains the column names