Rank: 1057 based on 125 downloads (last 30 days) and 1 file submitted
photo

Marin Deresco

E-mail
Company/University
Université de Nice Sophia Antipolis

Personal Profile:

 

Watch this Author's files

 

Files Posted by Marin Deresco
Updated   File Tags Downloads
(last 30 days)
Comments Rating
03 Aug 2012 Screenshot xlwrite : Export Data to Excel from Matlab on Mac/Win xlwrite allows you to export data (2d/3d arrays of double/cell) to Excel from Matlab (Mac/Win) Author: Marin Deresco java, xlswrite, mac, excel, cell2char 125 8
  • 3.0
3.0 | 1 rating
Comments and Ratings by Marin Deresco View all
Updated File Comments Rating
17 Oct 2012 xlwrite : Export Data to Excel from Matlab on Mac/Win xlwrite allows you to export data (2d/3d arrays of double/cell) to Excel from Matlab (Mac/Win) Author: Marin Deresco

@ the cyclist:
check the following submission:
http://www.mathworks.com/matlabcentral/fileexchange/38591

17 Oct 2012 xlwrite: Generate XLS(X) files without Excel on Mac/Linux/Win Generates ‘.xls’ & '.xlsx' files on Mac/Linux/Win without Excel, using same syntax as xlswrite. Author: Alec de Zegher

nice!

20 Aug 2012 xlwrite : Export Data to Excel from Matlab on Mac/Win xlwrite allows you to export data (2d/3d arrays of double/cell) to Excel from Matlab (Mac/Win) Author: Marin Deresco

@ Paul Shoemaker :
Will try to test a quick solution for xlsread soon (1-2 months).

Regards

03 Aug 2012 xlwrite : Export Data to Excel from Matlab on Mac/Win xlwrite allows you to export data (2d/3d arrays of double/cell) to Excel from Matlab (Mac/Win) Author: Marin Deresco

@ the cyclist :
Hope xlwrite will help you. Thank you for the remark about the specific cells export. I didn't focus on this point yet. The idea behind xlwrite was to export Matlab 3d arrays of doubles or cells to excel.
If time permits, my next submission will contain currently missing xlswrite features.

Comments and Ratings on Marin Deresco's Files View all
Updated File Comment by Comments Rating
29 Oct 2014 xlwrite : Export Data to Excel from Matlab on Mac/Win xlwrite allows you to export data (2d/3d arrays of double/cell) to Excel from Matlab (Mac/Win) Author: Marin Deresco samar

Hi, could I write on specific cells with xlwrite?
If the answer is yes please tell me how!

24 Feb 2014 xlwrite : Export Data to Excel from Matlab on Mac/Win xlwrite allows you to export data (2d/3d arrays of double/cell) to Excel from Matlab (Mac/Win) Author: Marin Deresco Joachim Seel

Hi, I have downloaded the xlwrite file but run into this error when trying to run the script below: Any suggestions how to correct this error? Thanks!

Undefined function 'WriteXL' for input arguments of type 'java.lang.String'.

Error in xlwrite (line 68)
WriteXL(java.lang.String(file),Cell2JavaString(data),m(1),m(2));

This is the script.

%define variables
anualbaselineT=5045.2;
anualbaselineX=6902.8;
anualbaselineZ=8773.5;
PVloadratio=1.56;

% read in dynamic load
[dynamic_load_matrix,~,~]=xlsread('../E1_Load_Profile.xlsx','sheet1','C1:Z365');

%pre-allocate for speed
dynamic_load_vector=zeros(8760,1);

% loop through each row of dynamic_load_matrix and append to
% dynamic_load_vector
for i=1:365

dynamic_load_vector((24*i-23):(24*i))=dynamic_load_matrix(i,:);

end

dynamic_load_vector_norm=dynamic_load_vector/sum(dynamic_load_vector);

dynamic_load_baseline_norm(:,1)=dynamic_load_vector_norm*anualbaselineT;
dynamic_load_baseline_norm(:,2)=dynamic_load_vector_norm*anualbaselineX;
dynamic_load_baseline_norm(:,3)=dynamic_load_vector_norm*anualbaselineZ;

dynamic_load_baseline_norm_PV=dynamic_load_baseline_norm*PVloadratio;

header_baseline={'baselineT','baselineX','baselineZ'};
%%
xlwrite('../E1_load_vector.xlsx',header_baseline);

xlwrite('../E1_load_vector.xlsx',header_baseline,'load','A1:C1');
xlwrite('../E1_load_vector.xlsx',dynamic_load_baseline_norm,'load','A2:C366');

xlwrite('../E1_load_vector.xlsx',header_baseline,'load_PV','A1:C1');
xlwrite('../E1_load_vector.xlsx',dynamic_load_baseline_norm,'load_PV','A2:C366');

28 Jul 2013 xlwrite : Export Data to Excel from Matlab on Mac/Win xlwrite allows you to export data (2d/3d arrays of double/cell) to Excel from Matlab (Mac/Win) Author: Marin Deresco Edward Byers

Complicated to get started with the java files etc and no very good instructions on this. See the example however.
Doesn't support specifying to a range.
However - support multi-dimensional variables which is a great bonus.

17 Oct 2012 xlwrite : Export Data to Excel from Matlab on Mac/Win xlwrite allows you to export data (2d/3d arrays of double/cell) to Excel from Matlab (Mac/Win) Author: Marin Deresco Marin Deresco

@ the cyclist:
check the following submission:
http://www.mathworks.com/matlabcentral/fileexchange/38591

20 Aug 2012 xlwrite : Export Data to Excel from Matlab on Mac/Win xlwrite allows you to export data (2d/3d arrays of double/cell) to Excel from Matlab (Mac/Win) Author: Marin Deresco Marin Deresco

@ Paul Shoemaker :
Will try to test a quick solution for xlsread soon (1-2 months).

Regards

Contact us