You shouldn't need to use set_names(). Most Excel file parsers (such as those provided by the readxl package) contain options to convert the first row into variable names.
Also, can you explain why you are trying to remove the variable names once you've set them?