ChartSheet.Export Method

Artykuł
07/25/2011

Exports the Microsoft.Office.Tools.Excel.ChartSheet in a graphic format.

Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
Function Export ( _
    Filename As String, _
    FilterName As Object, _
    Interactive As Object _
) As Boolean

bool Export(
    string Filename,
    Object FilterName,
    Object Interactive
)

Parameters

Filename
Type: System.String
The name of the exported file.

FilterName
Type: System.Object
The language-independent name of the graphic filter as it appears in the registry.

Interactive
Type: System.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.

Return Value

Type: System.Boolean

Remarks

Optional Parameters

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

Examples

The following code example uses the Export method to export the current Microsoft.Office.Tools.Excel.ChartSheet as a .gif file without displaying the file options.

Private Sub ExportChartSheetAsGIF()
    Globals.Sheet1.Range("A1", "A5").Value2 = 22
    Globals.Sheet1.Range("B1", "B5").Value2 = 55

    Me.SetSourceData(Globals.Sheet1.Range("A1", "B5"), _
        Excel.XlRowCol.xlColumns)
    Me.ChartType = Excel.XlChartType.xlColumnClustered
    Me.Export("C:\Chart1.gif", "GIF", False)
End Sub

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

    this.SetSourceData(Globals.Sheet1.Range["A1", "B5"],
        Excel.XlRowCol.xlColumns);
    this.ChartType = Excel.XlChartType.xlColumnClustered;

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

.NET Framework Security

Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

Udostępnij za pośrednictwem