how can i add my result to sheet 2 in my excel sheet

I have written a script which reads data from an excel file (sheet1) and then I perform some tasks. I want to add my resulted sheet in that excel file but in sheet 2. I am using actxserver for this.

Answer 1

[Meghana Dinesh]

Use the syntax:

xlswrite(filename,A,sheet)

[Praveen Choudhury]

I am not using xlswrite. Rather I am using actxserver. I want to add my result to sheet 2 using actxserver.

Below shows how I am doing it

h = actxserver('excel.application');

%Create a new work book (excel file)

wb=h.WorkBooks.Add();