ExcelTableConverter Methods |
The ExcelTableConverter type exposes the following members.
Name | Description | |
---|---|---|
ExcelFile2TableAttrValues |
Reads an Excel file and produces a table-compatible DataTable object. Since
transaction boundaries should not be fixed by a helper method and we do not
want to tinker around with the OLE DB Excel driver within an ice.NET
transaction this methods does not update the table object itself. Instead
we can easily update the object's table attributes with the
IObject.SetTableAttrValues method family.
| |
TableAttrValues2ExcelFile |
Produces Excel file from table object. This method fails if the table
object has no table-style attributes.
If there are no rows so far, the method produces an Excel
file with appropriate column headers./// |