OpenOffice Calc

Question

Naftali Herscovici 2011-3-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/3069-openoffice-calc

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 2011-3-12

Please clarify the connection between your question and Matlab ?

Naftali Herscovici 2011-3-13

编辑：Walter Roberson 2013-5-22

在 MATLAB Online 中打开

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

请先登录，再进行评论。

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

Answer 1

Kaustubha Govind 2011-3-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/3069-openoffice-calc#answer_4686

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).