how to export complete workspace data (containing objects, matrices, cells & structures) to one excel sheet ?

My workspace data consists of objects, cell array, structures and matrices .. and I am unable to write or export all these in one excel sheet.

Is there any command or simple code for this ?

I am trying to develop code for undistorted fisheye image . As shown in below pic for the workspace I want to export all the variables , the object ( cameraParams) and their values to xlsx. How do I do that ?

[Rik]

What exactly would you like to achieve? Are there specific variables you're looking for? Do you want to store variables as a checkpoint? Do you simply want a data dump?

This question sounds like you want to do something, but you are assuming a solution that may be suboptimal.

[anisha xyz]

I want to dump all the data of workspace to a single excel sheet... So that a non- user of MATLAB can easily read all the workspace data (all Variables and Values ) at once ...from xls file ..Hope this clarifies

[Stephen23]

https://xyproblem.info/

"Is there any command or simple code for this ?"

SAVE and LOAD

[Rik]

There are builtin tools to save matrices to Excel. So what you need to do is to decide how you want to show each property in Excel.

What have you tried so far to do that?

Answer 1

[Walter Roberson]

No there is no simple way to do that. There is no complicated way to do it either. Excel lacks the capacity to represent hierarchy of structured data within a single sheet.

[Walter Roberson]

json can help.

https://www.howtogeek.com/775651/how-to-convert-a-json-file-to-microsoft-excel/

However you will need to convert the objects to a different form, possibly by using struct()

... Does the person truly need the complete list of file names from the datastore? Fully qualified names?