Plot data in excel on saved chart template

조회 수: 2 (최근 30일)
Tyler Murray
Tyler Murray 2017년 3월 2일
편집: Tyler Murray 2017년 3월 2일
I am trying to plot data in Excel from Matlab onto a chart template that I saved from Excel. I tried manipulating the VBA code to load the template which is
eW.ActiveSheet.Shapes.AddChart.Select;
eWs.ActiveChart.ApplyChartTemplate('C:...')
but I error out saying AddChart and ApplyChartTemplate is not a command. I have a feeling that I can do this with invoke but have had no luck trying something like this
template = 'C:....';
% Add a chart to the workbook
Chart = invoke(Excel,'ApplyTemplate',template);
Has anyone ever loaded a chart template and plotted to it successfully?

답변 (0개)

카테고리

Help CenterFile Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by