C# Class SQLServerForExcel_Addin.Extensions.WorksheetExtensions

Datei anzeigen Open project: Pietervdw/SQLForExcel

Public Methods

Method	Description
AddChangedRow ( this sheet, Microsoft.Office.Interop.Excel changedRange ) : void
AddChangedRow ( this sheet, int col, int row ) : void
AddProperty ( this sheet, string propertyName, object propertyValue ) : Microsoft.Office.Interop.Excel.CustomProperty
ChangesToSql ( this sheet, string tableName, string primaryKeyName ) : string
ColumnName ( this sheet, int col ) : string
ConnectedToDb ( this sheet ) : bool	Checks whether the sheet has a primary key custom property and then return true or false indicating it is "connected" to a db table
GetProperty ( this sheet, string propertyName ) : Microsoft.Office.Interop.Excel.CustomProperty
PrimaryKey ( this sheet ) : string

Private Methods

Method	Description
ColumnIndexToColumnLetter ( int colIndex ) : string
ToSafeXml ( string xmlString ) : string
stripNonValidXMLCharacters ( string textIn ) : String

Method Details

AddChangedRow() public static method

public static AddChangedRow ( this sheet, Microsoft.Office.Interop.Excel changedRange ) : void
sheet	this
changedRange	Microsoft.Office.Interop.Excel
return	void

AddChangedRow() public static method

public static AddChangedRow ( this sheet, int col, int row ) : void
sheet	this
col	int
row	int
return	void

AddProperty() public static method

public static AddProperty ( this sheet, string propertyName, object propertyValue ) : Microsoft.Office.Interop.Excel.CustomProperty
sheet	this
propertyName	string
propertyValue	object
return	Microsoft.Office.Interop.Excel.CustomProperty

ChangesToSql() public static method

public static ChangesToSql ( this sheet, string tableName, string primaryKeyName ) : string
sheet	this
tableName	string
primaryKeyName	string
return	string

ColumnName() public static method

public static ColumnName ( this sheet, int col ) : string
sheet	this
col	int
return	string

ConnectedToDb() public static method

Checks whether the sheet has a primary key custom property and then return true or false indicating it is "connected" to a db table

public static ConnectedToDb ( this sheet ) : bool
sheet	this
return	bool

GetProperty() public static method

public static GetProperty ( this sheet, string propertyName ) : Microsoft.Office.Interop.Excel.CustomProperty
sheet	this
propertyName	string
return	Microsoft.Office.Interop.Excel.CustomProperty

PrimaryKey() public static method

public static PrimaryKey ( this sheet ) : string
sheet	this
return	string