Search Comments and Ratings

go

Comments and Ratings

   
Date File Comment by Comment Rating
13 Oct 2009 msopen Opens Microsoft Office files (Word, Excel, Power Point, Project, & Access). Author: Fahad Al Mahmood Kimberly

Is this command similar to officedoc and winopen.m?

09 Oct 2009 xlsheets Creating sheets and naming them in Excel. Author: Fahad Al Mahmood Tseng, Tina

16 Sep 2009 Encode Decode ASCII Binary 2 M-files to encode or decode ASCII and binary numbers. Author: Fahad Al Mahmood Francesco

21 Jun 2009 speak This function uses Excel to speak entered texts or numbers. Author: Fahad Al Mahmood nasry, marian

thanks for this code very much, but i've one question: How can I control the speed of speech??
please help me

29 May 2009 Morse Code This converts text to playable morse code in wav format. Author: Fahad Al Mahmood Esben

Nice little useful program for training your morse skills:)

I updated the code a little, if anyone is interested... (feel free to add it to the original):

To have smaller spaces between letters, change line 33 from lsp = wav(6176:23022); to lsp = wav(6176:16022);

To add danish letters æ,ø,å (can be done for any additional signs, and I probably will later), add
AE = [Dit;ssp;Dah;ssp;Dit;ssp;Dah]; % danish Æ .-.-
OE = [Dah;ssp;Dah;ssp;Dah;ssp;Dit]; % danish Ø ---.
AA = [Dit;ssp;Dah;ssp;Dah;ssp;Dit;ssp;Dah]; % danish Å .--.-
and change
vars ={'period','comma','question','slash_'}; to
vars ={'period','comma','question','slash_','AE','OE','AA'};
and change
    elseif ismember(text(i),'.,?/')
        x = findstr(text(i),'.,?/');
to
    elseif ismember(text(i),'.,?/ÆØÅ')
        x = findstr(text(i),'.,?/ÆØÅ');

to modify the speed, a resampling is added in the last part (just after the loop):
morsecode=resample(morsecode,Fs,15000); % resample to Fs/15000
if the numberused is higher than Fs, the speed will be higher, if it is lower, the speed will be lower...

22 Apr 2009 xlsfont, xlsalign, xlsborder, xlswordart, xlscomment 5 functions to modify Microsoft Excel cell format & adds comments and WordArt Author: Fahad Al Mahmood Aktas, Sahin

10 Apr 2009 xlsfont, xlsalign, xlsborder, xlswordart, xlscomment 5 functions to modify Microsoft Excel cell format & adds comments and WordArt Author: Fahad Al Mahmood Aviator

This is great absolutely handy and well-written. This was what I was looking for for a long time.... Thanks. Keep up the good work.

25 Mar 2009 xlsgraph Creates graphs from existing Excel sheet containing column data. Author: Fahad Al Mahmood Gómez Jiménez, David

Respecto al problema de Javier Seminario y la solución de Hinrich Koetter

Si teneis Excel en castellaño o español, teneís que sustituir 'R' y 'C' por 'L' (Linea) y 'C' (Columna)

25 Mar 2009 xlsgraph Creates graphs from existing Excel sheet containing column data. Author: Fahad Al Mahmood Gómez Jiménez, David

15 Jan 2009 spellcheck This function checks the spelling of a word and returns suggestions if misspelled. Author: Fahad Al Mahmood Ahi, Taha

08 Dec 2008 xlsgraph Creates graphs from existing Excel sheet containing column data. Author: Fahad Al Mahmood Koetter, Hinrich

Thank you very much! Very useful tool! For everybody who has problems like mentioned by javier seminario: You have to change some lines if you have another system setup (language):
            
Excel.ActiveChart.SeriesCollection(i).XValues = ['=' sheetname ' R2C1:R' int2str(nr+1) 'C1'];
Excel.ActiveChart.SeriesCollection(i).Values = ['=' sheetname '!R2C' int2str(i+1) ':R' int2str(nr+1) 'C' int2str(i+1)];

In this both lines as well as in the following both you have to change R (Row) and C (Column) to the abbreviations used in your language (german: Z (Zeile), S (Spalte)).

