in reply to Reading and Writing from / to XLSX file (optimization)
since no one else mentioned it.
Devel::NYTProf helps you finding the performace hotspots of your code.
maybe your "small" files are the right place to start with profiling.