I have the EEG signal data set in .mat (matlab) format I want to write it into excel format. how can I do?
Hi,
Have you tryed xlswrite ?
xlswrite(filename,A,sheet,xlRange)
Regards,
Alain
I wrote this Command:
A= load('C:\c1_edfm');
xlswrite('C:\c1.xlsx',A);
My method is to save your data as a text file (.txt) and then import it into Excel.
hi Alain thanks, ya A is Matrix, but it doesnt work shows error
----
Hi Elizabeth, can you suggest me how do save data to txt file.
I think you can save data directly in Excel :
file_name='result';
myarray=rand(12,4);
xlswrite(file_name,myarray);
If you have some string in data :
do not forget to wrtite them with brackets :
mydata={'hello','world'}
xlswrite(file_name,mydata,'A1:A2');
Hi Alain, as the data size was big; columns are 1000000 excel cannot write so I wrote it into .dat using , dlmwrite.
is there any way to load data into excel; xlxwrite shows error.
Mohammad - How many rows do you have? If you have less than 256, you could switch your rows and columns before you write to excel.
As for writing to a text file, here is a sample:
%% Initialize the data file
fileName = 'file.txt';
pathName = 'C:\...';
fileID = fopen(pathName, 'wt');
%% Write an example matrix A of doubles to file
[len,wid]=size(A)
for i=1:len
for j =1:wid
tempVal = A(i,j);
fprintf(fileID, '3.3g\t', tempVal);
end
end
%Close file
fclose all;
- Badges
- Science topic
- Similar topics
- Linguistics
- Composition Studies
- Writing