fig2xls

Convert MATLAB figures to Excel Charts.

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.

[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

[bruno parente]

 

[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

[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 );