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 Comments

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

Answers (0)

This question is closed.

Tags

Asked:

on 16 Oct 2014

Closed:

on 20 Aug 2021

Community Treasure Hunt

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

Start Hunting!