MATLAB: How to delete cells in Excel and make the adjacent cells move in specific order

activexexcel

I've just learnt that we can actually use ActiveX to manipulate Excel, but not quite familiar yet. I have an Excel file that have words like

 'word1:word10' in Column A, sheet 1, '1:20' in Column B.

Now if I want to delete 'word6', the default act would be that 'word7:word10' will move one cell up. However, as I delete the cells 'word8:word10', the default act is moving the digits '8:10' to the left. And this is not what I want. Could you tell me how could I change the actions after deleting some cells? And where can I find more information related to ActiveX for Excel so that I can correct myself? Much appreciated.

Best Answer

The easiest way to figure out the ActiveX commands to do is to record a macro in Excel (not MATLAB). Start recording in Excel. Then do your stuff and stop the recording. Then edit the macro and look at the ActiveX commands it put into the VBA file. Then transfer those to MATLAB with a few minor changes.

Related Solutions

MATLAB: Tiedrank in descending order

Hi Ekin,

You can the reverse the order of ranking programmatically as follows:

 %Store the result of tiredrank function in "a"
a = tiedrank([10 20 30 40 20]);
%Find the largest rank value of "a", increment it by 1 and subtract "a" by
%this value.
ranks_desc = (max(a)+1) - a;

This will just reverse the ranking received by "tiedrank" function.

MATLAB: Assign names in order

While you can generate variable names on the fly (using eval), it's not a good idea as it makes the code harder to understand, harder to debug, harder to check for syntax error and slower to execute.

In your case, what I would do is create structure arrays:

%hypothetical processing code
for imgindex = 1 : numimages
   img = loadimage(imgindex); %load an image
   numregions = regioncount(img); %get number of region
   for regionindex = 1 : numregions
      [area, centroid] = regionproperties(img, regionindex); %get property of region
      %HERE is where you store the result in structure arrays:
      imageprops(imgindex).region(regionindex).area  = area;
      imageprops(imgindex).region(regionindex).centroid = centroid;
   end
end

To access the area of the 5th region of the 3rd image:

area = imageprops(3).region(5).area;

Best Answer

Related Solutions

MATLAB: Tiedrank in descending order

MATLAB: Assign names in order

Related Question