No BSD License  

Highlights from
fig2xls

3.66667

3.7 | 3 ratings Rate this file 18 Downloads (last 30 days) File Size: 3.32 KB File ID: #3426

fig2xls

by

 

11 May 2003 (Updated )

Convert MATLAB figures to Excel Charts.

| Watch this File

File Information
Description

FIG2XLS converts all open figures to Excel charts. Only scatter 2-D plots are supported. One chart and one sheet are created per subplot. FIG2XLS(FIGS) converts just figure numbers FIGS. Within the limits of Excel, most figure properties are converted.

MATLAB release MATLAB 5.3.1 (R11.1)
Other requirements Tested recently with: MATLAB 5.3.1, 6.1, 6.5, Excel 2000 and Win2000. Expected to work with some earlier versions of MATLAB, Excel and Windows.
Tags for This File   Please login to tag files.
Please login to add a comment or rating.
Comments and Ratings (4)
20 Dec 2008 Tim

On a simple 100-point line plot I get the following:
??? Invoke Error, Dispatch Exception:
Source: Microsoft Office Excel
Description: Unable to set the HasTitle property of the Chart class
Help File: H:\Microsoft Office\OFFICE11\1033\xlmain11.chm
Help Context ID: 0

Error in ==> fig2xls at 171
set( h.myChart, 'HasTitle', 1 );

20 Nov 2008 Julien Penon

Works well for me but it can be imrpoved:
1)as Ralph mention, add title to columns by following the legend , xlabel, ylabel ...
2)keep the annotation that were on the original plot
3)convert greek and latin symbol (but how 2 do it?)
4)the color did not match exactly
5)name the excel sheet as 'plo_titlet' an 'row data_title'

Overall, useful function. thanks

Julien

16 Feb 2006 bruno parente  
02 Jun 2003 Ralph Ewig

This can be a very useful utility, especially if it matures a bit more. I had to install the patches as explained in the readme file to get it to work. After that, it still breaks on plots with multiple y sets of the same x, but it does handle multiple y on the same plot if they do not overlap in x. Adding titles to the data columns would be nice, and complex plot titles get pretty garbeled in the translation (but are easily fixed).

1) The

Contact us