SOS: xlswrite with cell array
1 回表示 (過去 30 日間)
古いコメントを表示
Hello, I don't know why it doesn't work and how to correct it.
R1000_Co_ticker is a 135*2 cell array, which looks like:
R1000_Co_ticker =
'MCP' 'LZ'
'WLT' 'ARG'
'LYB' 'IFF'
'ANV' 'ECL'
'CF' 'BLL'
'MCP' 'LZ'
'WLT' 'ARG'
'LYB' 'ECL'
'ANV' 'IFF'
'CF' 'BLL'
'MCP' 'LZ'
'WLT' 'ECL'
'ANV' 'ARG'
'LYB' 'IFF'
'CF' 'BLL'
I am running [status,msg] = xlswrite('filename',R1000_Co_ticker(1:135,1),'Russell 1000','D4:D138');
But it doesn't work. Please help on my case, very appreciated!
0 件のコメント
採用された回答
Oleg Komarov
2011 年 7 月 12 日
[status,msg] = xlswrite('myFile.xlsx',R1000_Co_ticker(1:135,1),'Russell 1000','D4:D138');
myFile.xlsx will be created in the current directory. If you want a specific location just include C:\...\myFile.xlsx where you have to replace the dots with your prefered location.
7 件のコメント
Fangjun Jiang
2011 年 7 月 12 日
If status is 1, it means it is written successfully. You have to double check your current folder to find the file.
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Audio and Video Data についてさらに検索
製品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!