OpenOffice Calc

2011 3 12
1 个回答
4 次查看（30 天）

0 个投票

Hello, I simply can't afford Microsoft Office. Is there any documentation on OpenOffice.org Calc? For starters I just want to open an OpenOffice.org Calc new file write in a cell and close it. Obviously,I'd like to do more, but I could not find ANY documentation. So for starters, it's enough. Hopefully I can take it from there.
Thank you
Tuli

2 个评论
显示 无 隐藏 无

Walter Roberson
Walter Roberson 2011-3-12
Please clarify the connection between your question and Matlab ?
Naftali Herscovici
Naftali Herscovici 2011-3-13
编辑：Walter Roberson 2013-5-22
what is the variation of the code below for OpenOffice Calc?
% 20110223 Tuli make excel INVISIBLE
% OPEN EXCEL APPLICATION
h = actxserver('Excel.Application');
% Show the Excel window
% set(h, 'Visible', 1); Tuli
set(h, 'Visible', 0);
% INSERT NEW WORKBOOK
W = h.Workbooks.Add;
% WORKBOOKS CONTAIN WORKSHEETS
Sheets = h.ActiveWorkBook.Sheets;
% Add a fourth sheet (by default, a workbook contains
% three worksheets - add a new one before [], after #3)
Sheets.Add( [], Sheets.Item(3) )
% Rename
Sheets.Item(1).Name = 'History Long';
Sheets.Item(2).Name = 'History Short';
% Set active sheet #1
Sheets.Item(1).Activate;
ActiveSheet = h.Activesheet

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Kaustubha Govind
Kaustubha Govind 2011-3-13

0 个投票

If you are asking about interfacing MATLAB with OpenOffice, you can use the OpenOffice API. There is documentation on interfacing MATLAB with both C++ and Java applications (both languages are supported in the OpenOffice API).

类别

在 帮助中心 和 File Exchange 中查找有关 Use COM Objects in MATLAB 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by