dtをExcelのA2セルに貼り付ける際に、各行の先頭1文字を削除したい

日本 フォーラム
1

こんにちは
UiPath Studio 2022.4.3EnterPrise Editionユーザです。

１．やりたいこと

NExtractDataアクティビティで、Webサイトから下記のdtを取得しました。（データは加工しています）
このdtをExcelのA2セルにWritrRangeXアクティビティで貼り付けたい。

[項目番号,申込番号1,申込番号2,契約名義(カナ)
,700000009999999,080,3226,1899,携,
,700000009999984,03,3222,4494,
,700000001522222,090,8223,4023,
,700000001502222,070,9222,2171,
,700000001522232,090,3222,7865,
]

２．悩んでいること

dtをExcelのA2セルに貼り付ける際に、各行の先頭1文字を削除したあとに貼り付けたいです。どうすればよいでしょうか。
Invoke Codeでも構いません。

2

@gorby,

Use Remove Data Column activity to remove the first column and then use Write Range to write the dt as below.

The image shows a UiPath workflow where a data column is removed from a DataTable and then written to an Excel file "Test.xlsx" starting from cell "A2" in "Sheet1", with the option to add headers unchecked. (Captioned by AI)
The image shows a UiPath workflow where a data column is removed from a DataTable and then written to an Excel file "Test.xlsx" starting from cell "A2" in "Sheet1", with the option to add headers unchecked. (Captioned by AI)1281×502 53.5 KB

Thanks,
Ashok

3

No, you misunderstood my intention.
I meant “I want to remove the first letter from each row.” like,

{abcdef,ghijk,lmn}
↓
{bcdef,ghijk,lmn}

However, it is not necessary for me to know your answer, because I solved this problem from different point of view.

Cheers,
gorby

1 Like
4

@gorby A recommendation, in case you are using For Each.
You can avoid the loope and use → Data table Columns Expressions. These expressions eliminate the need for loops by automatically updating the values of all rows.
Example:
myDataColumn.Expression = “SUBSTRING(phone, 2, LEN(phone) - 1)”

System.Data.DataColumn.Expression property - .NET | Microsoft Learn