Load .slk file format (excel can open it, but can't import it to matlab)

24 ビュー (過去 30 日間)
Tamara del Águila
Tamara del Águila 2021 年 10 月 20 日
回答済み: millercommamatt 2021 年 10 月 22 日
I am trying to import in matlab a file with extension '.slk'. Although in excel it is opened as a normal file, with info in differents cells, I cannot load it in Matlab as a cell structure, as a normal excel would. I have to process many of those files, that's why exporting as csv from excel is not doable...
The closest I have got is to use the function 'extractFileText'. Either with differents options for 'encoding' or without them, I can only get a string with the info like the code below. Before posting the code, I attach a picture of how the file looks in an excel-like software:
It somehow includes the info I am trying to extract, but I don't know how to deal with a string of this kind, and I wonder whether there is a way of importing the data as a cell structure or variables for each colum...
Could anyone, please, help?
>> data = extractFileText(excelname)
data =
data =
"ID;PANYMAZE
P;PGeneral
P;FArial;M200
P;EArial;M0
B;X10;Y7
F;R1;M240
F;R2;M240
F;R3;M240
F;R4;M240
F;R5;M240
F;R6;M240
F;R7;M240
F;C1;SM1;FF0R
F;W1 1 5
F;C2;SM1;FF0R
F;W2 2 7
F;C3;P0;SM1;FG0L
F;W3 3 10
F;C4;P0;SM1;FG0L
F;W4 4 5
F;C5;P0;SM1;FG0L
F;W5 5 12
F;C6;SM1;FF0R
F;W6 6 6
F;C7;P0;SM1;FG0L
F;W7 7 18
F;C8;P0;SM1;FG0L
F;W8 8 14
F;C9;SM1;FF1R
F;W9 9 27
F;C10;SM1;FF1R
F;W10 10 24
F;X1;Y1;FG0L
C;X1;Y1;K"Test"
F;X2;Y1;FG0L
C;X2;Y1;K"Animal"
F;X3;Y1;FG0L
C;X3;Y1;K"Treatment"
F;X4;Y1;FG0L
C;X4;Y1;K"Code"
F;X5;Y1;FG0L
C;X5;Y1;K"Stage"
F;X6;Y1;FG0L
C;X6;Y1;K"Trial"
F;X7;Y1;FG0L
C;X7;Y1;K"Segment_of_test"
F;X8;Y1;FG0L
C;X8;Y1;K"Apparatus"
F;X9;Y1;FG0L
C;X9;Y1;K"Zona_de_no_refuerzo_._time"
F;X10;Y1;FG0L
C;X10;Y1;K"Zona_de_refuerzo_._time"
C;X1;Y2;K1
C;X2;Y2;K1
C;X3;Y2;K""
C;X4;Y2;K""
C;X5;Y2;K"First stage"
C;X6;Y2;K1
C;X7;Y2;K"0 - 300 secs."
C;X8;Y2;K"New apparatus"
C;X9;Y2;K279.4
C;X10;Y2;K20.6
C;X1;Y3;K1
C;X2;Y3;K1
C;X3;Y3;K""
C;X4;Y3;K""
C;X5;Y3;K"First stage"
C;X6;Y3;K1
C;X7;Y3;K"300 - 600 secs."
C;X8;Y3;K"New apparatus"
C;X9;Y3;K294.2
C;X10;Y3;K5.8
C;X1;Y4;K1
C;X2;Y4;K1
C;X3;Y4;K""
C;X4;Y4;K""
C;X5;Y4;K"First stage"
C;X6;Y4;K1
C;X7;Y4;K"600 - 900 secs."
C;X8;Y4;K"New apparatus"
C;X9;Y4;K300.0
C;X10;Y4;K0.0
C;X1;Y5;K1
C;X2;Y5;K1
C;X3;Y5;K""
C;X4;Y5;K""
C;X5;Y5;K"First stage"
C;X6;Y5;K1
C;X7;Y5;K"900 - 1200 secs."
C;X8;Y5;K"New apparatus"
C;X9;Y5;K293.0
C;X10;Y5;K7.0
C;X1;Y6;K1
C;X2;Y6;K1
C;X3;Y6;K""
C;X4;Y6;K""
C;X5;Y6;K"First stage"
C;X6;Y6;K1
C;X7;Y6;K"1200 - 1500 secs."
C;X8;Y6;K"New apparatus"
C;X9;Y6;K300.0
C;X10;Y6;K0.0
C;X1;Y7;K1
C;X2;Y7;K1
C;X3;Y7;K""
C;X4;Y7;K""
C;X5;Y7;K"First stage"
C;X6;Y7;K1
C;X7;Y7;K"1500 - 1800 secs."
C;X8;Y7;K"New apparatus"
C;X9;Y7;K300.0
C;X10;Y7;K0.0
E
"

回答 (1 件)

millercommamatt
millercommamatt 2021 年 10 月 22 日
data = readtable('your_spreadsheet.slk','FileType','spreadsheet');

製品


リリース

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by