Curious about the speed of readtable

3 ビュー (過去 30 日間)
jlt199
jlt199 2016 年 8 月 16 日
コメント済み: Benjamin 2016 年 8 月 16 日
Hi, I'm wondering why readtable takes so long to parse when you specify a worksheet and a range. Does anyone know?
I have a company spreadsheet that I'm trying to read into Matlab. The top of the worksheet has a load of rubbish and the actual table f interest starts on row 7. There are only 5000 odd rows, but it takes an age to read in, whereas I have another spreadsheet that only has a table and that reads in within a second or so despite being well over a million rows.
I guess I'm just curious as to why it takes so long and if there is a better method to be using.
Thanks
  1 件のコメント
Benjamin
Benjamin 2016 年 8 月 16 日
have you tried any other comparable functions like csvread or xlsread? it's hard to know what is slow about reading that file without an example (i.e. what does "a load of rubbish" mean exactly?)

サインインしてコメントする。

回答 (0 件)

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

タグ

製品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by