Need Help:: Data import and export of modified data

1 次查看(过去 30 天)
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.
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.

更多回答(0 个)

Community Treasure Hunt

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

Start Hunting!

Translated by