Troubleshooting Import big excel file
1 回表示 (過去 30 日間)
古いコメントを表示
I have this excel file, I'm trying to import it but I cannot. The cursor keeps spinning all the time.
Can you help me point out what's wrong with the file or the way I import it?
Thank you so much.
採用された回答
dpb
2019 年 8 月 13 日
>> t=readtable('export.csv');
>> whos t
Name Size Bytes Class Attributes
t 45x255 270679 table
>> t(1:10,1:10)
ans =
10×10 table
ID event_name date_contacts name phone1 phone1_type phone1_msg phone2 phone2_type phone2_msg
__ _________________ _____________ ____ ______ ___________ __________ ______ ___________ __________
1 'baseline1_arm_1' NaN '' '' NaN NaN '' NaN NaN
1 'baseline2_arm_1' NaN '' '' NaN NaN '' NaN NaN
1 'baseline3_arm_1' NaN '' '' NaN NaN '' NaN NaN
1 'baseline4_arm_1' NaN '' '' NaN NaN '' NaN NaN
1 'baseline5_arm_1' NaN '' '' NaN NaN '' NaN NaN
1 'baseline6_arm_1' NaN '' '' NaN NaN '' NaN NaN
2 'baseline1_arm_1' NaN '' '' NaN NaN '' NaN NaN
2 'baseline2_arm_1' NaN '' '' NaN NaN '' NaN NaN
2 'baseline3_arm_1' NaN '' '' NaN NaN '' NaN NaN
2 'baseline4_arm_1' NaN '' '' NaN NaN '' NaN NaN
>>
Didn't seem to have any trouble here.
The files isn't all that big...it's mostly empty fields.
>> d=dir('export.csv')
d =
struct with fields:
name: 'export.csv'
folder: 'C:\Users\Duane\Documents\MATLAB\Work'
date: '13-Aug-2019 14:47:19'
bytes: 17449
isdir: 0
datenum: 7.3765e+05
>>
It's only 17k on disk...
2 件のコメント
dpb
2019 年 8 月 13 日
Dunno...I've never tried using the fancy doodads...I just write code. No idea what it's trying to do.
その他の回答 (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!