I want to display a DataTable with column names in an Excel-like format in a StudioX legacy project

Japan Forum
1

Hello
I’m using StudioX 2024.10.14 LTS. This is a legacy project.

  1. What I want to do

I would like to display a data table in an Excel-like format, including column names (the desired format is below).

TimeStamp        info      message
---------------------------------------
08:32:03.9802 Trace "good morning!"
08:32:16.9565 Trace "good afternoon!"
08:32:33.5805 Trace "good evening!"
08:32:46.5588 Trace "good night!"

I can output to the output panel using the WriteLine activity with:

String.Join(",",Row.ItemArray)

but the following does not work:

String.Join(",", dt.Columns.Cast(Of DataColumn).Select(Function(c) c.ColumnName)) + vbNewLine + String.Join(vbNewLine, dt.AsEnumerable.Select(Function(r) String.Join(",", r.ItemArray)))

If anyone has details, please let me know.

2

I solved it myself.
It looks like this configuration will work.

Untitled
Untitled438×448 10.8 KB