Syntax
| JScript | |
|---|---|
public interface IExcelFileConnection | |
Public Properties
| Name | Description | |
|---|---|---|
 | ColCount | Returns the number of columns. |
| Columns | Gets the columns. |
| Count | Gets the count. |
| CurrentTable | Gets the current table. |
| ErrantColumnName | Gets or sets the errant column to check for a value. |
| FileName | Gets the name of the file. |
| HasDuplicates | Gets a value indicating whether this instance has duplicates. |
| HasHeader | Gets a value indicating whether this instance has header. |
| HeaderRow | Gets the header row. |
| HightlightErrantRow | Gets or sets whether to hightlight errant rows. |
| ImportType | Gets the type of the import. |
Public Methods
| Name | Description | |
|---|---|---|
 | AddRow | Adds the row. |
| AutoFitColumnWidth | Auto fit column with for the file. |
| Cells | Gets the cell value directly, ignoring column headings. |
| DeleteMarkedRows | Deletes the marked rows. |
| DeleteSheet | Deletes the sheet. |
| GetCellValueAsDate | Overloaded. Gets the cell value as date. |
| GetCellValueAsDecimal | Overloaded. Gets the cell value as decimal. |
| GetCellValueAsInt | Overloaded. Gets the cell value as int. |
| GetCellValueAsString | Overloaded. Gets the cell value as string. |
| GetNormolizedColumnsIndexes | Gets the normolized columns indexes. |
| GetTables | Gets the tables. |
| MarkRowForDeletion | Marks the row for deletion. |
| Save | Overloaded. Saves this instance. |
| SelectFirstSheet | Selects the first sheet. |
| SetCellValue | Overloaded. Sets the cell value. |
| SetCurrentTable | Sets the current table. |
| UpdateSheet | Overloaded. Updates the sheet. |
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family