Importing 4D Excel data sets

2 次查看（过去 30 天）
Madison Padilla
Madison Padilla 2021-7-8
回答： Jeremy Hughes 2021-7-28
Hello, so I am dealing with an excel document that has 4D tables and I am not sure how to import it. I've included an example below of what it looks like. Bascially the data is organized by the view, then the mass, then the results for different components at different velocities. Using the import function on MATLAB for tables results in the purple area shown below as not importable. I can import and get a long list of component vs velocity, but no identifiers as to their respective view and mass.
So is there a way to go about this? The excel code is about 5000 lines long with repeating tables, so it would be nice to not have to process that data manually to find averages for the total views. I thought maybe using a for loop and attempting to assign data to its respective view/mass, but that's purely me spitballing as I am not sure how to handle this. Thanks for any advice!
  1 个评论
dpb
dpb 2021-7-8
Attach a sample file for folks to play with...and then show an example of what expected/wanted results would be.

请先登录，再进行评论。

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

回答（1 个）

Jeremy Hughes
Jeremy Hughes 2021-7-28
You might try readcell. It will at least give you all the data.
You will have to restructure it to get the format you'd like.

类别

在 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