Hello, i have the following code but whenever i run it, it returns an error that " Error using xlswrite (line 207) Invalid data range: ."

Question

muhammad komugabe 2017-6-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/345152-hello-i-have-the-following-code-but-whenever-i-run-it-it-returns-an-error-that-error-using-xlswr

回答： muhammad komugabe 2017-9-6

for ii=1:size(ug_waterthickness_deficits,3);
   xlswrite('GRACE2_UG.xls', ug_waterthickness_deficits(:,:,ii),['month_' num2str(ii)]);
end

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

muhammad komugabe 2017-6-19

Simon thanks

请先登录，再进行评论。

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

Answer 1

Jan 2017-6-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/345152-hello-i-have-the-following-code-but-whenever-i-run-it-it-returns-an-error-that-error-using-xlswr#answer_271133

在 MATLAB Online 中打开

If the line

xlswrite('GRACE2_UG.xls', ug_waterthickness_deficits(:,:,ii),['month_' num2str(ii)]);

produces the error

 Error using xlswrite (line 207)
 Invalid data range: .

the code creates a range, which includes a ".". Use the debugger to find out, where this dot is coming from: Type this in the command window:

dbstop if error

Then run the code again until it stops at the error. Now check what has been provided as range. You have to search in the caller workspaces and if you are not familiar with using the debugger, this is the best time to learn how to use it:

docsearch debugger

Alternatively, you can display the values directly in the code:

disp(ug_waterthickness_deficits(:,:,ii))
disp(['month_' num2str(ii)])
xlswrite('GRACE2_UG.xls', ug_waterthickness_deficits(:,:,ii),['month_' num2str(ii)]);

I do not see, where the dot is coming from, but you have all information to solve this problem on your computer.

2 个评论
显示无隐藏无

Image Analyst 2017-6-19

I don't see how this solved the problem. The code does NOT create a range. There are three input arguments to xlswrite.

The first input argument is 'GRACE2_UG.xls' and it is the filename.
The second is ug_waterthickness_deficits(:,:,ii) and it is the numerical data.
The third is ['month_' num2str(ii)] and it is a string that is interpreted as a sheet name.

There is no fourth input argument, and so no range is specified.

Like I said, if he's getting that error, he didn't give us the correct code. In fact I ran the exact code he gave and it ran fine. Plus he's not giving us the complete error message - ALL the red text - like I asked so we don't really know the line of code that is throwing the error.

Jan 2017-6-19

@Image Analyst: You are right, this message does not solve the problem directly. But perhaps using the debugger let the OP find the line, which is really failing.

请先登录，再进行评论。

Answer 2

Image Analyst 2017-6-17

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/345152-hello-i-have-the-following-code-but-whenever-i-run-it-it-returns-an-error-that-error-using-xlswr#answer_271010

编辑：Image Analyst 2017-6-17

在 MATLAB Online 中打开

It works fine. I just tried it:

ug_waterthickness_deficits = rand(4,5,6);
for ii=1:size(ug_waterthickness_deficits,3)    
  xlswrite('GRACE2_UG.xls', ug_waterthickness_deficits(:,:,ii),['month_' num2str(ii)]); 
end

In your code, you may have left out a comma or added an extra one. For some reason it thinks ['month_' num2str(ii)] is not the sheet name, but thinks it's the cell reference instead. Please post your ACTUAL code along with ALL the red text.

Also, read this to learn how to format your code

5 个评论
显示 3更早的评论隐藏 3更早的评论

muhammad komugabe 2017-6-20

@simon, after dropping the error with simon's approach, it worked a litlle fine but later on the errors came back and now all the script cannot run fine.

@image analyst, let me paste the whole text and may be you may see it and help me to correct it. But all in all thanks for the efforts. below is the whole code execution

