Write cells to individual excel sheets

Hi, I'm having problems writting individual cells to individual sheets in excel. It states an invalid data range. I need to add the cell IDs above the orginal data.

Attached is the code for xlswrite.

Thanks

Load('Sample_data.mat');
Fnane = 'PD.xlsx';

%add cell ID above PD data for each cell.
for n = 1:numel(Sheet_names)
PD_adpt{n}(2,:) = PD_adpt{n}(1,:);
PD_adpt{n}(1,:) = Cell_ID;
end

for ii = 1:numel(PD_adpt)    
    xlswrite(Fnane,PD_adpt{ii},'sheet',sheet_names(ii))
end

[Voss]

What happens if you call xlswrite like this?:

xlswrite(Fnane,PD_adpt{ii},sheet_names{ii});

[Richard Rees]

Hey, I get worksheeet could not be activated

[Richard Rees]

I just had a tinker again. If I use writecell it will work.

Thanks both for your replies

for ii = 1:numel(PD_adpt)    
    writecell(PD_adpt{ii},Fname,'Sheet',Sheet_names(ii))
end

Answer 1

[Dave B]

I think with xlswrite you specify just the sheet, no need to use the keyword 'sheet'

xlswrite(Fnane, PD_adpt{ii}, sheet_names(ii))

But in general you might have a better time if you use writematrix/writecell/writetable instead of xlswrite