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 5.3.1 (R11.1)
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
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 );
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
16 Feb 2006
02 Jun 2003
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).