I know most of you would advise me to just get the data with xlsread()
and plot it in Matlab. However I still want to know if it's possible to get a chart from excel to the matlab report generator as an image (or any other format) by coding it so it's automated.
The reason is I am supposed to make a report using multiple excel files that I did not create and that contains graphs that I would like to put in my report. So that would be more convenient if I could just copy the graphs & charts into my report.
Most of the things I found were saying to plot it with Matlab and nothing else. As i understand with xlsread
you can only get [NUM,TXT,RAW]
. So is there a function in the Matlab Report Generator to import the Excel graphs or should I just resign myself into reploting everything?
To do what I wanted I followed @CrisLuengo's suggestion and wrote a VBA macro in my spreadsheet that swipes in all the workbooks I have and exports all my charts as jpg.