Skip to content
Advertisement

Output error if there is value under NaN header in Excel file

I have inputed Excel table, that look like this:

JavaScript

I need to output error, because under the NaN header there is value(val_7), but i have no idea how to implement it

Advertisement

Answer

try:

JavaScript

result:

JavaScript

it works if you don’t have the word “unnamed” in any of your columns names

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement