您正在关注此问题

您将在关注的内容源中看到更新。
您可能会收到电子邮件，具体取决于您的通信预设项。

How to write this line of code to create a Matlab table?

3 次查看（过去 30 天）

显示更早的评论

Leon 2020-12-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678993-how-to-write-this-line-of-code-to-create-a-matlab-table

⋮

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678993-how-to-write-this-line-of-code-to-create-a-matlab-table

评论： Leon 2020-12-5

采纳的回答： Walter Roberson

在 MATLAB Online 中打开

I have unknown number of column variables in cell array:

Var{1} = [ 1; 2; 3; 4; 7];
Var{2} = [33; 10; 46; 7; 2];
...

If I knew how many variables I have, I would be able to manually form my table by:

T1 = table(Var{1}, Var{2}, ...);

The problem is that I do not know how many variables each time my program will generate. In this case, how could I write the code to create the table?

I tried the below, but it does not work:

T1 = table(Var);

Many thanks.

采纳的回答

Walter Roberson 2020-12-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678993-how-to-write-this-line-of-code-to-create-a-matlab-table#answer_565923

⋮

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678993-how-to-write-this-line-of-code-to-create-a-matlab-table#answer_565923

cell2table and probably provide VariableNames parameter

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678993-how-to-write-this-line-of-code-to-create-a-matlab-table#comment_1185038

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678993-how-to-write-this-line-of-code-to-create-a-matlab-table#comment_1185038

在 MATLAB Online 中打开

Many thanks for pointing me towards that direction.

Below is my code. Unfortunately, it still does not work

TT = cell2table(Var);
File_W = 'test.xlsx';
writetable_units(TT, File_W);

Error using writetable_units (line 11)
The data block starting at cell 'A3' exceeds the sheet
boundaries by 0 row(s) and 1874492 column(s).
Error in A01_NC (line 68)
writetable_units(TT, File_W);

Here is what my Var look like:

Var =
  1×69 cell array
  Columns 1 through 3
    {27404×1 double}    {27404×12 char}    {27404×12 char}
  Columns 4 through 6
    {27404×1 char}    {27404×1 char}    {27404×9 char}

Walter Roberson 2020-12-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678993-how-to-write-this-line-of-code-to-create-a-matlab-table#comment_1185703

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678993-how-to-write-this-line-of-code-to-create-a-matlab-table#comment_1185703

I am not able to find any function named writetable_units. The error message suggests that whatever it is, it is not written in MATLAB m code so it might be difficult to find source code for.

Walter Roberson 2020-12-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678993-how-to-write-this-line-of-code-to-create-a-matlab-table#comment_1185733

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678993-how-to-write-this-line-of-code-to-create-a-matlab-table#comment_1185733

The error message refers to 1874492 columns, which is far beyond the limit for xlsx files. However it is not obvious to me how it could have gotten that many columns out of your data, which is why I would need to look at the source code.

Walter Roberson 2020-12-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678993-how-to-write-this-line-of-code-to-create-a-matlab-table#comment_1185743

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678993-how-to-write-this-line-of-code-to-create-a-matlab-table#comment_1185743

Though I do notice that you only happen to show the first 6 out of 69 cells. Is it possible that some of the cells contain numeric values with more than one column? For example 27204 x 20000 double would need 20000 excel columns which would be too much for xlsx format.

Leon 2020-12-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678993-how-to-write-this-line-of-code-to-create-a-matlab-table#comment_1185813

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678993-how-to-write-this-line-of-code-to-create-a-matlab-table#comment_1185813

在 MATLAB Online 中打开

Thanks, Walter!

Please ignore the readtable_units function. It is a slightly modified version of the readtable. It is essentially the same as the readtable function. This error is unrelated to that function for sure.

My data has 69 columns, each column has 27404 rows. That's it. The 1874492 columns probably is a proof that the below command is not working as we hope it should.

TT = cell2table(Var);

Walter Roberson 2020-12-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678993-how-to-write-this-line-of-code-to-create-a-matlab-table#comment_1185858

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678993-how-to-write-this-line-of-code-to-create-a-matlab-table#comment_1185858

