MATLAB: Write operation using Activexserver command

writing to excel using activexserver

I have 4 array, a = [1 2 3] b=[4 5 6] c=[8 9 10], text=[num1 num2 num3]

I need to write to excel sheet where a in sheet1, b in sheet2, c in sheet3 and i also should have header for three sheet as it is mentioned in text?

How can I do this?

Thanks a lot

Best Answer

ws = wb.Worksheets.Item('sheetname');

Insert this before you put something in the sheet, that way it will in what sheet to put it. 'sheetname' is the name of the sheet you are trying to change, you can get these sheets with the xlsinfo command (or do it manually).

Related Solutions

MATLAB: Avoid overwriting value of variable

Use indexing:

Source_files = [specified directory]
N = numel(Source_files);
C = cell(1,N);
for k = 1:N
    [status,sheets] = xlsfinfo(Source_files{k});
    C{k} = find(strncmp(sheets, '#', 1));
end

MATLAB: How to change Sheet Focus within Excel using an activex component in MATLAB 7.10 (R2010a)

Given a handle to the activex component created in guide that interacts with Excel, the following code can be used to change focus from one sheet to another:

sheet(1) = get(get(handles.activex1, 'Sheets'), 'Item',1);
sheet(2) = get(get(handles.activex1, 'Sheets'), 'Item',2);
Select(sheet(2)); %Example of selecting sheet 2

This can also be achieved using MATLAB as an ActiveXServer:

H = actxserver('Excel.Application');
H.Visible = 1;
Workbook = invoke(H.Workbooks,'Add');
w1 = get(H.Sheets,'Item',1); % first sheet
w2 = get(H.Sheets,'Item',2); % second sheet
w2.Select; %Example of selecting sheet 2

Best Answer

Related Solutions

MATLAB: Avoid overwriting value of variable

MATLAB: How to change Sheet Focus within Excel using an activex component in MATLAB 7.10 (R2010a)

Related Question