Query on Exporting 2D Table Content to Excel

[Durai26]

Is there a way to copy 2D table content in report section to excel in editable format? The 2D table uses various expressions to fetch values, including data from channels and custom properties

[TVHCDB]

Hello,

the 2d tables get their data from channels normally. You are able to export the channels to different file formats manually. There are *.csv and *.xlsx available. You have to choose the desired format. In the save dialog you can find an option to export only the selected channels.
If you like to do it by script you can record the export steps.

Here is an example which I recorded, while I exported some selected channels from the example project

Option Explicit 
Dim MyFolders()

Sub InitMyFolders
  ReDim MyFolders(1)
  MyFolders(0) = "C:\Users\Username\Documents\"
End Sub
Call InitMyFolders

'-------------------------------------------------------------------------------
Call DataFileSaveSel(MyFolders(0)&"Example.xlsx", "ExcelTdmExport", "'Raumtemperaturen/Temperatur_2', 'Raumtemperaturen/Temperatur_3'", True)

I hope that gives you an idea to solve your problem