MATLAB: Reading cells extension wise in matlab.

extensionsimporting excel data

how to read the excel cells according to extension wise and how to count them? Foe an example, if I have this column

q.txt
w.txt
e.txt
r.exe
t.exe
and I want to count the number of txt file names as well as number of exe file names in the sheet. How to do so?

Best Answer

A={'q.txt';'w.txt';'e.txt';'r.exe';'t.exe';'k.xls';'m.xls'}
% xls files
out_xls=A(cellfun(@(x) ~isempty(strfind(x,'.xls')),A))
% Number of txt file
nuber_txt=sum(cellfun(@(x) ~isempty(strfind(x,'.txt')),A))

Related Solutions

MATLAB: Using xlsread for cell variable

I don't quite understand the question, but I'll take a guess. You can use csvread() to read in your data file, and xlswrite() to write it out to an Excel workbook. Does that answer the question?

MATLAB: From excel link to time table

First note that urlread has been deprecated for a while. Its replacement is webread which is more powerful.

webread would have been able to import the data from the url directly as a table if not for the file that it has a misleading xls extension. The file is not an excel file, it's a plain text file and unfortunately webread attempts to decode it as an excel file and so fails. I could not find a way to override that.

So a workaround is to use websave to save the file locally, then import it with readtimetable:

url = 'https://app2.msci.com/eqb/currency/performance/90463.48.all.xls';  %Despite the xls extension, the file at that URL is a plain text file!
tempfile = [tempname(), '.txt']; %ask matlab for a temporary filename. Give it a txt extension so readtimetable decodes it as text
websave(tempfile, url);
msci_em_currency = readtimetable(tempfile);
delete(tempfile);  %delete temporary file. No longer needed.

Best Answer

Related Solutions

MATLAB: Using xlsread for cell variable

MATLAB: From excel link to time table

Related Question