Using Matlab to Work with Data in Excel

3 次查看(过去 30 天)
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 个评论
Steven
Steven 2012-12-12
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.

请先登录,再进行评论。

回答(1 个)

Vishal Rane
Vishal Rane 2012-12-12

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by