메소드 | 설명 | |
---|---|---|
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 |
메소드 | 설명 | |
---|---|---|
ColumnIndexToColumnLetter ( int colIndex ) : string | ||
ToSafeXml ( string xmlString ) : string | ||
stripNonValidXMLCharacters ( string textIn ) : String |
public static AddChangedRow ( this sheet, Microsoft.Office.Interop.Excel changedRange ) : void | ||
sheet | this | |
changedRange | Microsoft.Office.Interop.Excel | |
리턴 | void |
public static AddChangedRow ( this sheet, int col, int row ) : void | ||
sheet | this | |
col | int | |
row | int | |
리턴 | void |
public static AddProperty ( this sheet, string propertyName, object propertyValue ) : Microsoft.Office.Interop.Excel.CustomProperty | ||
sheet | this | |
propertyName | string | |
propertyValue | object | |
리턴 | Microsoft.Office.Interop.Excel.CustomProperty |
public static ChangesToSql ( this sheet, string tableName, string primaryKeyName ) : string | ||
sheet | this | |
tableName | string | |
primaryKeyName | string | |
리턴 | string |
public static ColumnName ( this sheet, int col ) : string | ||
sheet | this | |
col | int | |
리턴 | string |
public static GetProperty ( this sheet, string propertyName ) : Microsoft.Office.Interop.Excel.CustomProperty | ||
sheet | this | |
propertyName | string | |
리턴 | Microsoft.Office.Interop.Excel.CustomProperty |