Receiving NaN's instead of values in select excel imports (script issue)

Hi, I am trying to extract mean eigenvalues and vectors for spinel grains in rock samples I am studying.

When I import (all as numerical matrices) the .xlsx sheets with less rows (up to 961 rows) it works fine. Anything higher (next highest has 1223 rows) spits out NaN's. Workflow up to this point has been the same. Any help appreciated.

I just need to do

x=spinelMean(AA) **I've been calling the imports AA** and I should get a 3x3 matrix of values.

Thanks in advance.

[Dyuman Joshi]

"When I import (all as numerical matrices) the .xlsx sheets with less rows (up to 961 rows) it works fine. Anything higher (next highest has 1223 rows) spits out NaN's."

How are you importing the data?

It's working fine with readtable

Answer 1

[Yash]

Hi Julian,

As I can understand, you are encountering issues with importing the data. In general, '.xlsx' files are imported into tables using the "readtable()" function. I have made an attempt to read the data provided in your query using the "readtable()" function, and it is functioning correctly. You can find more details about the "readtable()" function by visiting the following documentation link:

https://www.mathworks.com/help/matlab/ref/readtable.html

Additionally, you may find the article below helpful, as it provides various methods for reading spreadsheets into tables:

https://www.mathworks.com/help/matlab/import_export/read-spreadsheet-data-into-table.html

I hope the provided information helps in resolving the issue.

If the issue still persists, for better understanding of the issue, I suggest you share the code you are using to import the sheets. I am not able to reproduce the issue at my end because there is an unknown function in the "spinelMean.m" file named "logEFromSpinel". Any information related to the definition of this function would help me to resolve the issue.