SOS: xlswrite with cell array

2011 7 12
1 个回答
回答已采纳
7 次查看（30 天）

1 个投票

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!

请先登录，再回答此问题。

 采纳的回答

Oleg Komarov
Oleg Komarov 2011-7-12

1 个投票

[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 个评论
显示 5更早的评论 隐藏 5更早的评论

Zoe Zhang
Zoe Zhang 2011-7-12
But when I ran xlswrite('filename',R1000_IV(:,1),'Russell 1000','F4:F138'); it totally works, where R1000_IV(:,1) is a numeric vector. So I think may be there is sth wrong with the cell array?
Thanks for your help!
Fangjun Jiang
Fangjun Jiang 2011-7-12
What is the error message?
Zoe Zhang
Zoe Zhang 2011-7-12
[status,msg] = xlswrite('Global_IV_Report',R1000_Co_ticker(1:135,1),'Russell 1000','D4:D138')
status =
1
msg =
message: ''
identifier: ''
No error msg whatsoever, and failed to export the result into excel. Thanks!
Oleg Komarov
Oleg Komarov 2011-7-12
Doesn't fail with me. Can you elaborate on the meaning of fail? (did you look in the right directory)
Zoe Zhang
Zoe Zhang 2011-7-12
wierd,wierd,wierd...it works now... Thanks both of you!!
Fangjun Jiang
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.
Zoe Zhang
Zoe Zhang 2011-7-12
oic, thx!! :)

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 MATLAB 的更多信息

产品

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by