MATLAB _01_ Operations Excel

1. %matlab coder
2. h=actxcontrolselect
3. [h,info]=actxcontrolselect
4. %h返回的是一个句柄
5. %info 是一个1行3列的元胞数组，分别对应各空间的名称、程序标识符和空间所在的路径

COM functions can only be used in instances under the Microsoft Windows operating system: use MATLAB to manipulate Excel table 1, create a COM server to run Microsoft Excel:

2. e=actxserver(‘Excel.Application‘);
4. %使得excel框架窗口可见
6. e.visible=1;
8. % use the Get method of the Excel object E to list all properties of the app
10. E.get
12. % Create a "eworkbooks" interface:
14. Eworkbooks=e.workbooks
16. % Add a new workbook
18. Eworkbooks.invoke% can list method methods
20. W=eworkbooks.add% Create a new workbook, and add another interface:
22. % can also use W to create new worksheet (table key to list functions)
24. % close Excel, and delete objects
26. E.quit:
28. E.delete:

From for notes (Wiz)

PS: Blog editor can not insert MATLAB code, so the impact of the quality of reading, please forgive me!

MATLAB _01_ Operations Excel