Need Help:: Data import and export of modified data

1 次查看（过去 30 天）
Frank
Frank 2011-5-9
Hello!
The issue I have is: I have a large collection of excels that I need to extract the first two columns from each and save the extracted columns into a new excel file (also probably a new folder as well). Can Matlab do this? and can someone help me get started? "I'm very new to MatLab"
Thanks,
-Frank

请先登录，再回答此问题。

采纳的回答

Saurabh Thakur
Saurabh Thakur 2011-5-9
You can use the XLSREAD function to read the first two columns into MATLAB. XLSREAD allows you to specify the range of data you want to read in.
http://www.mathworks.com/help/techdoc/ref/xlsread.html
Once you have to data in MATLAB, you can modify it as needed and then use the XLSWRITE function to write it out to a new Excel file.
http://www.mathworks.com/help/techdoc/ref/xlswrite.html

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by