How can I split up several numbers in one cell from an excel file?

One option would be the mat2cell (link) function. Each column would be its own cell, so you could then address them easily. Use the first output of xlsread (it should be a numeric matrix).

The code would be something like this:

[D,S] = xlsread('YourFile.xlsx');
ColCells = mat2cell(D, size(D,1), ones(1,size(D,2)));

3 个评论
显示 1更早的评论隐藏 1更早的评论

Dominik Kümpflein 2019-2-14

编辑：Dominik Kümpflein 2019-2-14

Yes you are right. It's an csv-file. I'm not used to that and didn't know how to handle it so I converted it to an .xlsx, sorry for that. (Not gonna do that mistake again)

I tried your suggestion with xlsread the csv-file, but the mat D remains empty and so 'ColCells' of course too. But the way with the txt file works perfectly!

Thank you so much!

Star Strider 2019-2-14

As always, my pleasure!

请先登录，再进行评论。

Answer 2

Dominik Kümpflein 2019-2-14

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/444994-how-can-i-split-up-several-numbers-in-one-cell-from-an-excel-file#answer_361053

First of all, thanks for your quick answers.

I'm sorry if I didn't made clear enough what I wanna do.

I added a Screenshot of how my Excel-File looks. These are data logged by a GoPro that i extracted from a MP4-File. To do further calculations i need to extract the GPS-Data from it.

Unfortunatly, all data from one timestep is written in one Excel-Cell and separated by a comma. So now I'm looking for a way to read the data in Matlab and split it up, so i get a mat or cell-array with one column for the timestep, one for the Latitude one for the Longitude and so on.

4 个评论
显示 2更早的评论隐藏 2更早的评论

madhan ravi 2019-2-14

Attach your data.

Dominik Kümpflein 2019-2-14

Here is my Excel file for the input

请先登录，再进行评论。

Answer 3

Bob Thompson 2019-2-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/444994-how-can-i-split-up-several-numbers-in-one-cell-from-an-excel-file#answer_361049

[~,~,data] = xlsread('myexcel.xlsx',range);
data = cellfun(@(x) str2num(x),data);

This is a first crack at the code. I'm not absolutely certain that the cellfun will work as I want it to, since I haven't tested it. Basically, you are going to read all of the cells of the excel file into a matlab cell array. I expect that the cells with multiple numbers will be treated as a string, but using str2num should convert them into actual number arrays for you.