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)
C;X7;Y3;K"300 - 600 secs."
C;X7;Y4;K"600 - 900 secs."
C;X7;Y5;K"900 - 1200 secs."
C;X7;Y6;K"1200 - 1500 secs."
C;X7;Y7;K"1500 - 1800 secs."