Clear Filters
Clear Filters

how to write xls file

7 views (last 30 days)
rafi abdul
rafi abdul on 4 Mar 2013
Hi i want to write xls file using the below code i am able to write numeric data.i want to write header also.please guide how to proceed
data=get(handles.uitable1,'data');
checkbox1State = get(handles.af1, 'Value');
checkbox2State = get(handles.af2, 'Value');
checkbox3State = get(handles.af3, 'Value');
if checkbox1State
header={'first'}
p=data(start_pt:end_pt,1);
xlswrite('af1.xls',p,1,'A2');
end
if checkbox2State
header={'second'}
p=data(start_pt:end_pt,2);
xlswrite('af1.xls',p,1,'B2')
end
if checkbox3State
header={'third'}
p=data(start_pt:end_pt,3);
xlswrite('af1.xls',p,1,'C2')
end

Accepted Answer

Azzi Abdelmalek
Azzi Abdelmalek on 4 Mar 2013
Edited: Azzi Abdelmalek on 4 Mar 2013
x=[1;2;3]; % first column
y=[10;20;30] ;% second column
header={'x','y'}
M=[header ; num2cell([x y])]
xlswrite('filname.xls',M)
  5 Comments
rafi abdul
rafi abdul on 6 Mar 2013
thanks it is working
rafi abdul
rafi abdul on 8 Mar 2013
hi aziz i am trying to write xls file using above code but am able to write upto 50000 rows only.i have 130000 rows how to proceed.

Sign in to comment.

More Answers (0)

Categories

Find more on Migrate GUIDE Apps in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!