I have a 27 x 68 matrix written in excel using MATLAB. The cells in excel with value 0 needs to be replaced with a blank for a selected range of "C16:AC83".
Can you please suggest a command to do this.
I am using—– Excel = actxserver('Excel.Application');
so far i have found the command — Excel.Activesheet.Cells.Replace(65535,[ ],[ ],1);
What is the applicable syntax?
Best Answer