SOS: xlswrite with cell array

1 次查看（过去 30 天）

显示更早的评论

Zoe Zhang 2011-7-12

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/11466-sos-xlswrite-with-cell-array

采纳的回答： Oleg Komarov

在 MATLAB Online 中打开

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

请先登录，再进行评论。

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

采纳的回答

Oleg Komarov 2011-7-12

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/11466-sos-xlswrite-with-cell-array#answer_15642

在 MATLAB Online 中打开

[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.