How to replace all the spaces of Headers with "_"

find starter help here for handling duplicate col names in excel
FixDuplicatedColNames.xaml (10.2 KB)

read in excel with read range without add headers for this

for finalizing this topic just do following:

  • decide your case, what is now the requirement (handling duplicate col names or col name corrections with replace)
  • share you final requirement with us and lets try to avoid XY Problem
1 Like