| ExcelTableConverter Class |
Convert ice.NET table object data from and to Excel files. These
methods use the OLE DB Excel driver and have to deal with its
limitations regarding data type detection.
Recommendation: Always use the TableAttrValues2ExcelFile method to produce a template before inserting data and updating the ice.NET object.
Recommendation: Always use the TableAttrValues2ExcelFile method to produce a template before inserting data and updating the ice.NET object.
Inheritance HierarchyNamespace: PDTec.IceNet.Sdk.Utils
Assembly: PDTec.IceNet.Sdk (in PDTec.IceNet.Sdk.dll) Version: 6.0.0.0 (6.0.6225.27214)
SyntaxC#
public static class ExcelTableConverter
The ExcelTableConverter type exposes the following members.
Methods| 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./// |
See Also