C# Class ExcelQueryServiceAddIn.ExcelQueryServiceControl

Inheritance: QueryServiceControl.QueryServiceControl

Protected Methods

Method	Description
Dispose ( bool disposing ) : void	Clean up any resources being used.
getSelectedRangeAddress ( Microsoft.Office.Interop.Excel r ) : string
handleCDE ( System.Xml.Linq.XElement selectedNode ) : void	Applying CDE to selected cell/range with validation based on value domain of data element, and XmlMap for exporting XML data. TODO: Refactor code
handleConcept ( System.Xml.Linq.XElement selectedNode ) : void	Handles insertion of concept element into worksheet. TODO: Refactor code TODO: Is two way hyperlink possible?
handleOC ( System.Xml.Linq.XElement selectedNode ) : void	Handles insertion of object class element into worksheet. TODO: Refactor code
handleProp ( System.Xml.Linq.XElement selectedNode ) : void
use ( object sender, EventArgs e ) : void
useCLS ( object sender, EventArgs e ) : void

Method	Description
InitializeComponent ( ) : void	Required method for Designer support - do not modify the contents of this method with the code editor.
createCDEList ( ) : void
createConceptList ( ) : void
createList ( Microsoft.Office.Interop.Excel sheet, string name ) : Microsoft.Office.Interop.Excel.Worksheet
createOCList ( ) : Microsoft.Office.Interop.Excel.Worksheet
isCDEListExists ( ) : bool
isConceptListExists ( ) : bool
isOCListExists ( ) : bool
useList ( Microsoft.Office.Interop.Excel sheet, string name ) : Microsoft.Office.Interop.Excel.Worksheet

Clean up any resources being used.

protected Dispose ( bool disposing ) : void
disposing	bool	true if managed resources should be disposed; otherwise, false.
return	void

protected getSelectedRangeAddress ( Microsoft.Office.Interop.Excel r ) : string
r	Microsoft.Office.Interop.Excel
return	string

Applying CDE to selected cell/range with validation based on value domain of data element, and XmlMap for exporting XML data. TODO: Refactor code

protected handleCDE ( System.Xml.Linq.XElement selectedNode ) : void
selectedNode	System.Xml.Linq.XElement	Data element to use
return	void

Handles insertion of concept element into worksheet. TODO: Refactor code TODO: Is two way hyperlink possible?

protected handleConcept ( System.Xml.Linq.XElement selectedNode ) : void
selectedNode	System.Xml.Linq.XElement	Concept element to use
return	void

Handles insertion of object class element into worksheet. TODO: Refactor code

protected handleOC ( System.Xml.Linq.XElement selectedNode ) : void
selectedNode	System.Xml.Linq.XElement	Object Class element to use
return	void

protected handleProp ( System.Xml.Linq.XElement selectedNode ) : void
selectedNode	System.Xml.Linq.XElement
return	void

protected use ( object sender, EventArgs e ) : void
sender	object
e	System.EventArgs
return	void

protected useCLS ( object sender, EventArgs e ) : void
sender	object
e	System.EventArgs
return	void