清空筛选条件
清空筛选条件

I want to store two worksheets together in excel sheet from matlab.

2 次查看（过去 30 天）
ria
ria 2012-11-21
please help as I am only able to store only one worksheet at a time.

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

回答（1 个）

Azzi Abdelmalek
Azzi Abdelmalek 2012-11-21
a=rand(5)
b=rand(5)
xlswrite('filename.xls',a,'sh1')
xlswrite('filename.xls',b,'sh2')
  4 个评论
显示 2更早的评论
ria
ria 2012-11-26
I WANT TO IMPORT THE ANSWER DIRECTLY FROM MATLAB INTO EXCEL .AND IN EXCEL ALSO I WANT TO STORE THE 191 VARIABLES (THEY ARE DIGITS,VALUES IN FIMTO FARADS,NANO HENRY ETC.) IN THE SAME SHEET BUT IN DIFFERENT COLUMN.THANX IN ADVANCE .
Azzi Abdelmalek
Azzi Abdelmalek 2012-11-26
编辑：Azzi Abdelmalek 2012-11-26
You din'nt mention the sizes of your variables (number of lines and column of each variable). If your variables have the same number of lines you can concatenate them for example:
var1=rand(10,2);
var3=rand(10,4);
var3=rand(10,5;
data=[var1 var2 var3]
xlswrite('filename.xls',data)
If not, tell us what kind of data are you using?

请先登录，再进行评论。

类别

在 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