MATLAB Answers

Exporting data from matlab to a excel with a special pathway

3 views (last 30 days)
Rengin
Rengin on 9 Sep 2019
Answered: Rengin on 9 Sep 2019
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!

  0 Comments

Sign in to comment.

Answers (2)

Alex Mcaulley
Alex Mcaulley on 9 Sep 2019
xlswrite(filename,Y1,1)
xlswrite(filename,Y2,2)
xlswrite(filename,Y3,3)

  4 Comments

Show 1 older comment
Alex Mcaulley
Alex Mcaulley on 9 Sep 2019
filename = fullfile('yourPath','Admittance.xlsx') %where yourPath is the folder where you want to save the file
Rengin
Rengin on 9 Sep 2019
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 on 9 Sep 2019
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

Sign in to comment.


Rengin
Rengin on 9 Sep 2019
% 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)

  0 Comments

Sign in to comment.

Sign in to answer this question.