Reading Microsoft word & Excel files

Can I read and open word & Excel files in matlab? In other words, Is this possible to read like this files in matlab ? If it's possible how can I converts it to a matrix of decimal numbers and then to binary form, thank all ,my best wishes.

Answer 1

[Walter Roberson]

Using ActiveX; or Using Open Office to read Microsoft Word:

https://www.mathworks.com/matlabcentral/answers/152150-how-to-read-ms-word-file-in-matlab#answer_149698

Using Text Analytics Toolbox to read Microsoft Word:

https://www.mathworks.com/help/textanalytics/ref/extractfiletext.html

To read Excel files, you have several possibilities:

• you can use readtable() or readmatrix() or readcell()
• you can use xlsread()
• you can use activeX to talk to Excel (MS Windows with Excel installed only)

[Mostafa Taleb]

Sir I don't care about editing the content of the Word or Excel files or opening it in matlab, I just wanna to read it in matlab and then I deal with it as a matrix of numbers and then convert to binary , I really appreciate your reply,your help and I am sorry if I took your time .

[Walter Roberson]

I am not aware of any MATLAB routine for reading numbers from Microsoft Word without reading the file as text and then converting the text.

The information I linked to above is all about reading from files, and not about writing to files.

If you have a character vector that is just numeric and delimiters then textscan() or sscanf() can be used to read the numbers from it.

[Mostafa Taleb]

Sir what about the notebook command ? notebook; notebook('file name'); notebook('-setup'); When I write these commands above ,results an error in notebook('-setup'), thank you very much, your help really works.

[Walter Roberson]

notebook() has been removed from MATLAB. I never used it myself so I do not know what it was able to do.