Rank: 1108 based on 108 downloads (last 30 days) and 1 file submitted
photo

Marin Deresco

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

Personal Profile:
Professional Interests:
Financial engineering / HPC

 

Watch this Author's files

 

Files Posted by Marin
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 108 7
  • 3.0
3.0 | 1 rating
Comments and Ratings by Marin 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's Files View all
Updated File Comment by Comments Rating
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 Seel, Joachim

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 Byers, Edward

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 Deresco, Marin

@ 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 Deresco, Marin

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

Regards

06 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 Shoemaker, Paul

Very neat! Any chance we might see an xlread variant that is similarly cross-platform?

Contact us