Table content control allows listing multiple records. This content control also allows importing data from an excel file and exporting its content as an excel file. See below for details.
Design
Add New Label
Specifies a name for Add New button. This button adds new row to table content.
...
Filter XPath
By using Filter Xpath, it is possible to refine the content of the table. For this example, only the rows where IsCustomer node is set to true, will be displayed.
Import from Excel Anchor import-excel import-excel
This control allows you to import data from an excel file into itself. In order to accomplish this, all you have to do is, enable AllowImport in DataExchange and define the columns in this property.
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
<DataExchange AllowImport="True" AllowExport="False">
<Columns>
<Column Caption="Form No" Type="Text">
<XPath><![CDATA[FormNo]]></XPath>
</Column>
<Column Caption="Owner" Type="Text">
<XPath><![CDATA[Owner]]></XPath>
</Column>
<Column Caption="Date" Type="DateTime">
<XPath><![CDATA[FormDate]]></XPath>
</Column>
</Columns>
</DataExchange> |
Export to Excel Anchor export-excel export-excel
This control allows you to export your records to excel. In order to accomplish this, all you have to do is, enable AllowExport in DataExchange and define the columns in this property.
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
<DataExchange AllowImport="False" AllowExport="True">
<Columns>
<Column Caption="Form No" Type="Text">
<XPath><![CDATA[FormNo]]></XPath>
</Column>
<Column Caption="Owner" Type="Text">
<XPath><![CDATA[Owner]]></XPath>
</Column>
<Column Caption="Date" Type="DateTime">
<XPath><![CDATA[FormDate]]></XPath>
</Column>
</Columns>
</DataExchange> |
Sort XPath
Sorts rows with respect to given XPath.
Assume you have a node named Number above each item of a table content. Entering "Number" into Sort XPath would sort the items according to the character value of Number node. If you want to sort items according to numeric value of Number node, use number function as "number(Number)".
...