Excel to Text Conversion

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

[Akki]

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

Answer 1

[José-Luis]

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

[Amanda]

Thanks a lot.

[José-Luis]

No worries.

Answer 2

[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.