Importing and Exporting to Excel

1 次查看（过去 30 天）
Nada Ismail
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
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
  7 个评论
显示 5更早的评论
Image Analyst
Image Analyst 2013-5-29
If we're done, please go ahead and mark this as "Answered". Thanks.

请先登录，再进行评论。

更多回答（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