Plots in excel sheets using matlab

52 次查看（过去 30 天）
Vikas Saroha
Vikas Saroha 2019-5-21
评论： Dheeraj 2023-3-2
I have an excel file with 50 sheets. Each excel sheet has 4 coloumns. I want to plot graph in each excel sheet using 4 coloumns as 4 series of data. How is it possible.
  3 个评论
显示 1更早的评论
Vikas Saroha
Vikas Saroha 2019-5-21
line connecting all points vs 1,2,3,------till no of rows.
KALYAN ACHARJYA
KALYAN ACHARJYA 2019-5-21
编辑：KALYAN ACHARJYA 2019-5-21
Sorry, its not clear to me.

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Bob Thompson
Bob Thompson 2019-5-21
If you want to create a plot in the excel sheet directly you need to use the ActXServer capability.
Here is a brief layout of what you're looking for. It's not going to be perfect, but it should get you started. Variable names are optional, but keep track of what they are calling.
rows = 100; % Set number of rows, if variable this gets much tougher
xl = actxserver('Excel.Application'); % Open excel
% set(xl,'Visible',1); % Make excel visible
xlsdir = pwd; % Set excel to work in current directory
xls = xl.Workbooks.Open('myexcelfile.xlsx'); % Open specific document
xlss = xls.Worksheets; % Define worksheet variable, for easier calling
for i = 1:50;
xlssl = xlss.get('Item',i); % Select next worksheet
xlssl.Activate % Activate selected worksheet
xlchart = xlssl.ChartObjects.Add(xloc,yloc,xsize,ysize); % Create a chart in a defined location and size
xlchart.Chart.Charttype = 'xlxyscattersmoothNoMarkers'; % Set chart type, can adjust as needed
for j = 1:rows
xlchart.Chart.SeriesCollection.NewSeries; % Create an new series
xlchart.Chart.SeriesCollection(j).Name = seriesname; % Name the new series. Must be as string!
xlchart.Chart.SeriesCollection(j).XValues = [1 2 3 4];
% Define xvalues of series
xlchart.Chart.SeriesCollection(j).Values = xlssl.Range(sprintf('A%i:D%i',j,j));
% Define yvalues of series
xlchart.Chart.SeriesCollection.Item(j).Format.Line.ForeColor.SchemeColor = 4;
end
% Useful formatting stuff
xlchart.Chart.HasTitle = 1;
xlchart.Chart.Axes(1).HasTitle = 1;
xlchart.Chart.Axes(2).HasTitle = 1;
xlchart.Chart.Axes(1).AxisTitle.Text = 'Number';
xlchart.Chart.Axes(2).AxisTitle.Text = 'Other Number';
% Set Xaxis range
xlchart.Chart.Axes(1).Minimumscale = 0;
xlchart.Chart.Axes(2).Minimumscale = 0;
xlchart.Chart.Axes(1).MaximumScale = 3.0;
% Activate grid lines
xlchart.Chart.Axes(1).HasMajorGridlines = 1;
end
xls.Save; % Save the document
xl.Quit; % Close the document
xl.delete; % Remove Excel reference to allow the document to be opened independantly
  5 个评论
显示 3更早的评论
Dheeraj
Dheeraj 2023-3-2
Does there exist a complete guide for the chart variables such as the line below?
xlchart.Chart.SeriesCollection.Item(j).Format.Line.ForeColor.SchemeColor
I want some other costomization options such as removing legend and all...
Dheeraj
Dheeraj 2023-3-2
Nevermind, found it.
https://learn.microsoft.com/en-us/office/vba/api/excel.chart(object)

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File 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