Excel.ActiveChart.SeriesCollection(noOfSeries).XValues = ['=' sheetname '!R2C' int2str(locx(j)) ':R' int2str(nr+1) 'C' int2str(locx(j))];
Excel.ActiveChart.SeriesCollection(noOfSeries).Values = ['=' sheetname '!R2C' int2str(locy(j)) ':R' int2str(nr+1) 'C' int2str(locy(j))];

In the following line you have to change word 'Sheet' (only the last one in quotation marks) to the adequate word in your language (german: Tabelle).

Sheet = get(Workbook.Sheets,'Item',['Sheet',num2str(i)]);

You can use try and catch to capture different languages.

09 Oct 2008 google Shortcut for web searching using Google's different search areas (images, groups, etc.). Author: Fahad Al Mahmood Gamil, Gamal

SO GOOD.

24 Sep 2008 xlsheets Creating sheets and naming them in Excel. Author: Fahad Al Mahmood Wilson, Andrew

Works perfectly and solves a problem for me. The work is much appreciated.

16 Sep 2008 table2word Creating table in Microsoft Word Document using titles and a matrix. Author: Fahad Al Mahmood Khekare, Anup

Works perfect for me...I wanted simple tables though....Must look through every table style...

But excellent work...takes care of all the book keeping for me....

thanks again...keep up the good work...

14 Sep 2008 Helicopter Control Design Simple design for helicopter control system Author: Fahad Al Mahmood Onat, Mustafa

02 Sep 2008 msopen Opens Microsoft Office files (Word, Excel, Power Point, Project, & Access). Author: Fahad Al Mahmood Hayden, David

dos('filename') is easier, except if you have spaces in your filename.

13 Aug 2008 xlschart Writes column headers and a matrix to excel and graphs all columns or two specified columns. Author: Fahad Al Mahmood Cantero, Luis

I don't know if this worked with Excel 2003. I had to change the following code in order to make it work:
%%%
%Excel.ActiveChart.SeriesCollection(i).XValues = ['=' sheetname '!R2C1:R' int2str(nr+1) 'C1'];
Excel.ActiveChart.SeriesCollection(i).XValues = Excel.ActiveWorkbook.Sheets.Item(sheetname).Range(['A2:A' int2str(nr+1)]);

%Excel.ActiveChart.SeriesCollection(i).Values = ['"=' sheetname '!R2C' int2str(i+1) ':R' int2str(nr+1) 'C' int2str(i+1) '"'];
Excel.ActiveChart.SeriesCollection(i).Values = Excel.ActiveWorkbook.Sheets.Item(sheetname).Range([Excel.ActiveWorkbook.Sheets.Item(sheetname).Cells.Item(int2str(i+1)).Item(2).Address ':' Excel.ActiveWorkbook.Sheets.Item(sheetname).Cells.Item(int2str(i+1)).Item(int2str(nr+1)).Address]);
%%%

07 Aug 2008 msopen Opens Microsoft Office files (Word, Excel, Power Point, Project, & Access). Author: Fahad Al Mahmood Dalon, Thierry

Indeed winopen seems to do the same.
msopen has following extended features:
- can open several files in a row
- allows wildcard in filespec
- allows partial path
which make it anyway very useful.

