SOS: xlswrite with cell array

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!

Answer 1

[Oleg Komarov]

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

[Zoe Zhang]

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]

What is the error message?

[Zoe Zhang]

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

Doesn't fail with me. Can you elaborate on the meaning of fail? (did you look in the right directory)

[Zoe Zhang]

wierd,wierd,wierd...it works now... Thanks both of you!!

[Fangjun Jiang]

If status is 1, it means it is written successfully. You have to double check your current folder to find the file.

[Zoe Zhang]

oic, thx!! :)