How can I add chart in a specific sheet in an excel workbook via Matlab?

I would like to add a chart in a specific sheet in an excel workbook via Matlab? Is this possible?

Answer 1

[Gareth Thomas]

There are a few ways of doing this:

- If you use MATLAB Spreadsheet link Spreadsheet link this will enable you from Excel to call MATLAB and bring in MATLAB plots

- Some people like using Excel graphs and use MATLAB to refresh the data. So if have the data in MATLAB, and writetable or xlswrite to a specific sheet, then you can have the Excel create a chart based on that range, all you need is to update the chart.

- It is also possible to control Excel from MATLAB via the COM interface, however this takes a little more work.

- It is also possible to create an excel add-in with MATLAB Compiler SDK, that takes your MATLAB function and embeds it in Excel.

[George Kouskoulis]

Thank you Thomas for your response!

My apologies for not being enough definite!

The data are in m.file. I export them in an excel file in many sheets (the number of the sheets depends on the data) by using xlswrite.

The aim is to create charts (one in each sheet) from the stored data via Matlab code.

[George Kouskoulis]

In addition to the above I cite the code:

 run ('tracks.m');
excel = actxserver;
ExcelFile = 'results.xlsx';
for n = 2:20
  x = size(eval(strcat('TRACK.R',num2str(n))),1);
  for m = 1:(x-1)
      y = eval(strcat('TRACK.R',num2str(n)));
      sheet = num2str(n);
      xlrange_y = 'A2';
      xlswrite(ExcelFile,y,sheet,xlrange_y);
   end
end

My question is how can I add a chart after writing all the data in the first sheet (after the internal loop) and repeating this for all the sheets (in this situation we have 20 sheets - external loop)?

[Gareth Thomas]

I believe you are looking for something like this. See this thread.

See this

[George Kouskoulis]

Thank you very much Thomas!

I saw the thread and my problem is solved.

Another question is that whether you can create a chart in a excel workbook with many sheets and the data for your chart come from more than one sheets of the workbook?

Thank you in advance!