Excel to Text Conversion

Question

Amanda 2012-8-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/46353-excel-to-text-conversion

回答： Fabio Alonso Da Silva 2018-1-11

采纳的回答： José-Luis

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

Akki 2014-9-23

Is it possible to convert all sheets of a single excel file using single xlsread command?

请先登录，再进行评论。

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

Answer 1

José-Luis 2012-8-20

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/46353-excel-to-text-conversion#answer_56713

编辑：José-Luis 2014-9-23

在 MATLAB Online 中打开

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

2 个评论
显示无隐藏无

Amanda 2012-8-20

Thanks a lot.

José-Luis 2012-8-20

No worries.

请先登录，再进行评论。

Answer 2

Fabio Alonso Da Silva 2018-1-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/46353-excel-to-text-conversion#answer_299717

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.