Be the first to rate this file! 14 Downloads (last 30 days) File Size: 4.47 KB File ID: #31105

Write data to Excel

by

 

19 Apr 2011 (Updated )

Write matrix to Excel-file, and leave the files open. File written to is not saved.

| Watch this File

File Information
Description

Write to an Excel-file. If file not excist, the file is created based on user input in the filename(xls, xlsx, xlsm...).

If the sheet not excist, the sheet is created. Range can be given as single cell, and the function calculate what range to write to. Otherwise the absolut range that fits the matrix size must be given in.

Default is that file is on current path, if optional path-values is given file is open outside the path, and created if not excist allready.

Comments are hastly translate an error control is done to some exstent.

MATLAB release MATLAB 7.14 (R2012a)
Other requirements NONE
Tags for This File   Please login to tag files.
Please login to add a comment or rating.
Comments and Ratings (2)
04 May 2012 Gunnar Aronsen

New version of the file is uploaded, errors are fixed.

02 May 2012 Joseph

I get the following error

??? Error using ==> eq
Matrix dimensions must agree.

Error in ==> w2excel at 26
if aktivtark.codename == w2sheet

Error in ==> test_w2excel at 3
w2excel('Book1','Sheet1','B2',c');

Updates
03 May 2012

New upload 03-May-2012
Second upload comment:
Error reporte 02-May-2012 corrected.

13 Sep 2012

File to write does not need to be active Excel file, function select correct file.

14 Sep 2012

Corrected the file so it start Excel if not open. This was not included in the last function.

Contact us