Info

This question is closed. Reopen it to edit or answer.

How do I read text paragraphs from Excel files?

1 view (last 30 days)
Leon
Leon on 16 Oct 2014
Closed: MATLAB Answer Bot on 20 Aug 2021
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
dpb
dpb on 16 Oct 2014
Doesn't
[~,txt]=xlsread(yourxlsfile);
return all text?
Leon
Leon on 16 Oct 2014
Yes, it does. Thank you very much.

Answers (0)

This question is closed.

Tags

Community Treasure Hunt

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

Start Hunting!