Chart.Export(String, Object, Object) Method
Definition
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 -> boolPublic Function Export (Filename As String, Optional FilterName As Object, Optional Interactive As Object) As Boolean- 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.
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
For information on optional parameters, see Optional Parameters in Office Solutions.