MATLAB: Does MATLAB 7.4 (R2007a) no longer prompt me to update the Excel cells when using XLSREAD

MATLAB

I use XLSREAD on an Excel file with formulae and links. Older versions of MATLAB used to prompt me whether I want to update the cells in my file. MATLAB 7.4 (R2007a) does not.

In R2007a, the side effect of this is that Excel automatically tries to update the links and some columns then contain #N/A – even the valid data in these columns is not read in.

Best Answer

The ability to choose whether to update the cells when using XLSREAD is not available in MATLAB 7.4 (R2007a).

To work around this in MATLAB 7.4 (R2007a):

1. Go to $MATLABROOT\toolbox\matlab\iofun\

2. Create a copy of the xlsread.m file and name the copy to xlsread.m.old

3. Open xlsread.m in MATLAB using the command:

edit xlsread

4. On line 261, change:

Excel.AskToUpdateLinks = 0;

Excel.AskToUpdateLinks = 1;

5. Run: rehash toolboxcache

This should re-enable the prompt to update the cells.

Related Solutions

MATLAB: How to add a Header or a Footer to an EXCEL worksheet using MATLAB 7.7 (R2008b)

The ability to programmatically add the Header and Footer to an Excel worksheet can be implemented in MATLAB using the COM interface.

The ACTXSERVER command can be used to create a COM server running Microsoft Excel. You can then add the Header and Footer using the different methods for the workbook and then call XLSWRITE to write the data to the Excel worksheet as follows:

a = actxserver('Excel.Application');
a.Visible =1;
a.Workbooks.Add;
a.activeWorkbook.activesheet.PageSetup.LeftFooter = 'MyFooter';
a.activeWorkbook.activesheet.PageSetup.LeftHeader = 'MyHeader';
a.activeWorkbook.SaveAs('test.xlsx');
a.activeWorkbook.Close;
xlswrite('test.xlsx',[1 2 3]);

The following options can also be modified in a similar way:

a.activeWorkbook.activeWorksheet.PageSetup.CenterHeader 
a.activeWorkbook.activeWorksheet.PageSetup.RightHeader 
a.activeWorkbook.activeWorksheet.PageSetup.CenterFooter 
a.activeWorkbook.activeWorksheet.PageSetup.RightFooter

MATLAB: Do callback properties disappear from the Property Inspector when I open a GUI created in GUIDE in MATLAB 7.6 (R2008a) in MATLAB 7.4 (R2007a)

Due to the backwards compatibility issues between MATLAB 7.6 (R2008a) and MATLAB 7.4 (R2007a), it is not possible to see the callbacks in the Property Inspector for the GUI created in MATLAB 7.6 (R2008a) and then viewed in MATLAB 7.4 (R2007a). You can, however, access the Callbacks for your uicontrols in MATLAB7.4 (R2007a) if you right-click on a UICONTROL in GUIDE and select View Callbacks->Callback.

Best Answer

Related Solutions

MATLAB: How to add a Header or a Footer to an EXCEL worksheet using MATLAB 7.7 (R2008b)

MATLAB: Do callback properties disappear from the Property Inspector when I open a GUI created in GUIDE in MATLAB 7.6 (R2008a) in MATLAB 7.4 (R2007a)

Related Question