Troubleshooting Import big excel file
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
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.
Respuesta aceptada
dpb
el 13 de Ag. de 2019
>> 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 comentarios
dpb
el 13 de Ag. de 2019
Dunno...I've never tried using the fancy doodads...I just write code. No idea what it's trying to do.
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!