Excel to Text Conversion

11 次查看（过去 30 天）
Amanda
Amanda 2012-8-20
回答： Fabio Alonso Da Silva 2018-1-11
I can convert the excel file to text manually inside of Excel.
However, to make my MATLAB scripts more autonomous and not relying on
another application, I am struggling with converting a .xlsx file to
text inside of MATLAB. Is there a function or routine to convert a
.xlsx file to .txt?
Thanks,
Amanda
  1 个评论
Akki
Akki 2014-9-23
Is it possible to convert all sheets of a single excel file using single xlsread command?

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

José-Luis
José-Luis 2012-8-20
编辑：José-Luis 2014-9-23
The easy way:
Import to matlab using
[numData textData rawData] = xlsread('myFile.xlsx'), %doc xlsread for more details
and then save to text
save('pqfile.txt', 'rawData', '-ASCII'); %replace rawData with the actual data you are actually interested in.
Cheers

更多回答（1 个）

Fabio Alonso Da Silva
It depends ( people do not like this statement in general), but to do a 'xlsread' and a 'save' right after, have in mind that MATLAB will use memory to do so, possibly creating a cell array. Therefore depending on the size of your file, this can become a memory constraint. Another option is to manually save the MATLAB file as text and then read line by line inside MATLAB so you can direct (or control how) each piece of data goes where. It is a way to get rid of empty spaces creating an useless cell, for instance. Depending also on the size of the generated txt file, you might want to create a way to search and load just the pieces of data of interest into your application, this saves memory, but then increases disk access. There is no free lunch.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by