Writematrix command not writing data in my excel sheet
4 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
sname='Sheet1';
startingColumn='A';
nextRow='1';
filename = 'C:\Users\vvb\Documents\New\ltp.xlsx';
ltp_hist_uper=hist(ltp_uper,10);
ltp_hist_lower=hist(ltp_lower,10);
ltp_full=[ltp_hist_uper ltp_hist_lower]; % contatinate both uper and lower vectors
range=sprintf('%s%d',startingColumn,nextRow);
writematrix(ltp_full,filename,sname,range);
I have download this code for extracting features from an audio file and want to store those features in Excel file which is ltp.xlsx but writematrix command is throwing an error i.e. Invalid parameter name: Sheet1
0 Kommentare
Antworten (1)
Abdolkarim Mohammadi
am 23 Aug. 2020
Bearbeitet: Abdolkarim Mohammadi
am 23 Aug. 2020
You should pass sheet name and range as a Name-Value pair argument:
writematrix (ltp_full, filename, 'Sheet', sname, 'Range', range)
Read the documentation of readmatrix():
https://www.mathworks.com/help/matlab/ref/writematrix.html
6 Kommentare
Abdolkarim Mohammadi
am 24 Aug. 2020
Your code should work fine with any input, since ltp_full has a fixed dimension of 10x2. If this dimension is being changed within a loop, it is better to first clear the destination cells for shorter matrixes to be better observed.
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!