Warning: Function repmat has the same name as a MATLAB builtin. We suggest you rename the function to avoid a potential name conflict. Warning: Function repmat has the same name as a MATLAB builtin. We suggest you rename the function to avoid a potential name conflict. > In C:\Program Files\MATLAB\R2013b\toolbox\slvnv\reqmgt\+rmi\settings_mgr.p>settings_mgr at 26 In C:\Program Files\MATLAB\R2013b\toolbox\slvnv\reqmgt\+rmiml\selectionLink.p>selectionLink at 24 Warning: Function repmat has the same name as a MATLAB builtin. We suggest you rename the function to avoid a potential name conflict. > In C:\Program Files\MATLAB\R2013b\toolbox\slvnv\reqmgt\+rmi\settings_mgr.p>settings_mgr at 26 In C:\Program Files\MATLAB\R2013b\toolbox\slvnv\reqmgt\+rmiml\selectionLink.p>selectionLink at 24 >> load('GRCTellus.CSR.200204_201607.LND.RL05.DSTvSCS1409_Uganda.mat'); Warning: Function repmat has the same name as a MATLAB builtin. We suggest you rename the function to avoid a potential name conflict. > In C:\Program Files\MATLAB\R2013b\toolbox\slvnv\reqmgt\+rmi\settings_mgr.p>settings_mgr at 26 In C:\Program Files\MATLAB\R2013b\toolbox\slvnv\reqmgt\+rmi\initialize.p>initialize at 27 In rmi at 180 In C:\Program Files\MATLAB\R2013b\toolbox\slvnv\reqmgt\+rmi\linktype_mgr.p>linktype_mgr at 86 In C:\Program Files\MATLAB\R2013b\toolbox\slvnv\reqmgt\+rmiml\selectionLink.p>selectionLink at 27 Warning: Function repmat has the same name as a MATLAB builtin. We suggest you rename the function to avoid a potential name conflict. > In C:\Program Files\MATLAB\R2013b\toolbox\slvnv\reqmgt\+rmi\settings_mgr.p>settings_mgr at 26 In C:\Program Files\MATLAB\R2013b\toolbox\slvnv\reqmgt\+rmi\initialize.p>initialize at 27 In rmi at 180 In C:\Program Files\MATLAB\R2013b\toolbox\slvnv\reqmgt\+rmi\linktype_mgr.p>linktype_mgr at 86 In C:\Program Files\MATLAB\R2013b\toolbox\slvnv\reqmgt\+rmiml\selectionLink.p>selectionLink at 27 >> climatology=NaN(size(Ug_waterthickness)); for ii=1:7; for jj=1:7 for m=1:12 ind=find(month(timenew)==m); climatology(ii,jj,ind)=nanmean(Ug_waterthickness(ii,jj,ind)); % this creates a timeseries of monthly vareages that repeats every 12 months clear ind end end end Undefined function or variable 'Ug_waterthickness'.

>> ug_waterthickness_deficits=Ug_waterthickness-climatology; Undefined function or variable 'Ug_waterthickness'.

>> for ii=1:size(ug_waterthickness_deficits,3); xlswrite('GRACE2_UG.xls', ug_waterthickness_deficits(:,:,ii),['month_' num2str(ii)]); end

Image Analyst 2017-6-20

在 MATLAB Online 中打开

What does this show

>> which -all repmat

Jan 2017-6-20

@muhammad komugabe: It seems like you have created a file called "repmat.m", but this collides with Matlab's built-in function.

The message "Undefined function or variable 'Ug_waterthickness'" is clear also. Perhaps you want a lower-case 'u'?

Please take the time to read the error messages by your own.

请先登录，再进行评论。

Answer 3

muhammad komugabe 2017-9-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/345152-hello-i-have-the-following-code-but-whenever-i-run-it-it-returns-an-error-that-error-using-xlswr#answer_280453

Hey team, I want to calculate a time series average for the assigned regions (Northern , Eastern , southern and central as shown in the map) for this map, using a 6x6 cell data as shown in the excel sheet(ignore the first column and last row to suit the shape read). Kindly help me. thanks

Please refer to excel sheet for clarity. I will be glad for any useful help. Thanks