清空筛选条件
清空筛选条件

How i create a structure from an excell document that i import into matlab ?

1 次查看（过去 30 天）
Leonidas Tempelis
编辑： Jan 2021-4-8
I have an excell table with dimencions (9x8). I want to import the table in matlab and then create a structure with 8 fields. Each field will have the values of each row, so the dimencions would be 9x1.
I tried to import the excell table as 8 cell arrays, where every column from the table will be an individual cell array. Then i tried create a stuctrure with 8 fields where each field would correspond to each cell. The following code describes whta i have done already
H = struct ( field1, value1, field2, value2, field3, value3, field4, value4, field5, value5, field6, value6, field7, value7, field8, value8);
H.value1 = ORIGIN;
H.value2 = DESTINATION;
H.value3 = EARLIESTPICKUPTIME;
H.value4 = LATESTDELIVERY;
H.value5 = TRANSPORTATION;
H.value6 = MODEOFTRANSPORT;
H.value7 = HRS;
H.value8 = KM;
I have a probem because when i run the code, Matlab does not understand the field1, field2 etc
excell:
  3 个评论
显示 1更早的评论
Jan
Jan 2021-4-8
Please post the complete code. What is the contents of the variables "field1"?
Post the Excel file as attached file. We cannot use the screenshot to check the suggested code.

请先登录，再进行评论。

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

回答（1 个）

Jan
Jan 2021-4-8
编辑：Jan 2021-4-8
What about:
T = readtable(ExcelFile, 'ReadVariableNames', true);
S = table2struct(T, 'ToScalar', true)

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2014b

Community Treasure Hunt

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

Start Hunting!

Translated by