Discover MakerZone

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn more

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today

Thread Subject:
writing data actserver

Subject: writing data actserver

From: wahyoe Unggul

Date: 6 May, 2011 16:36:05

Message: 1 of 1

hi all
I have a problem writing data actserver xls

Excel = actxserver('Excel.Application');
ExcelWorkbook = Excel.workbooks.Add;
ExcelWorkbook.SaveAs(comb1.xls);
invoke(Excel.Workbooks,'Open',comb1.xls);
% Create some sample data.
myData = magic(20);
myOtherData = rand(10);
xlswrite1(comb1.xls, myData, 'mySheetName', 'B2');
ca = {'Column Header 1', 'Column Header 2'};
xlswrite1(comb1.xls, ca, 'mySheetName', 'B1');
ca = {'Row Header 1'; 'Row Header 2'};
xlswrite1(comb1.xls, ca, 'mySheetName', 'A2');
xlswrite1(comb1.xls, myOtherData, 'myOtherSheetName', 'B2');
DeleteEmptyExcelSheets(Excel);
% Then run the following code to close the activex server:
invoke(Excel.ActiveWorkbook,'Save');
Excel.Quit;
Excel.delete;
clear Excel;
??? Error: The object invoked has disconnected from its clients.

Error in ==> tes2 at 315
invoke(ExcelWorkbook,'Open',comb1.xls)

Tags for this Thread

No tags are associated with this thread.

What are tags?

A tag is like a keyword or category label associated with each thread. Tags make it easier for you to find threads of interest.

Anyone can tag a thread. Tags are public and visible to everyone.

Contact us