How to read 1st coloumn from excel sheet which contains 60x3 values.
Mostrar comentarios más antiguos
I have an excel sheet which contains 60x3 values I want to read the entire first column and display it.. can somebody help me with the code
1 comentario
Ace_ventura
el 28 de Mzo. de 2015
data=xlsread('filename.xlsx');
column1=data(:,1)
Respuestas (1)
per isakson
el 28 de Mzo. de 2015
Editada: per isakson
el 28 de Mzo. de 2015
Read the second column from the Excel file in the first example.
filename = 'myExample.xlsx';
columnB = xlsread(filename,'B:B')
Thus, why not first try
columnA = xlsread(filespec,'A:A')
and next
columnA = xlsread(filespec,sheet_name,'A:A')
Is Excel installed on your system?
2 comentarios
krishnasri
el 28 de Mzo. de 2015
Editada: per isakson
el 28 de Mzo. de 2015
per isakson
el 28 de Mzo. de 2015
Editada: per isakson
el 28 de Mzo. de 2015
"in the same manner"   No, you did not!
Concentrate on the reading problem first. Don't involve calculations and writing. It's just confusing.
Given
- The name of the file is 'A_ed.xls'.
- The workbook has one sheet or the data is in the first sheet
Am I correct? If so try
data = xlsread( 'A_ed.xls', 'A:A' );
and inspect the content of the variable data
plot( data )
Categorías
Más información sobre Spreadsheets en Centro de ayuda y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!