Forum Engagement Daily Reports

[system]

Daily Forum Report | 19 October 2022

Top 3 Topics with Most Views

Convert String made by @Sandhya_Gajare with 47 views.

How to convert secure string to string in uipath made by @shankar.arekonda.external with 45 views.

https://forum.uipath.com/t/482473 made by @Suggala_Tejaswi with 45 views.

Top 3 Topics with Most Replies

Convert String made by @Sandhya_Gajare with 30 replies.

How to convert secure string to string in uipath made by @shankar.arekonda.external with 23 replies.

How to import Packages in uipath made by @divya.17290 with 20 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 65 posts!

@Sudharsan_Ka made 41 posts!

@supermanPunch made 24 posts!

Top 3 Most Liked Posts

This post made by @supermanPunch received 4 likes!

How to read excel

Hi @divya.17290 , Could you try with the Steps below : Read the Data from Excel using Read Range Activity, Get the Output as Datatable. Next, We use Look Up Datatable Activity to get the Index of the row and value of CPT for the matching Claim Number. Next, We can use Skip and Take Linq methods to get the rows we need and then select the CPT Values with the help of below Linq : cptValues = {cptValue}.Concat(DT.AsEnumerable.Skip(rowIndex+1).TakeWhile(Function(x)String.IsNullOrWhiteSp…

This post made by @Yoichi received 2 likes!

Excelファイルパスの一部に変数を使用したい

こんにちは 入力ダイアログからの文字列変数をvarInputとすると "C:\Users\"+varInput+"\OneDrive - jjjj\デスクトップ\フォーマット.xlsx" または System.IO.Path.Combine("C:\Users",varInput,"OneDrive - jjjj\デスクトップ\フォーマット.xlsx") をお試しいただければと思います。

This post made by @Gokul001 received 2 likes!

Convert String

Hi @Sandhya_Gajare Assign activity ReverseStr = strName.ToString.Split(" "c)(1)+","+strName.ToString.Split(" "c)(0) If activity ReverseStr.Contains(ExcelName) Check out the screenshot [image]

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 4 likes!

How to read excel

Hi @divya.17290 , Could you try with the Steps below : Read the Data from Excel using Read Range Activity, Get the Output as Datatable. Next, We use Look Up Datatable Activity to get the Index of the row and value of CPT for the matching Claim Number. Next, We can use Skip and Take Linq methods to get the rows we need and then select the CPT Values with the help of below Linq : cptValues = {cptValue}.Concat(DT.AsEnumerable.Skip(rowIndex+1).TakeWhile(Function(x)String.IsNullOrWhiteSp…

This solution provided by @Yoichi received 2 likes!

Excelファイルパスの一部に変数を使用したい

こんにちは 入力ダイアログからの文字列変数をvarInputとすると "C:\Users\"+varInput+"\OneDrive - jjjj\デスクトップ\フォーマット.xlsx" または System.IO.Path.Combine("C:\Users",varInput,"OneDrive - jjjj\デスクトップ\フォーマット.xlsx") をお試しいただければと思います。

This solution provided by @Gokul001 received 2 likes!

Convert String

Hi @Sandhya_Gajare Assign activity ReverseStr = strName.ToString.Split(" "c)(1)+","+strName.ToString.Split(" "c)(0) If activity ReverseStr.Contains(ExcelName) Check out the screenshot [image]

---

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.