I'm currently trying to import a 42mb .xlsx file into R with 'gdata', it's brought my laptop churning to a halt. I'm wondering whether it would be quicker to convert to CSV and then try to import it into R?
If there are reasons you'd prefer to keep your files in xlsx format, you could try read.xlsx or read.xlsx2 (which is faster), both from the xlsx package. I've never done time comparisons, but 42 mb isn't a particularly large file, so maybe xlsx will be good enough if you prefer to stick with Excel format.
data.table
package, which has afread
function to help you with large files.read.xlsx
orread.xlsx2
(which is faster), both from thexlsx
package. I've never done time comparisons, but 42 mb isn't a particularly large file, so maybexlsx
will be good enough if you prefer to stick with Excel format.