Trying to export data from .mat file to excel
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Greetings all,
I have a large data set in .mat file (18 columns and more then 4 million rows), the data consists of numbers, dates, characters and NaN cells,
my code is as follows,
data=load('rtd.mat');
fn=fieldnames(data); %get all variable names
assert(numel(fn)==1); %assert there is only one variable in your mat, otherwise raise error
firstdiff = data.(fn{1}); %get the first variable
xlswrite('File.xlsx', firstdiff); %write it%Z
i get an error of
(Error using xlswrite (line 170)
Input data must be a numeric, cell, or logical array.)
Appreciate your support
Réponses (1)
Aritra
le 30 Jan 2023
Hi,
As per my understanding you are trying to export the data from a .mat file to an excel. However, the .mat file contains fields with ‘NAN’ values which results in the following error:
(Error using xlswrite (line 170)
Input data must be a numeric, cell, or logical array.)
Excel fails to interpret the NaNs in a numberic matrix.
To write a matrix with NaNs to an Excel file, the NaN values must be explicitly written as strings like 'NaN'. To achieve the same, you can convert your data matrix to a cell and replace all NaNs with 'NaN' before writing to Excel as shown below:
A = load(<filename.mat>);
B = num2cell(A);
B(isnan(A)) ={'NaN'};
xlswrite(filename,B);
2 commentaires
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!