Matrix Conversion between MATLAB and Microsoft Equation Editor
When I was studying my MPhil and PhD degrees, one bothering job was to rewrite the programmed formulas and computational results that were coded with numerical analysis software, MATLAB to my papers and my theses. At that time, I used Microsoft Word as my primary word processing software. Manually typing and formatting the data (in the MS Equation Editor) consume time and easily generate human mistakes. Thus, I developed a couple of functions to convert matrix data between MATLAB and MS Office Equation formats. The MATLAB codes are available in my GitHub repository.
Download [ GitHub ]
The usages are described below.
Convert from MATLAB to MS Office Equation
mat2mseq.m contains the function to convert a numerical matrix in MATLAB to a plain-text formatted MS office equation. The function takes two arguments:
- <m-by-n matrix> A two-dimensional matrix of numbers
- <string> The string format of the numbers (see sprintf)
martixA = [1 0 0; 0 1 0; 0 0 1]; s = mat2mseq(martixA, '%g'); => s = ■(1&0&0@0&1&0@0&0&1)
Copy the text output to an equation object in Microsoft Word, OneNote or PowerPoint.
You will obtain in the MS Equation Editor.
Convert from MS Office Equation to MATLAB
mseq2mat.m contains the function to convert an MS Equation matrix to numerical data in MATLAB. The function requires the following argument:
- <string> a matrix in the MS office equation (in plain-text format)
For example, when you copy from MS Word and paste it to MATLAB. The matrix will be displayed in the plain-text format of MS Equation, like
■(1&0&0@0&1&0@0&0&1) in the command line. Convert it to numerical data by evaluating the text with the function, as the example below:
A = mseq2mat('■(1&0&0@0&1&0@0&0&1)') => A = [ 1 0 0 ; 0 1 0 ; 0 0 1 ]
To develop your MATH translator, you can read the documentation “UTN #28: Nearly Plain-Text Encoding of Mathematics“ to explore how Microsoft uses Unicodes in encoding mathematical expressions. If you want to learn about the shortcut commands of MS Equation Editor, this PDF Note from Michigan Technological University should be helpful.
Do you use any great tools when writing your reports and essays? Have a question or suggestion? Let us know in the comments below.
- [Working MATLAB with MS Excel]/blog/matlab/Working-MATLAB-with-MS-Excel
- Expand shorten URLs in MATLAB