I would have following improvements (that's why only a 4 rating):
- it would be nice if you could take as input a list (cellstr) of files and not only the command window syntax.
- there is a small bug if no file was found. (you should check if output of wildfiles==0 to exit properly)

I am using this file because I want to be able to open also txt files with Excel. I've modified the file
switch fext
        case {'.xls','.xla','.xlt','.txt'}
so it handles this.
This can winopen definitely not do as well!

23 May 2008 pic2xls This function inserts a picture into an Excel file Author: Fahad Al Mahmood Jardim, Christian

Excelent work...

   I've got a problem using this function, however.. Lately I've been working on generating an automated Excel report. This report contains some figures which were imported from MATLAB using your code..
    Since these figures are pasted into my report (and saved), they are still there when I try to generate the next report.. This way, everytime I finish a report, I have to save it to another file and manually remove the figures, to avoid overlapping the next time I run the report generator program..
  My question is: Is there a Matlab routine (or activex command) to delete the figures (in an Excel spreadsheet) so they will not be present when a new report is generated???

  Hope you can give me a clue...

   Thanks in advance..
 
  Christian

21 Mar 2008 Laminate Analysis Program Program analysing each layer in a composite. Author: Fahad Al Mahmood ss, ss

excellent

19 Mar 2008 Helicopter Control Design Simple design for helicopter control system Author: Fahad Al Mahmood Ayyad, Ezzat

Good work.
Just did not use the conventaional Euler angles as the standard 6 DOF in aviation.

15 Mar 2008 Laminate Analysis Program Program analysing each layer in a composite. Author: Fahad Al Mahmood Mohammed, Houari

11 Mar 2008 Morse Code This converts text to playable morse code in wav format. Author: Fahad Al Mahmood Bhatt, Chirag

Hi , While running this program , I found the following error,
*************************************
??? Index exceeds matrix dimensions.

Error in ==> morse at 23
text = varargin{1};
*****************************************
My version is 7.2(R2006a)
What I have to do?

08 Mar 2008 Morse Code This converts text to playable morse code in wav format. Author: Fahad Al Mahmood Knox, Chris

07 Mar 2008 Laminate Analysis Program Program analysing each layer in a composite. Author: Fahad Al Mahmood Mehdi, Yawar

Its a good effort. Very helpful.

01 Jan 2008 findreplace This function finds and replaces strings in a text file Author: Fahad Al Mahmood King, Ellis

The problem with removing '%' comment lines in .m files is caused by the fprintf function using the same character to indicate input. This function can be improved for use with .m files by inserting the additional check inside the 'for' loop, prior to the fprintf call at line 117:

if strcmp(fext, '.m')
    line{i} = strrep(line{i},'%','%%');
end

The logic ensures that the comments apply only for .m files.

Otherwise, it works fairly well.

25 Nov 2007 xlsfont, xlsalign, xlsborder, xlswordart, xlscomment 5 functions to modify Microsoft Excel cell format & adds comments and WordArt Author: Fahad Al Mahmood W, J

Very useful, I have been looking for this for long time....

29 Oct 2007 Helicopter Control Design Simple design for helicopter control system Author: Fahad Al Mahmood Sharma, Rahul

21 Sep 2007 speak This function uses Excel to speak entered texts or numbers. Author: Fahad Al Mahmood Saxena, Ankit

20 Sep 2007 msopen Opens Microsoft Office files (Word, Excel, Power Point, Project, & Access). Author: Fahad Al Mahmood Simard, Dany

Thanks, good to do the simple task of opening those files

17 Sep 2007 Helicopter Control Design Simple design for helicopter control system Author: Fahad Al Mahmood sera, sera

Some Errors in the .m file need to be fixed according to the document:
Matrix A:
  A(2, 3) should be Zq+Ue
  A(4, 3) should be cos(PHIe)
  A(4, 8) should be -sin(PHIe)

12 Sep 2007 speak This function uses Excel to speak entered texts or numbers. Author: Fahad Al Mahmood Tareq, M

very funny!!

18 Aug 2007 xlsfont, xlsalign, xlsborder, xlswordart, xlscomment 5 functions to modify Microsoft Excel cell format & adds comments and WordArt Author: Fahad Al Mahmood l, g

Not sure why nobody commented. But these are exactly what I am looking for!

11 Aug 2007 Morse Code This converts text to playable morse code in wav format. Author: Fahad Al Mahmood Hai, Elvin

It's a great program! May I know how the data in the wav.mat was obtained?

16 Jul 2007 Encode Decode ASCII Binary 2 M-files to encode or decode ASCII and binary numbers. Author: Fahad Al Mahmood Parr, Matthew

10 Jul 2007 google Shortcut for web searching using Google's different search areas (images, groups, etc.). Author: Fahad Al Mahmood ....., soso

10 Jul 2007 Laminate Analysis Program Program analysing each layer in a composite. Author: Fahad Al Mahmood ?ZG?L, Ali

Plainly, this work's application very nice and usefully for several civil, mechanical etc.. engineering areas.

I think, this file documantation, description and program-running-algorithm's flow not-regular. I know epoxi-laminate composite plate system with analytical and finite element solution technique but all-user don't know this theory and method.

If you use one-main program instead of more-sub programs (with input and output veriables) than this program and work be more likeable.

I was tested your program running algorithms to several thin and thick plate model for true-solution and shear locking effect. But I don't see shear locking program module or procedure in main-program.
Analysis results, different the Reissner-Mindlin thick plate model.

I think this files need more improvement but I know this area's works are very hard and require the more works-time.

Good works, Best Regard

09 Jul 2007 Laminate Analysis Program Program analysing each layer in a composite. Author: Fahad Al Mahmood hajiloo, hamze

civil engineering

29 Jun 2007 xlcolumn Converts Excel column name to column number and vise versa. Author: Fahad Al Mahmood Miller, Craig

Works exactly as intended. Solved a problem for me quickly and kept me from having to write a function.

15 Jun 2007 speak This function uses Excel to speak entered texts or numbers. Author: Fahad Al Mahmood Schmitz, Christian

funny!

30 May 2007 xlsgraph Creates graphs from existing Excel sheet containing column data. Author: Fahad Al Mahmood U, A

This function was a great start and I was using it often with some additions/modifications. Then they upgraded me to Office 2007 at work and it was down hill from there. Seems that many of the properties have changed or are no longer available to set and numerous errors occur now. I managed to strip alot of the extras out so it would run but the graphs are all messed up when I open excel (extra series plotted for no apparent reason).

24 May 2007 Laminate Analysis Program Program analysing each layer in a composite. Author: Fahad Al Mahmood Guzman, Andres

It's a good problem but needs some improvements. There are some failures in syntax.

22 May 2007 Encode Decode ASCII Binary 2 M-files to encode or decode ASCII and binary numbers. Author: Fahad Al Mahmood yuen, lingbin

16 Apr 2007 xlsheets Creating sheets and naming them in Excel. Author: Fahad Al Mahmood Sceleton, Exo

Thank you for your sharing mentality.
Just the lines of code i needed.

09 Apr 2007 findreplace This function finds and replaces strings in a text file Author: Fahad Al Mahmood dindar, ahmet anýl

I've just used it. I have a *.dat file in which I want to change a specific number. It changes efficiently, but somehow the lines are re-arranged as one after each other horizontally instead of vertically with a small square character. It confuses me te follow the inputs in the files after using find/replace. Therefore, I sugges the author to succed keeping the original file as it was after applying the .m code.

29 Mar 2007 Helicopter Control Design Simple design for helicopter control system Author: Fahad Al Mahmood gambler, alex

just a simple model.

28 Mar 2007 Laminate Analysis Program Program analysing each layer in a composite. Author: Fahad Al Mahmood sonawane, nilesh

The program is quiet good,

26 Mar 2007 pic2xls This function inserts a picture into an Excel file Author: Fahad Al Mahmood Jacob, Steve

I was able to use it and it produced the results I needed without much difficulty.

29 Dec 2006 dictionary Checks the spelling status of word(s) and returns synonyms if found. Author: Fahad Al Mahmood n, Joseph

Well done.

18 Oct 2006 pic2xls This function inserts a picture into an Excel file Author: Fahad Al Mahmood Suliman, Tamir

 Hello Fahad

There is an error occurs when we tried to run the file.I tried to tell the the Function on m files written the location or the destination of the picture and the files I think that what solves the Invoke problem but still no results imported to the excel file

thats what I did

pic = 'C:\Documents and Settings\Engr.Tamir Suliman\Desktop\005.jpg';
file = 'C:\Documents and Settings\Engr.Tamir Suliman\Desktop\new.xls';
pic2xls(pic,file,'Sheet1',[0 0 200 200]);

I tried 1 and sheet1 but still didnt work

 

MATLAB Central Terms of Use

NOTICE: Any content you submit to MATLAB Central, including personal information, is not subject to the protections which may be afforded information collected under other sections of The MathWorks, Inc. Web site. You are entirely responsible for all content that you upload, post, e-mail, transmit or otherwise make available via MATLAB Central. The MathWorks does not control the content posted by visitors to MATLAB Central and, does not guarantee the accuracy, integrity, or quality of such content. Under no circumstances will The MathWorks be liable in any way for any content not authored by The MathWorks, or any loss or damage of any kind incurred as a result of the use of any content posted, e-mailed, transmitted or otherwise made available via MATLAB Central. Read the complete Terms prior to use.

Contact us at files@mathworks.com