What does size(TT) show? Also experiment with cell2table(Var(:))

Leon 2020-12-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678993-how-to-write-this-line-of-code-to-create-a-matlab-table#comment_1185888

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678993-how-to-write-this-line-of-code-to-create-a-matlab-table#comment_1185888

Many thanks!

Size(TT) shows: 1 x 69.

I also tested TT=cell2table(Var(:)) and the size(TT) shows: 69 x 1.

Walter Roberson 2020-12-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678993-how-to-write-this-line-of-code-to-create-a-matlab-table#comment_1185903

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678993-how-to-write-this-line-of-code-to-create-a-matlab-table#comment_1185903

在 MATLAB Online 中打开

vartypes = cellfun(@class, Var, 'uniform', 0);
nonchar = find(~ismember(vartypes, {'string', 'char'}));
varsizes = cellfun(@size, Var, 'uniform', 0);
vardims = cellfun(@ndims, Var);
oddsized = find(vardims ~= 2);
if ~isempty(oddsized)
    fprintf('Some variables are multi-dimensional! Index: \n');
    disp(oddsized)
    fprintf('sizes:\n');
    celldisp(vardims(oddsized))
end
nonchar = setdiff(nonchar, oddsized);    %don't complain twice
nonchar_sizes = vertcat(varsizes{nonchar});
multicol = find(nonchar_sizes(:,2) > 1);
if ~isempty(multicol)
    fprintf('Some non-char variables have multiple columns! Index: \n');
    disp(nonchar(multicol));
    fprintf('sizes:\n');
    nonchar_sizes(multicol, :);
end
if isempty(oddsized) && isempty(multicol)
    fprintf('All non-char variables are single column, as desired\n');
end

Walter Roberson 2020-12-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678993-how-to-write-this-line-of-code-to-create-a-matlab-table#comment_1185908

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678993-how-to-write-this-line-of-code-to-create-a-matlab-table#comment_1185908

在 MATLAB Online 中打开

Oh wait:

TT = table(Var{:});

should do the trick.

Leon 2020-12-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678993-how-to-write-this-line-of-code-to-create-a-matlab-table#comment_1186018

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/678993-how-to-write-this-line-of-code-to-create-a-matlab-table#comment_1186018

Hooray!!!

Thank you so much. I really appreciate your weekend time to help me out. Enjoy the rest of your weekend.

请先登录，再进行评论。

另请参阅

类别

MATLAB Language Fundamentals Data Types Numeric Types Logical

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

产品

MATLAB

版本

R2020b

Community Treasure Hunt

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

Start Hunting!

发生错误

由于页面发生更改，无法完成操作。请重新加载页面以查看其更新后的状态。

Translated by

选择网站

选择网站以获取翻译的可用内容，以及查看当地活动和优惠。根据您的位置，我们建议您选择：。

(English)
(Deutsch)
(Français)

（简体中文）
(English)

您也可以从以下列表中选择网站：

如何获得最佳网站性能

选择中国网站（中文或英文）以获得最佳网站性能。其他 MathWorks 国家/地区网站并未针对您所在位置的访问进行优化。

美洲

América Latina (Español)
Canada (English)
United States (English)

欧洲

Belgium (English)
Denmark (English)
Deutschland (Deutsch)
España (Español)
Finland (English)
France (Français)
Ireland (English)
Italia (Italiano)
Luxembourg (English)

Netherlands (English)
Norway (English)
Österreich (Deutsch)
Portugal (English)
Sweden (English)
Switzerland
United Kingdom(English)

亚太

Australia (English)
India (English)
New Zealand (English)
中国
- 简体中文Chinese
- English
日本Japanese (日本語)
한국Korean (한국어)

联系您当地的办事处

How to write this line of code to create a Matlab table?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

采纳的回答

10 个评论
显示 8更早的评论隐藏 8更早的评论

更多回答（0 个）

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

How to write this line of code to create a Matlab table?

0 个评论 显示 -2更早的评论隐藏 -2更早的评论

采纳的回答

10 个评论 显示 8更早的评论隐藏 8更早的评论

更多回答（0 个）

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

10 个评论
显示 8更早的评论隐藏 8更早的评论