Doug's MATLAB Video Tutorials

March 28th, 2012

By Doug Hull

Doug first used MATLAB in 1994, could not figure it out until he got some help in 1995. He is now dedicated to making sure that no one else wastes a year of their life not knowing MATLAB like he did.

12:08 UTC | Posted in Format: Video, Level: Basic, Topic: Excel | Permalink | 7 Comments »

You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.

7 Responses to “MATLAB Tutorial, processing an Excel file in MATLAB”

1. vallisha replied on April 1st, 2012 at 06:43 UTC :
   

   Hello Sir,

   Suppose I have the pixel value, how to find the corresponding pixel position in image ?

   Ex: If the pixel value is 160, i want to get the positions of the pixels in the image for which the value is 160.

2. Doug replied on April 2nd, 2012 at 10:56 UTC :
   

   @Vallisha,

   This is more of a matrix indexing question. You can use FIND to do that.

   Doug

3. vallisha replied on April 2nd, 2012 at 11:57 UTC :
   

   Thanks a lot.
   Used this :

   index = find(img(:)== 160)

4. Chen replied on June 14th, 2012 at 22:54 UTC :
   

   Hi,

   I can write cells to Excel if numbers are specifid.
   I can write simple matrices to excel.

   But, is it possible to write something like this to excel:

   a=[1 2; 3 4 ; 5 6]
   d={‘Temp’, Time; a}
   xlswrite(‘ExcelNmae’, d);

   Thanks,

   Chen

5. Doug replied on June 15th, 2012 at 10:39 UTC :
   

   Take a look at xlswrite.

6. Mohammed Qahwaji replied on November 5th, 2012 at 13:02 UTC :
   

   If I have an excel sheet that have only numbers on it. And I want to find how much some values repeated.( like how many times there is number 6 in the excel sheet?) how can I find these values by matlab?

7. Doug replied on November 19th, 2012 at 16:05 UTC :
   

   First I would import into MATLAB with XLSREAD. Once you have a matrix in, like

   a = [11 22 33 22 22]

   nnz(a == 22)

   will do what you want for 22.

Leave a Reply

<pre class="code">
a = magic(3);
sum(a)
</pre>

These postings are the author's and don't necessarily represent the opinions of MathWorks.