Read Files From Vector of File Names Matlab No Loop

Introduction of xlsread Matlab

'xls' command is used in Matlab to import and export excel files into Matlab. We tin create the excel files by using this command besides as we tin can read the excel files past using this commands. at that place are two operation in Matlab 1 is to create excel files and other is to read or open excel files. These commands are xlsread and xlswrite. Xlsread command is used to read or open the existing excel files in Matlab. Xlswrite command is used to write or create excel files in Matlab.past using xlswrite command we tin also modify content of existing excel files. This command improves the adaptability of Matlab language past accessing data in other formats.

Syntax:

xlsread (filename)
xlsread (filename, parameters list)
xlsread (filename, [data])
xlsread (filename, sheet proper noun)
xlsread (filename, range for columns or row)

How does xlsread Work in Matlab?

To read any excel file in Matlab first we need to create that file with some information in to it. There are various ways to write and read the excel files. These files can be written by sing parameter list, direct data, past giving sheet proper noun, or by giving a range of the columns or rows.

Steps to read excel file in Matlab –

• Clear workspace
• Declare and assign data
• Write into excel file by using 'xlsread' syntax( xlswrite (filename,[data])
• Declare variable to read a file
• Utilise xlsread read control by using syntax. ( xlsread (filename ) ).

Examples of xlsread Matlab

Following are the examples are given below:

Case #1

In this case, excel file is 'abc.xlsx' and data added to the file is [ thirteen ,42, 53 ]. Then it create one excel file in current directory.

Matlab Editor	Command window
Clc ; xlswrite('abc.xlsx ',[13, 42, 53]) xlsread (' abc.xlsx ')	ans = thirteen    42    53

Output:

Case #2

In this instance input information is alleged past using another variable, which is 'data' (data= [3 four  7 seven;four 3 two 2;four 56 78 32]) . Data is written in 'file1'.

Matlab Editor	Control Window
Clc ; Data = [iii 4  seven vii ; 4 3 2 ii ; iv 56 78 32] xlswrite(' file1.xlsx ', data) xlsread (' file1.xlsx ')	data = 3     4     seven     7 4     3     ii     2 4    56    78    32 ans = 3     iv     7     7 4     3     two     ii four    56    78    32

Output:

Instance #3

In this example input information is declared by using another two variables,  which is 'information' (data1= [3 54  47 ;four 33 22; 56 7 42;43 7 one] and data2=[56 four 2 ; five four two; 67 four 1;1 01 1]. Data is written in 'file2'.

Matlab Editor	Command Window
Clc ; data1= [iii 54  47 ; 4 33 22; 56 vii 42 ; 43 7 one] data2 = [56 4 two ; five iv 2 ; 67 4 1 ; 1 01 1] xlswrite(' file2.xlsx ' , [data1 ; data2]) xlsread(' file2.xlsx ')	data1 = iii    54    47 iv    33    22 56     7    42 43     7     i data2 = 56     4     ii 5     iv     two 67     4     one 1     1     ane ans = 3    54    47 iv    33    22 56     vii    42 43     7     1 56     four     2 5     4     ii 67     4     1 one     1     ane

Output:

Example #four

In this example input data is alleged by using another 2 variables ,  which is 'data' (data1= [3 54  47 ;4 33 22; 56 seven 42;43 seven i]and data2=[56 iv ii ; 5 4 2; 67 4 i;1 01 1]). Information is written in 'file1'.to read the file we use range office. By giving range to the specific file we can brandish only important data.

Matlab Editor	Command Window
Clc ; data1 = [iii 54  47 ;4 33 22; 56 7 42;43 7 one] data2 = [56 4 2 ; 5 4 ii ; 67 iv 1 ; i 01 1] xlswrite('file2.xlsx',[data1 ; data2]) r = ' A3 : B2 ' a = xlsread('file2.xlsx', r )	data1 = 3    54    47 4    33    22 56     7    42 43     7     1 data2 = 56     4     2 5     4     2 67     4     1 i     1     1 r = A3:B2 a = iv    33 56     7

Output:

Example #5

In this case input data is declared by using some other two variables , which is 'data' (data1= [three 54 43 47 ; 4 33 32 22 ; 56 5 7 42 ; 11 23 vii i] and data2 =[56 4 two 4 ;0 5 four 2; 67 1 iv 1;one 01 1 one ]). Data is written in 'file3'.to read the file nosotros utilize range function. By giving range to the specific file we can display simply important data. Here start range value and end range value is same to we can display only specific row or column by using this method.

Matlab Editor	Command Window
clc; data1= [3 54 43 47 ;4 33  32 22; 56 5  vii 42;eleven 23 vii 1] data2=[56 4 2 4 ;0 5 4 2; 67 ane iv 1;1 01  ane ane] xlswrite('file3.xlsx',[data1;data2]) r='C:C' a=xlsread('file3.xlsx',r)	data1 = 3    54    43    47 4    33    32    22 56     5     7    42 11    23     7     1 data2 = 56     four     2     four 0     5     4     two 67     one     iv     1 1     one     1     1 r = C:C a = 43 32 7 7 2 4 iv ane

Output:

Conclusion

We know that nowadays a, most of the data comes in excel format merely, therefore to deal with excel files is piffling difficult. Simply past using Matlab nosotros can easily import and export the data from excel to Matlab or Matlab to excel. We can read the excel data in various ways as per our need and as per application need. Matlab operates on excel data very effectively and efficiently.

Recommended Articles

This is a guide to xlsread Matlab. Here we likewise discuss the introduction and how does xlsread work in matlab? forth with different examples and its code implementation. you may besides accept a look at the following articles to learn more –

1. xlabel Matlab
2. Matlab mesh()
3. Plot Vector Matlab
4. Size Function in MATLAB

hassparmak.blogspot.com

Source: https://www.educba.com/xlsread-matlab/

Share this post