ActiveX to open the selected spreadsheet in Matlab

Hi,

I want to write a code in Matlab that I can open the selected spreadsheet in Excel file and plot it. Does anyone know how to do that? I'd really appreciate your help. Thanks alot.

Answer 1

[Bob Thompson]

ActiveX is very powerful for manipulating the actual excel document through excel, but takes a while to learn. If you are just looking to plot some data, xlsread() is a much simpler command which will read your data and allow you to manipulate it within matlab.

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