Click or drag to resize

ExcelTableConverterExcelFile2TableAttrValues Method

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.

Namespace:  PDTec.IceNet.Sdk.Utils
Assembly:  PDTec.IceNet.Sdk (in PDTec.IceNet.Sdk.dll) Version: 7.2.0.0 (7.2.7583.15464)
Syntax
C#
public static List<AttrValue[]> ExcelFile2TableAttrValues(
	IObject pTable,
	string fileName
)

Parameters

pTable
Type: PDTec.IceNet.Core.ModelIObject
The object.
fileName
Type: SystemString
The Excel file name.

Return Value

Type: ListAttrValue
A list of attribute rows that contains the Excel data.
See Also