How to Upload .dat File to Matlab

Introduction of xlsread Matlab

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

Syntax:

xlsread (filename)
xlsread (filename, parameters list)
xlsread (filename, [data])
xlsread (filename, canvass name)
xlsread (filename, range for columns or row)

How does xlsread Work in Matlab?

To read any excel file in Matlab starting time we need to create that file with some data in to it. In that location are various ways to write and read the excel files. These files tin can exist written by sing parameter list, direct data, by giving sheet name, or past 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 past using 'xlsread' syntax( xlswrite (filename,[information])
• Declare variable to read a file
• Use xlsread read control past using syntax. ( xlsread (filename ) ).

Examples of xlsread Matlab

Following are the examples are given below:

Example #i

In this example, 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 ',[xiii, 42, 53]) xlsread (' abc.xlsx ')	ans = 13    42    53

Output:

Example #2

In this example input data is declared by using another variable, which is 'data' (data= [3 4  vii vii;4 3 2 2;4 56 78 32]) . Data is written in 'file1'.

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

Output:

Example #three

In this example input data is declared past using another two variables,  which is 'data' (data1= [3 54  47 ;4 33 22; 56 7 42;43 7 1] and data2=[56 4 2 ; 5 4 2; 67 4 1;ane 01 ane]. Data is written in 'file2'.

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

Output:

Example #4

In this example input data is declared past using some other two variables ,  which is 'data' (data1= [3 54  47 ;four 33 22; 56 vii 42;43 vii 1]and data2=[56 four two ; 5 4 2; 67 4 1;1 01 1]). Data is written in 'file1'.to read the file we use range office. By giving range to the specific file nosotros can display only important information.

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

Output:

Example #5

In this example input information is alleged past using another two variables , which is 'data' (data1= [3 54 43 47 ; 4 33 32 22 ; 56 5 7 42 ; 11 23 seven 1] and data2 =[56 four 2 iv ;0 five 4 2; 67 1 4 one;one 01 1 1 ]). Data is written in 'file3'.to read the file we use range function. By giving range to the specific file we can display only important data. Here start range value and end range value is same to we can brandish only specific row or column by using this method.

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

Output:

Conclusion

Nosotros know that nowadays a, about of the data comes in excel format merely, therefore to deal with excel files is little difficult. But past using Matlab we can easily import and export the data from excel to Matlab or Matlab to excel. We tin read the excel data in various ways as per our need and as per application need. Matlab operates on excel data very finer and efficiently.

Recommended Articles

This is a guide to xlsread Matlab. Here we also discuss the introduction and how does xlsread work in matlab? along with different examples and its lawmaking implementation. you may too have a wait at the following manufactures to learn more than –

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

rodriguezterful.blogspot.com

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

Share this post