Error: The specified data range is invalid
显示 更早的评论
I am writing a code where Matlab gives output in an excel file. The output is in the form of various values that are to be put in adjacent cells in excel. I used below command:
cell = sprintf('G%s',3+num2str(i)); xlswrite('Data_Management.xlsx',RPMhist1,'Data',cell);
Here, the output is obtained from G4 cell. There are multiple files from which the code is getting input. (These files are in different form and thus I need to get the output in excel)
I am getting below error: Error using xlswrite (line 219) The specified data range is invalid or too large to write to the specified file format. Try writing to an XLSX file and use Excel A1 notation for the range argument, for example, ‘A1:D4’. Error in SeparateChannels (line 37) xlswrite('Data_Management.xlsx',RPMhist1,'Data',cell);
1 个评论
xi
2017-5-10
You need to provide information about RPMhist1. try RPMhist1='A', the above code shows no errors.
回答(0 个)
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!