Question

i want to make a matlab program that uses this information

EDIT Documents C M IN Folder Name examenfina examenfina pipe xlsx SELECTION : Users bryan ▸ OneDrive Editor - examenfinalform pipes X 15x2 double 2.1400 2.3200 - 3 2 2.1000 2.2500 2.3000 2.3500 2.1100 2.1500 2.2100 2.1500 2.8600 2.9000 2.5500 10.3000 10.5000 10.3500 10.2000 10.2500 10.4500 10.2000 11 10.2200 10.2500 10.3500 10 10.1000 10.2000 10.2000 Command Window

the information on the first column is w and the information on the second column is l how do i make matlab read the information on the second column?

this is what i have so far ive already gotten matlab to read whats on the first columb bur i dont know how to make it read whats on the second column

$folder Name examenfina C: Users bryan OneDrive Documents Matlab Final Test Editor - C:\Users bryan OneDrive Documents MaTLab$

can you help me?thank you!

Answer 1

Source code with comment

pipe=xlsread('c:\pipe.xlsx','Batch1','A1:B15')
prompt='What colum do you want to print:';
x=input(prompt)% read a particular column number from console input
c=pipe(:,x)% Print the particular column values
'Full sheet details'
pipe % Full sheet

Source code without comment, Run the code, if you file curly red line after code, clear the read curly line and run it.

you may find red curly line after last line word 'pipe', please erase it and run it. code is working.

pipe=xlsread('c:\pipe.xlsx','Batch1','A1:B15')
prompt='What colum do you want to print:';
x=input(prompt)
c=pipe(:,x)
'Full sheet details'
pipe

/* Explanation */

Here pipe.xlsx file is kept at C drive. So, the file path is given as xlsread('c:\pipe.xlsx','Batch1','A1:B15').

If you put your excel file at MATLAB folder then no need to give the path, then only give the file name as

xlsread('pipe.xlsx','Batch1','A1:B15'). As here only the second column is required, but this source code is completely customized, means you can fetch details of any column and full full excel sheet also.

Here if you take x=2, it will give the detail values of second column.

Here value range from A1 to B15. Depending on columns, the range will be changed with respect to corresponding column heading alphabets.

*NOTE:After copying the code on matlab, curly red line can be shown at comment section, please clear all those comments and run the code.The comments are given to make clear about individual commands of matlab

Output: Here I tried to show the partial look of the output, after running code the full output will be shown like the given below.

Command Window What colum do you want to print:2 x = ans Second column value is 10.3000 10.5000 10.3500 10.2000 10.2500 10.4500 10.2000 11.0000 10.2200 10.2500 10.3500