Writing Dataset.table to excel in specific format

Help Studio
3

looks like you want to transform a DataTable with 1 row into a Key, Value Structure

Build DataTable Activity: - dtKVData

  • Col1: - Name: Key , DataType: String
  • Col2: - Name: Value, DataType: Object

Assign Activity
dtKVData =

(From d in dataset.table(0).AsEnumerable
From c in dataset.table(0).Columns.Cast(Of DataColumn)
let ra = new Object(){c.ColumnName, d(c.ColumnName)}
Select r = dtKVData.Rows.Add(ra)).CopyToDataTable
1 Like