Rename headers in excel files

Help Studio
,
1

Hello everyone!
How to rename headers in excel files if the name of the header is not accurate. For example, there is an excel file with the heading “Cadastral and someting number”. You need to rename it to “Cadastral number”. Thanks for the help.

2

Hi @sereganator
try this appraoch

image
image1486×714 34 KB

Regards,
Nived N
Happy Automation

3

Thanks, if “Cadastral and something number” is slightly different, for example “Cadastral and someting qewertrr number”, will this method work?

4

Hi @sereganator

Then u can try regex in if condition

Condition

System.Text.RegularExpressions.Regex.IsMatch(item.ColumnName.ToString,“Cadastral.*number”)

1 Like
5

Thank you so much!

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.