Storage columns of data from excel sheet on matlab table cell

2 次查看（过去 30 天）
Kaiyuan
Kaiyuan 2024-9-3
回答： Voss 2024-9-3
I want to create a matlab table where each cell can store sequences of data as shown by image 1 and image 2.
The aim is to extract the values of a single column from excel sheet (Shown on image 3) and store these values on a single cell of matlab table. The process will be repeated until all the excel columns are stored on matlab table cells.
For example, the column A data from excel sheet will be stored at cell (1,1) of matlab table, the column B data from excel sheet will be stored at cell (2,1) of matlab table, the column C data from excel sheet will be stored at cell (3,1) of matlab table and so on.
The excel sheet is attached with this questions.
Could our friends help me with that?
Image 1
Image 2
Image 3

请先登录，再回答此问题。

采纳的回答

Voss
Voss 2024-9-3
Ran in:
"I want to create a matlab table" but you show a cell array. These methods create a cell array as you describe:
Method 1:
T = readtable('Wind_Speed_Data_2023.xlsx','VariableNamingRule','preserve');
N = size(T,2);
C = cell(N,1);
for ii = 1:N
C{ii} = T.(ii);
end
disp(C)
{8759x1 double} {8759x1 double} {8759x1 double} {8759x1 double} {8759x1 double} {8759x1 double} {8759x1 double} {8759x1 double} {8759x1 double} {8759x1 double} {8759x1 double} {8759x1 double}
Method 2:
T = readtable('Wind_Speed_Data_2023.xlsx','VariableNamingRule','preserve');
tmp = varfun(@(x){x},T);
C = tmp{:,:}.';
disp(C)
{8759x1 double} {8759x1 double} {8759x1 double} {8759x1 double} {8759x1 double} {8759x1 double} {8759x1 double} {8759x1 double} {8759x1 double} {8759x1 double} {8759x1 double} {8759x1 double}

更多回答（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!

Translated by