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.

ファイルを表示 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