to laod multiple csv files in uitable

2 views (last 30 days)
sarfudeen
sarfudeen on 30 Sep 2014
Answered: sarfudeen on 15 Oct 2014
Hi,
I have 366 nos. of csv files, in each csv files there is of 145 lines. These csv files has to be loaded in uitable.I made it reading the file using fopen and textscan but it takes too much of time to load several csv files.
Kindly please suggest a suitable solution.
Regards, M. Sarfudeen

Answers (1)

sarfudeen
sarfudeen on 15 Oct 2014
I used the following code for reading the multiple csv files but for the execution it takes too much of time.
My code is as follows:
[files,path] = uigetfile('*.csv', 'MultiSelect','on');
FileName = fullfile(path,file);
fmt = '%s%s%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%f%';
num = length(FileName);
data = cell(1,num);
for i = 1 : num
fid = fopen(FileName{i},'r');
data(i) = textscan(fid,fmt,'Delimiter',',',CollectOutput',1);
end
Hence sort out this and help me in this bug at the earliest...
Regards, M. Sarfudeen

Categories

Find more on Data Import and Export in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!