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);

It should be OK.

Is A a matrix ?

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;