 |
| IXlsChart |
|
COM interface ( getting help with interfaces )
interface IXlsChart : IDispatch
{
[id(1),propget] HRESULT DataSource([out, retval]IXlsChartDataSource** datasource);
[id(2),propget] HRESULT Legend([out, retval]IXlsChartLegend** legend);
[id(3),propget] HRESULT MainTitle([out, retval]IXlsChartTitle**);
[id(4),propget] HRESULT PlotArea([out, retval]IXlsChartPlotArea** plotarea);
[id(5),propget] HRESULT SurfaceArea([out, retval]IXlsChartSurfaceArea** surfacearea);
[id(6),propget] HRESULT SeriesByIndex([in]int i, [out, retval]IXlsChartSeries** series);
[id(7),propget] HRESULT SeriesByName([in]BSTR seriesname, [out, retval]IXlsChartSeries** series);
[id(8),propget] HRESULT XAxis([in]enumChartAxisType axistype, [out, retval]IXlsChartAxis** axis);
[id(9),propget] HRESULT YAxis([in]enumChartAxisType axistype, [out, retval]IXlsChartAxis** axis);
[id(10),propget] HRESULT ZAxis([out, retval]IXlsChartAxis** axis);
[id(11),propget] HRESULT ThreeDeePanel([out, retval]IXlsChart3DPanel** threedeepanel);
[id(12),propget] HRESULT MainDataLabels([out, retval]IXlsChartDataLabels** datalabels);
[id(13),propget] HRESULT CustomProperties([out, retval]IXlsChartCustomProperties** customproperties);
[id(14),propget] HRESULT DataTableLegend([out, retval]IXlsChartDataTable** datatable);
[id(15),propget] HRESULT PageSetup([out, retval] IXlsPageSetup** pagesetup);
[id(16),propget] HRESULT DynamicDataSource([out, retval]IXlsChartDynamicDataSource** dynamicdatasource);
[id(17) ] HRESULT AddTextBox([out, retval]IXlsChartTextBox** textbox);
[id(18),propget] HRESULT Type([out, retval]enumChartType* type);
[id(19),propget] HRESULT Embedded([out, retval]BOOL* embedded);
[id(20),propget] HRESULT ChartPositionTop([out, retval]int* row);
[id(21),propget] HRESULT ChartPositionLeft([out, retval]int* column);
[id(22),propget] HRESULT ChartPositionBottom([out, retval]int* row);
[id(23),propget] HRESULT ChartPositionRight([out, retval]int* column);
[id(24),propget] HRESULT Shapes([out, retval]IXlsChartShapes** shapes);
[id(25) ] HRESULT ExtractToFile([out, retval]BSTR* filename);
[id(26) ] HRESULT ExtractToMemory([in]IUnknown* lockbytes);
}
HRESULT DataSource([out, retval]IXlsChartDataSource** datasource);
returns the chart data source object. The (static) data source is an alternative to the dynamic data source.
HRESULT Legend([out, retval]IXlsChartLegend** legend);
returns the chart legend object.
HRESULT MainTitle([out, retval]IXlsChartTitle**);
returns the chart title object.
HRESULT PlotArea([out, retval]IXlsChartPlotArea** plotarea);
returns the chart plot area object.
HRESULT SurfaceArea([out, retval]IXlsChartSurfaceArea** surfacearea);
returns the chart surfacearea object.
HRESULT SeriesByIndex([in]int i, [out, retval]IXlsChartSeries** series);
returns a series by index. Index starts at 1.
HRESULT SeriesByName([in]BSTR seriesname, [out, retval]IXlsChartSeries** series);
returns a series by name. Names are case insensitive. Not available if you are using a dynamic data source (IXlsDynamicDataSource).
HRESULT XAxis([in]enumChartAxisType axistype, [out, retval]IXlsChartAxis** axis);
returns the (X) axis, used to display data labels.
HRESULT YAxis([in]enumChartAxisType axistype, [out, retval]IXlsChartAxis** axis);
returns the (Y) axis, used to display serie values.
HRESULT ZAxis([out, retval]IXlsChartAxis** axis);
returns the (Z) axis, used to display serie values in 3D charts.
HRESULT ThreeDeePanel([out, retval]IXlsChart3DPanel** threedeepanel);
returns the 3D panel object.
HRESULT MainDataLabels([out, retval]IXlsChartDataLabels** datalabels);
returns the data labels object.
HRESULT CustomProperties([out, retval]IXlsChartCustomProperties** customproperties);
returns the custom properties object.
HRESULT DataTableLegend([out, retval]IXlsChartDataTable** datatable);
returns the associated data table object. Does not apply to 3D charts and pie/doughnut/radar/surface/contour/bubble charts.
HRESULT PageSetup([out, retval] IXlsPageSetup** pagesetup);
retrieves the page setup information for this chart.
HRESULT DynamicDataSource([out, retval]IXlsChartDynamicDataSource** dynamicdatasource);
returns the chart dynamic data source object. The dynamic data source is an alternative to the regular (static) data source.
HRESULT AddTextBox([out, retval]IXlsChartTextBox** textbox);
adds a custom text box to the chart.
HRESULT Type([out, retval]enumChartType* type);
returns the chart type.
HRESULT Embedded([out, retval]BOOL* embedded);
returns whether the chart is part of the worksheet (i.e. embedded) or fills the entire surface of a worksheet.
HRESULT ChartPositionTop([out, retval]int* row);
returns the chart top row where it's located in the worksheet. Only applies to embedded charts.
HRESULT ChartPositionLeft([out, retval]int* column);
returns the chart left column where it's located in the worksheet. Only applies to embedded charts.
HRESULT ChartPositionBottom([out, retval]int* row);
returns the chart bottom row where it's located in the worksheet. Only applies to embedded charts.
HRESULT ChartPositionRight([out, retval]int* column);
returns the chart right column where it's located in the worksheet. Only applies to embedded charts.
HRESULT Shapes([out, retval]IXlsChartShapes** shapes);
gets the shapes collection in the chart.
HRESULT ExtractToFile([out, retval]BSTR* filename);
creates a snapshot of the chart as a picture in a file (PNG file format) and returns the filename.
HRESULT ExtractToMemory([in]IUnknown* lockbytes);
creates a snapshot of the chart as a picture in memory. The passed parameter is a pointer to a ILockBytes interface pointer. PNG buffer.