Writing Dataset.table to excel in specific format

Help Studio
1

This is the dataset.table(0)

image
image739×56 3.97 KB

I want to write it in this format in Excel

image

Thanks!

2

Hi @Sami_Rajput

Try using dataset.table(1)

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
4

@ppr

image
image1281×560 33.5 KB

getting this error

5

sorry had a typo. just refer to the fixed LINQ

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.