Dr. Dobbs’ Howto: Interface Matlab to Excel (so you can format pretty looking tables for your lab reports) Matlab is an ideal tool for making great looking plots, charts, and graphs easily. It is not well suited to making nicely formatted tables. Since you will need nicely formatted tables to make your lab reports look professional, here are some tips for sending information back and forth from matlab to Microsoft Excel. 1.Open Microsoft Excel (Start ÆAll Programs ÆMicrosoft Office ÆMicrosoft Excel). 2.If you want to, you can enter your data directly in excel. In this example I have entered data that counts from 21 to 40 in cells r1c1:r20c1 (think of this notation as being row 1, column 1 to row 20, column 1). I have saved my file as “matlabtest.xls” 3.Notice the formatting of cell addresses about (r1c1:r20c1). Some people have excel setup to label the columns with letters A,B,C,… and rows with numbers 1,2,3,… If this is the case for you, the cells would be names A1:A20. Matlab does
This preview has intentionally blurred sections.
Sign up to view the full version.