MATLAB Answers


Using Matlab to Work with Data in Excel

Asked by meirSimchah
on 12 Dec 2012

I have data in .xlsx files. I want to read it into Matlab matrices, do stuff with it, then write it into new .xlsx files. The documentation for xlsread and xlswrite makes this sound simple; but then, it turns out, I need to learn about COM and I don't even know what else. I'm a beginner with Matlab and with programming in general. So please keep things simple for me. Can you help me understand what Matlab and Excel need in order to speak civilly with each other? Can you show me how to make this work in Matlab code? Thank you!

  1 Comment

on 12 Dec 2012

Typing 'help xlsread' and 'help xlswrite' in the command window really should give you all the info you need. For example, the command A=xlsread(name.xlsx) stores all the number of the excel-file name.xlsx in the matrix A.


No products are associated with this question.

1 Answer

Answer by Vishal Rane
on 12 Dec 2012


Discover MakerZone

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn more

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today

MATLAB Academy

New to MATLAB?

Learn MATLAB today!