清空筛选条件
清空筛选条件

Writematrix command not writing data in my excel sheet

2 次查看（过去 30 天）
Ralph
Ralph 2020-8-23
评论： Abdolkarim Mohammadi 2020-8-24
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

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

回答（1 个）

Abdolkarim Mohammadi
编辑：Abdolkarim Mohammadi 2020-8-23
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 个评论
显示 4更早的评论
Abdolkarim Mohammadi
Abdolkarim Mohammadi 2020-8-24
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.

请先登录，再进行评论。

类别

在 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