Forum Engagement Daily Reports

[system]

Daily Forum Report | 18 September 2021

Top 3 Topics with Most Views

CSVデータの保存 made by @kksb.0141 with 42 views.

Mathes Emails with certain domen made by @YoungFave with 41 views.

Error opening workbook. If Excel is installed, run the ‘Repair Tool for Microsoft Office Interop’ from the Tools tab on the Home screen made by @13051156620 with 36 views.

Top 3 Topics with Most Replies

CSVデータの保存 made by @kksb.0141 with 10 replies.

Find these files using reference made by @Luan_Carvalho_Da_Conceica with 7 replies.

Why does the input box become inactive in a loop? made by @Dguam with 7 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 24 posts!

@ppr made 10 posts!

@Pradeep.Robot made 9 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 1 likes!

Error opening workbook. If Excel is installed, run the ‘Repair Tool for Microsoft Office Interop’ from the Tools tab on the Home screen

Hi Did we try with WORKBOOK activities Search as workbook in activity panel and try with READ RANGE under that This doesn’t require excel to be installed So it will work in all scenarios Hope this would help you resolve this Cheers @13051156620

This post made by @13051156620 received 1 likes!

Error opening workbook. If Excel is installed, run the ‘Repair Tool for Microsoft Office Interop’ from the Tools tab on the Home screen

@Palaniyappan Thanks for the response, I tried WORKBOOK->Read Range,it worked well at develop machine. I’ll come back after dempolay the problem on the formal environment. runas /user:adminstrator works fine on my computer,I guess it’s an environment problem with the administrator account. Best wishes

This post made by @13051156620 received 1 likes!

Error opening workbook. If Excel is installed, run the ‘Repair Tool for Microsoft Office Interop’ from the Tools tab on the Home screen

Hi, It solved my problem. Cheers

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 1 likes!

How to loop multiple rows

Hi Hope these steps would help you resolve this Use a FOR EACH ROW loop and pass the dt variable as input Inside the loop use a assign activity like This Counter = 0 Where counter is a variable of type int32 with default value as 0 created in variable panel Followed by this assign use a WHILE LOOP inside the loop and pass the condition like this counter < dt.Columns.Count Inside this while loop use a TYPE INTO Activity like this with the inlut dt.Rows(dt.Rows.IndexOf(row))(co…

This solution provided by @Yoichi received 1 likes!

データテーブルを検索して見つかった行を取り出す方法

こんにちは 数値と文字列がそれぞれ異なる列にあるなら、 DataRowを抽出したければ dr = dt.AsEnumerable.OrderBy(Function(r) Decimal.Parse(r("数値列").ToString())).First() 新しい(1行だけの)DataTableとして扱いたければ newDt ={dt.AsEnumerable.OrderBy(Function(r) Decimal.Parse(r("数値列").ToString())).First()}.CopyToDataTable() あたりを試してもらえればと思います。

This solution provided by @aanandsanraj received 1 likes!

Mathes Emails with certain domen

@YoungFave Try this regex [A-Za-z0-9._%+-]+@yandex.ru

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.