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.
Datei anzeigen Open project: 2014-sed-team3/term-project

Protected Properties

Property Type Description
m_oWorkbookToExport Microsoft.Office.Interop.Excel.Workbook

Public Methods

Method 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.

Protected Methods

Method 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

Method Description
AssertValid ( ) : void

Method Details

CopyRowsToNewNodeXLWorkbook() protected method

protected CopyRowsToNewNodeXLWorkbook ( ListObject oSourceTable, Range oSourceTableRangeToCopy, Workbook oNewNodeXLWorkbook ) : void
oSourceTable ListObject
oSourceTableRangeToCopy Range
oNewNodeXLWorkbook Workbook
return void

CopyTableToNewNodeXLWorkbook() protected method

protected CopyTableToNewNodeXLWorkbook ( String sWorksheetName, String sTableName, String sTemplatePath, Workbook &oNewNodeXLWorkbook ) : void
sWorksheetName String
sTableName String
sTemplatePath String
oNewNodeXLWorkbook Workbook
return void

ExportSelectionToNewNodeXLWorkbook() public method

public ExportSelectionToNewNodeXLWorkbook ( ) : Microsoft.Office.Interop.Excel.Workbook
return Microsoft.Office.Interop.Excel.Workbook

ExportToNewMatrixWorkbook() public method

public ExportToNewMatrixWorkbook ( ) : Microsoft.Office.Interop.Excel.Workbook
return Microsoft.Office.Interop.Excel.Workbook

GetOrAddTableColumn() protected method

protected GetOrAddTableColumn ( ListColumn oSourceColumn, ListObject oNewTable ) : Range
oSourceColumn ListColumn
oNewTable ListObject
return Range

WorkbookExporter() public method

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

Property Details

m_oWorkbookToExport protected_oe property

protected Workbook,Microsoft.Office.Interop.Excel m_oWorkbookToExport
return Microsoft.Office.Interop.Excel.Workbook