MATLAB: Need Help:: Data import and export of modified data

Question

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

Answer 1

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