Build Datatableアクティビティでヘッダ（列名）が作成できません

日本 フォーラム
1

こんにちは
UiPath Studio 2024.10.4Community editionのユーザです。

奇妙なことが起きたので事実関係を確認させてください。

1.Build Datatableアクティビティでdtを作成しました。（添付画像のとおり列名"TimeSpan"を作成しています）

The image shows a data table configuration window in a Japanese version of a software, with an action to read values from an Excel file in a specified range. (Captioned by AI)
The image shows a data table configuration window in a Japanese version of a software, with an action to read values from an Excel file in a specified range. (Captioned by AI)652×504 20 KB

2.Read Range(Workbook)アクティビティでヘッダを追加をクリックして、
The image shows the properties window of the UiPath Excel Read Range activity with the "Add Headers" checkbox checked. (Captioned by AI)

Excelからdtにデータを取得しましたが、ローカルパネルで見たら列名"TimeSpan"がdtの中に表示されていません。
The image shows a list of time values in a text editor, with a header in Japanese that reads "ローカル値" (Local Values). (Captioned by AI)

どうしてでしょうか？

2

Hi @gorby

Can you show the screenshot of workflow and no need to use below row delete that

The image shows a step in a workflow where a DataTable named "dt" is being constructed, and an Excel range is being read into it, with a column labeled "TimeSpan (String)" and a row cell containing the text "text." (Captioned by AI)
The image shows a step in a workflow where a DataTable named "dt" is being constructed, and an Excel range is being read into it, with a column labeled "TimeSpan (String)" and a row cell containing the text "text." (Captioned by AI)829×641 58.8 KB

Regards,

3

こんにちは

ReadRangeアクティビティは、DataTableのインスタンスを新規に出力しますので、従前に設定したDataTableの内容は反映されません。

そのため動作としては正常です。

4

@gorby,

Add header will add column name from excel file.

If you want custom column name of the datatable, try this approach.

  1. Don’t use build datatable.
  2. Use read range activity with Add header unchecked. This will create datatable with default column name like Column1
  3. Change the column name in Assign activity.
    yourDT.Columns(0).ColumnName = "New Column Name"

Thanks,
Ashok :slightly_smiling_face:

5

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