SOS: xlswrite with cell array

2 次查看（过去 30 天）
Zoe Zhang
Zoe Zhang 2011-7-12
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
[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更早的评论
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.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by