Exporting data from matlab to a excel with a special pathway

1 次查看(过去 30 天)
Dear Users! Imagine that I have the matrices of Y1=rand(5), Y2=rand(7) and Y3=rand(4). I want to specifically export these matrices to an excel file at Desktop with a file name of Admittance.xlsx. Y1, Y2 and Y3 should be on Sheet 1, Sheet 2 and Sheet 3, respectively. Could you please help me to do it? Thanks a lot!

回答(2 个)

Alex Mcaulley
Alex Mcaulley 2019-9-9
xlswrite(filename,Y1,1)
xlswrite(filename,Y2,2)
xlswrite(filename,Y3,3)
  4 个评论
Rengin
Rengin 2019-9-9
filename = fullfile('\\etieeh.loc\homes\evma\cabadag\Desktop\Econs','Admittance.xlsx')
% I do exactly what you suggest. It doesn't work somehow. Do I make a mistake somewhere?
Alex Mcaulley
Alex Mcaulley 2019-9-9
What do you mean with "It doesn't work"? Do you get any error? If this is the case, please copy-paste the full error text

请先登录,再进行评论。


Rengin
Rengin 2019-9-9
% When I run the code below, it creates Admittance.xlsx at the location I want, no problem.
% The problem is that I have to add extra sheets in Admittance.xlsx (as many as the number of Y matrices).
% I doesn't add e.g. 3 sheets (for Y1, Y2 and Y3) in Admittance.xlsx automatically.
% The error message:
% Error using xlswrite (line 226)
% Error: The object invoked has disconnected from its clients.
%
%
%
% Error in DataExpImp (line 18)
% xlswrite(baseFileName,Y2,2)
clear
clc
close all
% Create the matrices
Y1=rand(5);
Y2=rand(7);
Y3=rand(4);
folder = '\\etieeh.loc\homes\EVMA\cabadag\Desktop\Econs';
% if ~exist(folder, 'dir')
% mkdir(folder);
% end
baseFileName = 'Admittance.xlsx';
fullFileName = fullfile(folder,baseFileName);
xlswrite(baseFileName,Y1,1)
xlswrite(baseFileName,Y2,2)
xlswrite(baseFileName,Y3,3)

Community Treasure Hunt

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

Start Hunting!

Translated by