Chart.Export(String, Object, Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assembly:: Microsoft.Office.Tools.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Exports the chart in a graphic format.

public bool Export (string Filename, object FilterName, object Interactive);

abstract member Export : string * obj * obj -> bool

Public Function Export (Filename As String, Optional FilterName As Object, Optional Interactive As Object) As Boolean

Parameters

Filename: String

The name of the exported file.

FilterName: Object

The language-independent name of the graphic filter as it appears in the registry under HKEY_LOCAL_MACHINE\Software\Microsoft\Shared Tools\Graphics Filters.

Interactive: Object

true to display the dialog box that contains the filter-specific options. If this argument is false, Microsoft Office Excel uses the default values for the filter. The default value is false.

Returns

Boolean

Examples

The following code example creates a Chart and then uses the Export method to export the chart as a graphic file named Chart1.gif at the root of the C:\ directory.

private void SaveChartAsGIF()
{
    this.Range["A1", "A5"].Value2 = 22;
    this.Range["B1", "B5"].Value2 = 55;

    Microsoft.Office.Tools.Excel.Chart chart1 =
        this.Controls.AddChart(this.Range["D2", "H12"], 
        "chart1");

    chart1.SetSourceData(this.Range["A1", "B5"], 
        Excel.XlRowCol.xlColumns);
    chart1.ChartType = Excel.XlChartType.xl3DColumn;

    chart1.Export(@"C:\Chart1.gif", "GIF", false);
}

Private Sub SaveChartAsGIF()
    Me.Range("A1", "A5").Value2 = 22
    Me.Range("B1", "B5").Value2 = 55

    Dim Chart1 As Microsoft.Office.Tools.Excel.Chart = _
        Me.Controls.AddChart(Me.Range("D2", "H12"), "Chart1")

    Chart1.SetSourceData(Me.Range("A1", "B5"), Excel.XlRowCol.xlColumns)
    Chart1.ChartType = Excel.XlChartType.xl3DColumn

    Chart1.Export("C:\Chart1.gif", "GIF", False)
End Sub

Remarks

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

Applies to

Partager via