This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have found that the file.format parameter is optional, and when NOT present it defaults to file.format = xl.constants$xlOpenXMLWorkbook. However, when I include that when reading an XLSX file, it does not work.
The problem I am trying to solve is using the code below to read from an XLSM file, but don't seem to be using the file.format parameter correctly.