Info

Cette question est clôturée. Rouvrir pour modifier ou répondre.

How do I read text paragraphs from Excel files?

1 vue (au cours des 30 derniers jours)
Leon
Leon le 16 Oct 2014
Clôturé : MATLAB Answer Bot le 20 Août 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 commentaires
dpb
dpb le 16 Oct 2014
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

Community Treasure Hunt

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

Start Hunting!

Translated by