C# Class Smrf.NodeXL.ExcelTemplate.WorkbookExporter

Exports a workbook's contents to another workbook.
Use ExportSelectionToNewNodeXLWorkbook to export the selected rows of the edge and vertex tables to a new NodeXL workbook. Use ExportToNewMatrixWorkbook to export the edge table to a new workbook as an adjacency matrix.
Afficher le fichier Open project: 2014-sed-team3/term-project

Protected Properties

Свойство Type Description
m_oWorkbookToExport Microsoft.Office.Interop.Excel.Workbook

Méthodes publiques

Méthode Description
ExportSelectionToNewNodeXLWorkbook ( ) : Microsoft.Office.Interop.Excel.Workbook
ExportToNewMatrixWorkbook ( ) : Microsoft.Office.Interop.Excel.Workbook
WorkbookExporter ( Microsoft workbookToExport ) : System

Initializes a new instance of the WorkbookExporter class.

Méthodes protégées

Méthode Description
CopyRowsToNewNodeXLWorkbook ( ListObject oSourceTable, Range oSourceTableRangeToCopy, Workbook oNewNodeXLWorkbook ) : void
CopyTableToNewNodeXLWorkbook ( String sWorksheetName, String sTableName, String sTemplatePath, Workbook &oNewNodeXLWorkbook ) : void
GetOrAddTableColumn ( ListColumn oSourceColumn, ListObject oNewTable ) : Range

Private Methods

Méthode Description
AssertValid ( ) : void

Method Details

CopyRowsToNewNodeXLWorkbook() protected méthode

protected CopyRowsToNewNodeXLWorkbook ( ListObject oSourceTable, Range oSourceTableRangeToCopy, Workbook oNewNodeXLWorkbook ) : void
oSourceTable ListObject
oSourceTableRangeToCopy Range
oNewNodeXLWorkbook Workbook
Résultat void

CopyTableToNewNodeXLWorkbook() protected méthode

protected CopyTableToNewNodeXLWorkbook ( String sWorksheetName, String sTableName, String sTemplatePath, Workbook &oNewNodeXLWorkbook ) : void
sWorksheetName String
sTableName String
sTemplatePath String
oNewNodeXLWorkbook Workbook
Résultat void

ExportSelectionToNewNodeXLWorkbook() public méthode

public ExportSelectionToNewNodeXLWorkbook ( ) : Microsoft.Office.Interop.Excel.Workbook
Résultat Microsoft.Office.Interop.Excel.Workbook

ExportToNewMatrixWorkbook() public méthode

public ExportToNewMatrixWorkbook ( ) : Microsoft.Office.Interop.Excel.Workbook
Résultat Microsoft.Office.Interop.Excel.Workbook

GetOrAddTableColumn() protected méthode

protected GetOrAddTableColumn ( ListColumn oSourceColumn, ListObject oNewTable ) : Range
oSourceColumn ListColumn
oNewTable ListObject
Résultat Range

WorkbookExporter() public méthode

Initializes a new instance of the WorkbookExporter class.
public WorkbookExporter ( Microsoft workbookToExport ) : System
workbookToExport Microsoft /// The NodeXL workbook to export. ///
Résultat System

Property Details

m_oWorkbookToExport protected_oe property

protected Workbook,Microsoft.Office.Interop.Excel m_oWorkbookToExport
Résultat Microsoft.Office.Interop.Excel.Workbook