%I retrieve data from excel like that,
[FileName1,PathName] = uigetfile('*.xlsx','Select the excel file')
[num,txt1,raw] = xlsread(FileName1)
%I have a .txt file which I need to extract data from it so I need to apply this way to retrieve data from a .txt file. How can I do that.

 Akzeptierte Antwort

Azzi Abdelmalek
Azzi Abdelmalek am 2 Feb. 2014
Bearbeitet: Azzi Abdelmalek am 2 Feb. 2014

0 Stimmen

[FileName1,PathName] = uigetfile('*.xlsx','Select the excel file')
[num,txt1,raw] = xlsread(fullfile(PathName,FileName1))
For a text file you cane use importdata

5 Kommentare

sermet
sermet am 2 Feb. 2014
I need to read txt file not xlsx file.
Azzi Abdelmalek
Azzi Abdelmalek am 2 Feb. 2014
For txt file, you need to know the format of your data in your txt file. Can you post a sample of your data?
sermet
sermet am 2 Feb. 2014
points_id x y z
A 100 150 200
B 200 300 400
..
..
I want that users can choose the txt file and retrieve data from it like in my above example (xlsread)
sermet
sermet am 2 Feb. 2014
I need to classify num, txt1, raw like above example
fid=fopen('file.txt')
a=textscan(fid,'%s %f %f %f','headerlines',2)
fclose(fid)
text1=a{1}
num=cell2mat(a(2:4))

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (1)

mohamad  basma
mohamad basma am 11 Mai 2016

0 Stimmen

[FileName1,PathName] = uigetfile('*.xlsx','Select the excel file') [num,txt1,raw] = xlsread(fullfile(PathName,FileName1))
How can i get the data in a matrix from this function?

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by