Unknown format error when reading xlsx format file without an extension

[Eugllena]

When I used "import" to read an xlsx format file which have no extension, it gave an error message: "Unknown format". I have set format = "xlsx", but the function still couldn't recognize.

The problem is because the function readxl can't recognize a file without an extension, it has been pointed out here.

Can you modify the function so that it works even with a file which has no extension but provide the code of file format.

[leeper]

Hmm...we could set this up to copy the file to a temporary directory and add an extension so it can be imported. Would that work for you?

[Eugllena]

Yes, it works. But will it be slow when the data set is big?

[leeper]

Yes, it could be.

[jennybc]

readxl now exposes read_xlsx and read_xls for reading extensionkess files. But someone still has to determine which it is, somehow.

[leeper]

@jennybc Oh, cool. I'm pushing an update to reflect that.