MATLAB: Can I use the SpreadSheet Link with OpenOffice Calc in MATLAB 7.6 (R2008a)

excelfreelinklinuxofficeopenopenofficesheetsourcespreadSpreadsheet Link

I would like to be able to use the SpreadSheet Link Ex with MATLAB 7.6 (R2008a) to communicate to and from my OpenOffice Calc application.

Best Answer

The ability to interface MATLAB 7.6 (R2008a) with OpenOffice Calc is not available with SpreadSheet Link EX.

As a workaround, consider using XLSREAD and XLSWRITE functions to import/export data to/from XLS files on a Linux machine. Please note that these functions will only function in basic mode on a non-Windows machine.

To learn more about XLSREAD and XLSWRITE, please refer to the following links:

https://www.mathworks.com/help/matlab/ref/xlsread.html

https://www.mathworks.com/help/matlab/ref/xlswrite.html

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

You can rename an Excel sheet using the "Name" property of a sheet object. For example the following renames the first sheet of an Excel file:

filename = 'C:\SomeExcelFile.xls';
% Open Excel Automation server
Excel = actxserver('Excel.Application');
% Make Excel visible
Excel.Visible=1;
% Open Excel file
Workbook = Excel.Workbooks.Open(filename);
% Get the list of sheets in the workbook
Sheets = Excel.ActiveWorkbook.Sheets;
% Rename the first sheet
Sheets.Item(1).Name = 'This is sheet 1';

The following code then saves the Workbook, quits Excel and removes the COM server:

% Save the file
Workbook.Save();
% Quit Excel, remove the COM server and delete the related objects
Excel.Quit();
Excel.delete();
clear Excel;
clear Workbook;
clear Sheets;

MATLAB: Moving excel sheets within excel file

I think you'll have to use ActiveX to copy the sheet, then delete the sheet, then insert a new sheet with the desired sheet number. Search this forum for ActiveX.

Best Answer

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

MATLAB: Moving excel sheets within excel file

Related Question