mat2piv.m

Flatten an N-dimensional tensor into an Excel pivottable ready form

您现在正在关注此提交

Takes an N-dimensional vector/matrix/tensor M and optional user-provided labels and flattens it into a cell array suitable for use as an Excel pivot table datasource. The resultant 2-dimensional cell array P will be a matrix with one row per element in M and N+1 columns: one column to hold each dimension's labels plus one to hold the values. This cell array P is suitable for export to Excel to be used as a data source for a pivot table.

引用格式

dan (2026). mat2piv.m (https://ww2.mathworks.cn/matlabcentral/fileexchange/47446-mat2piv-m), MATLAB Central File Exchange. 检索时间: .

致谢

参考作品: Pivot/unPivot, pivottable

启发作品: mjeppesen/matlab-pivot-table

类别

Help CenterMATLAB Answers 中查找有关 Tables 的更多信息

一般信息

MATLAB 版本兼容性

  • 兼容任何版本

平台兼容性

  • Windows
  • macOS
  • Linux
版本 已发布 发行说明 Action
1.0.0.0