How do I read text paragraphs from Excel files?

I normally read text strings from Excel files by first converting the file into a CSV or TXT, and then use fopen, textscan, and fclose.
However, now I have a bunch of Excel files whose cells could contain delimiters such as commas or Tabs, making it really hard to first convert the file to CSV, or TXT and use "textscan" to read them.
Any ideas I can directly read strings from Excel cells. When I say strings, I mean paragraphs.

2 commentaires

Doesn't
[~,txt]=xlsread(yourxlsfile);
return all text?
Leon
Leon le 16 Oct 2014
Yes, it does. Thank you very much.

Réponses (0)

Cette question est clôturée.

Tags

Question posée :

le 16 Oct 2014

Clôturé :

le 20 Août 2021

Community Treasure Hunt

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

Start Hunting!

Translated by