Over at the Stata forum, a discussion involving importing large Excel datasets unearthed a very helpful coding nugget. The key is entry #3 that reveals an undocumented setting ("set excelxlsxlargefile on"). According to the poster, activating the setting:
"will allow -import excel- to bypass the size checking. But you should be warned, the library we use to import Excel files has a large memory footprint when dealing with large xlsx files. Also the library currently has no ability to allow user to break during the middle of loading an Excel file. Hence when you attempt to load [a large Excel] xlsx file, the Stata session will become unresponsive until it finishes. During this time, you will not be able to break out using the break button."
Comments