Importing and Exporting to Excel

1 次查看（过去 30 天）

Nada Ismail 2013-5-28

I am trying to import an Excel file into MATLAB, extract 2 columns of information, then save two columns into a pre-existing file.

For example, the file imported into MATLAB will be similar to this:

_1810 AUDIO WMSE - Underwriting Promo #1 C:\RADIOSPOTS\AUDIO\1810.WAV

2891 AUDIO Shepherd Express - General C:\RADIOSPOTS\AUDIO\2891.WAV_

I want to extract:

_1810 WMSE - Underwriting Promo #1

2891 Shepherd Express - General_

and save in the file below under PSA_num *and *Client Name:

PSA_num Client Name Start_Time End_time Category Script

R124 Special Olympics 4/12/2013 4/12/2014 Environment Hello

R123 Ad Council 4/12/2013 4/12/2013 Educational Hello

R123 Wisconsin 4/13/2013 4/13/2013 Educational Hello

Image Analyst 2013-5-28

Did you try xlsread() and xlswrite()? If xlswrite is blowing away your existing workbook, then you can try writing it to a worksheet of a different name (e.g. "results" instead of to "sheet1") or you can use Active X: http://www.mathworks.com/support/solutions/en/data/1-QLD4K/index.html?solution=1-QLD4K