Excel importing files into MATLAB

Importing Excel and Other Data Files into MATLAB 445... 

Use MATLAB to solve Example 7.1. Recall that we applied the trapezoidal rule to determine the area of the shape given. Create an Excel file with the given data, and then import the file into MATLAB. 

The last step is to push the Finish button, whereby the variables (i.e., vectors) are created. In addition, an M-file is created that summarizes the entire process of data importing from, say. Excel into the MATLAB environment. Figure 5.4 shows MATLAB s Workspace window where the variables are created into MATLAB s environment holding the same name as those of the columns. 

To demonstrate how to import data from another application into the MATLAB environment, let us assume that the experimental data exist in a file sheet such as Excel. The data represent the yearly incoming surface erythemal solar UV radiation dosage (J per cm ) for a clear sky, after modulation due to average cloud cover, as a function of earth latitude. The data were excerpted from M. Ilyas [Climate augmentation of er5 hemal UV-B radiation dose damage in the tropics and global change, Curr. Sci. 93(11) 1604-1608, 2007]. For simplicity, the file was copied to, or moved into, one of the MATLAB search path directories so that it will appear in the Current Folder Window of MATLAB (Fig. 5.1). 

---