save dataset in a specific exel sheet

1 次查看（过去 30 天）
lih jo
lih jo 2014-8-8
评论： lih jo 2014-8-11
hi everyone,
someone can tell me how can i save a dataset in a specific sheet from exel?
Thanks

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

采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2014-8-8
num = xlsread(filename,sheet)
  2 个评论
lih jo
lih jo 2014-8-11
I really mean save a dataset with the matlab function export. With funtion export i can save the dataset in Excel but i can´t choose the sheet.
export(DS,'XLSFile',FILENAME)
The xlsread don´t let me save a dataset, i don´t know why, but i use xlsread to matrix or vectors and works well.
Thanks
Azzi Abdelmalek
Azzi Abdelmalek 2014-8-11
convert your dataset to cell then use xlswrite
M=dataset2cell(A) % A is your dataset
xlswrite('your_file.xlsx',M,sheet)

请先登录，再进行评论。

更多回答（1 个）

Image Analyst
Image Analyst 2014-8-8
编辑：Image Analyst 2014-8-8
Your wording is contradictory ("save from excel"). Not sure if you mean read from Excel or save to Excel, so I'll give both cases:
To retrieve a dataset from Excel ( into MATLAB), use
[numbers, textCells, rawCells] = xlsread(fullFileName, sheetname);
To save a dataset in a specific sheet to Excel ( from MATLAB to Excel)?
xlswrite(fullFileName, data, 'A1', sheetname);
  3 个评论
显示 1更早的评论
Image Analyst
Image Analyst 2014-8-11
xlsread() does not send/export data from MATLAB to Excel. That's what xlswrite() does. Is there any reason why you think you must use export() instead of xlswrite() like Azzi showed you?
lih jo
lih jo 2014-8-11
xlswrite doesn't work with dataset, so i' m trying use export function. Azzi answer Works. Thanks

请先登录，再进行评论。

类别

在 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