SOS: xlswrite with cell array

1 Ansicht (letzte 30 Tage)
Zoe Zhang
Zoe Zhang am 12 Jul. 2011
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!

Akzeptierte Antwort

Oleg Komarov
Oleg Komarov am 12 Jul. 2011
[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 Kommentare
Fangjun Jiang
Fangjun Jiang am 12 Jul. 2011
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 am 12 Jul. 2011
oic, thx!! :)

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Produkte

Community Treasure Hunt

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

Start Hunting!

Translated by