Reading large excel file using "read" command takes ~5 minutes, is this expected performance?
조회 수: 4 (최근 30일)
이전 댓글 표시
I am reading a simulation/test output data in a .xlsx file into a matlab table through a datastore variable. The test data contains 450+ variables, each with 20000+ samples (i.e.) 450+ columns and 20000+ rows but all are numbers. I created a datastore on the excel file, modified the selected variables and variable type properties and used read command to read the file into a matlab table, it took about ~5 minutes. When I tried readtable command on the excel file directly, it took about the same time as well. However when I tried reading the file interactively using matlab export dialog, it took less than 30 seconds, so I am wondering if there's any way to achieve the same level of efficiency programmatically?
댓글 수: 0
채택된 답변
J. Alex Lee
2020년 9월 6일
Try manually creating the import options with spreadsheetimportoptions().
댓글 수: 2
J. Alex Lee
2020년 9월 7일
Yes, the idea is to fully specify the import parameters so that they don't have to be auto-detected.
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!