%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.

 Réponse acceptée

Azzi Abdelmalek
Azzi Abdelmalek le 2 Fév 2014
Modifié(e) : Azzi Abdelmalek le 2 Fév 2014

0 votes

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

5 commentaires

sermet
sermet le 2 Fév 2014
I need to read txt file not xlsx file.
Azzi Abdelmalek
Azzi Abdelmalek le 2 Fév 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 le 2 Fév 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 le 2 Fév 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))

Connectez-vous pour commenter.

Plus de réponses (1)

mohamad  basma
mohamad basma le 11 Mai 2016

0 votes

[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?

Catégories

En savoir plus sur Large Files and Big Data dans Centre d'aide et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by