Forum Engagement Daily Reports

[system]

Daily Forum Report | 03 June 2022

Top 3 Topics with Most Views

In excel application scope can i read 2 sheets and add them to array and do for each? made by @MitheshBolla with 43 views.

UiPath実行後、起動中のExcelファイルが行方不明になる made by @1111217 with 41 views.

Convert Dic <String, Datatable> to Dic <Of String, String> made by @wonderingnoname with 40 views.

Top 3 Topics with Most Replies

Update notepad according to date made by @anmita with 18 replies.

Work days, Weekends and Controlling of Holidays? made by @yigit.aybey with 18 replies.

In excel application scope can i read 2 sheets and add them to array and do for each? made by @MitheshBolla with 16 replies.

Top 3 Users Who Posted The Most

@postwick made 31 posts!

@Lak_Ui made 24 posts!

@Rahul_Unnikrishnan made 23 posts!

Top 3 Most Liked Posts

This post made by @Nitya1 received 3 likes!
https://forum.uipath.com/t/445232/1

This post made by @aeb-dev received 2 likes!

Publishing a package from Studio to GitHub Packages

When I try to publish a package from Studio to GitHub Packages I get the following error: [image] The logs for the above error is also like this: 09:30:50.1874 => [WARN] [UiPath.Studio] [30] No destination repository detected. Ensure the source project has a 'RepositoryUrl' property defined. If you're using a nuspec file, ensure that it has a repository element with the required 'type' and 'url' attributes. 09:30:50.1928 => [ERROR] [UiPath.Studio.App.Logging.OutputLogger] [30] Error: Response…

This post made by @Yoichi received 2 likes!

UiPath実行後、起動中のExcelファイルが行方不明になる

こんにちは 詳細な状況はよくわかりませんが、Excel Application Scopeはプロセスの管理が弱いので 可能であればモダンExcelのExcel Process Scopeを用いて、UiPathが扱うEXCELは別プロセスで 立ち上げでコントロールしたほうが良いように思えます。（プロセスモードを新規作成にすると新しいEXCELのプロセスが起動し、スコープを抜けるとそのプロセスだけが終了します。）

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

UiPath実行後、起動中のExcelファイルが行方不明になる

こんにちは 詳細な状況はよくわかりませんが、Excel Application Scopeはプロセスの管理が弱いので 可能であればモダンExcelのExcel Process Scopeを用いて、UiPathが扱うEXCELは別プロセスで 立ち上げでコントロールしたほうが良いように思えます。（プロセスモードを新規作成にすると新しいEXCELのプロセスが起動し、スコープを抜けるとそのプロセスだけが終了します。）

This solution provided by @jack.chan received 1 likes!

Convert String data into column and write into Data table

refer to this d.xaml (10.8 KB) steps read file to txt (string variable) (file = Ram K Singh 99084544 00-00989878 Satish Kumar 562459504 00-00989879 Manoj P Rajan 562459504 00-00989880) [image] loop over each line of txt a) use regex to assign Name/Lob-id/Location-id to newRow (datarow variable) b) add newRow to datatable [image] result [image]

This solution provided by @supermanPunch received 1 likes!

Help with HTML mail

Hi @NightWing03 , You do not require an Invoke Code Activity to replace the value. You could use String Replace Activity. As the excel is a config file, I would guess it is already being read into a Dictionary variable Config. You could use this variable to access the HTML_Code value like below : Config("HTML_Code").ToString For Replacing the values in the HTML_Code, you could do the below : Config("HTML_Code").ToString.Replace("ExcelName","ValueToReplace") Let us know what is your implem…

---

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.