Need Help:: Data import and export of modified data
1 view (last 30 days)
Show older comments
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"
Saurabh Thakur on 9 May 2011
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.
More Answers (0)
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!