Data Table To Text

Returns a string representation of a datatable on the specified text format (HTML, JSON or XML).

Properties

Name	Description	Required
Data Table	The DataTable.	☑️
Date Time Format	The date format to be used on the string representation for DateTime types.
Output Format	The output text format.	☑️
Result	The string representation of the DataTable.

Outputs

Considering the following DataTable:

Name	Value
A	1
B	2
C	3

These are the results for each Output Format selected.

HTML

<table>
 <thead>
  <tr>
   <th>Name</th>
   <th>Value</th>
  </tr>
 </thead>
 <tbody>
  <tr>
   <td>A</td>
   <td>1</td>
  </tr>
  <tr>
   <td>B</td>
   <td>2</td>
  </tr>
  <tr>
   <td>C</td>
   <td>3</td>
  </tr>
 </tbody>
</table>

JSON

[{"Name":"A","Value":1},{"Name":"B","Value":2},{"Name":"C","Value":3}]

XML

<DocumentElement>
 <DataTable>
  <Name>A</Name>
  <Value>1</Value>
 </DataTable>
 <DataTable>
  <Name>B</Name>
  <Value>2</Value>
 </DataTable>
 <DataTable>
  <Name>C</Name>
  <Value>3</Value>
 </DataTable>
</DocumentElement>