MATLAB: How to avoid third party Excel Add-in update pop-up opening each time I call xlsread?

MATLABpop-upxlsread

Every time I open Excel process, I get a pop-up about a third part excel add-in update.

I have some excel files and I am trying to read them in MATLAB using xlsread.

Every time I call xlsread, I am getting the same pop-up.

Is there a way to disable this?

Best Answer

This happens because xlsread calls Excel process and eventually excel process will throw this pop-up.

One workaround would be to use the basic import mode to read from spreadsheet.

num = xlsread(filename,sheet,xlRange,'basic')

You don't need excel process to read data from spreadsheet in basic mode.

If you do not specify all the arguments, use empty character vectors, '' , as placeholders, for example, num = xlsread(filename,'','','basic').

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: How to use activex to copy an Excel spreadsheet within the same workbook

The underlying API behind "actxserver" is Microsoft's COM interface. MATLAB simply leverages the COM interface to make calls using Microsoft's APIs. For questions on using the COM interface and syntax please consult Microsoft Documentation and Microsoft Technical Support if necessary.

For copying sheets, please refer to the following documentation page.

https://docs.microsoft.com/en-us/office/vba/api/excel.worksheet.copy

Using this, you can use the Example script attached. The crux of the example is at:

a = e.ActiveSheet;
invoke(a,'Copy',[], a)
e.ActiveSheet.Name = "gsData_01";

The first step is to get the active sheet, which in this case is the sheet to be copied.

Next we use the "invoke" function to call the sheet copy method documented in the link above. We are using the optional argument "After" (as noted in the documentation) with the active sheet again in order to place the new sheet after the copied sheet.

Finally, the newly copied sheet is set as the active sheet and thus we can rename it by renaming the ActiveSheet.

Alternatively, you could manually copy a sheet using by first reading the original sheet into MATLAB and then writing it back to Excel as a new sheet. This is discussed in more detail at:

https://www.mathworks.com/matlabcentral/answers/407071-how-to-copy-excel-sheet-from-book-to-book

Best Answer

Related Solutions

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

MATLAB: How to use activex to copy an Excel spreadsheet within the same workbook

Related Question