Importing and Exporting to Excel
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
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
0 Kommentare
Akzeptierte Antwort
Image Analyst
am 28 Mai 2013
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 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!