read_excel update and additional output

[certara-mtomashevskiy]

in the recent read_excel package update the authors changed the logic of new tibble created when col_names=FALSE specified
See for example here
https://stackoverflow.com/questions/55197302/new-names-18-message-in-r-console
as a result an unintended output is shown in console
New names:
_* `` -> ...1

• `` -> ...2
• `` -> ...3
• `` -> ...4
• `` -> ...5_

[certara-mtomashevskiy]

to avoid this we need to specify additional argument for read_excel function

datawithdescr <- as.data.frame(read_excel(path = full.name, 
        sheet = set, na = c("NA", "ND", ".", "", "Missing"), 
        skip = 0, col_names = FALSE, .name_repair = 'minimal'))

so there will be no 'guess' for the names

[Helmut01]

Hi Michael,

I will check that. In today’s release I used suppressMessages(as.data.frame(read_excel(...))). Your’s looks better.

[Helmut01]

Hi Michael,
THX! Tested with Excel-file both with and wo headers.