Forum Engagement Daily Reports

[system]

Daily Forum Report | 06 July 2021

Top 3 Topics with Most Views

How to Filter Date Column with #N/A Value made by @surya_teja.k with 49 views.

Index was outside the bounds of array-URGENT made by @mitul_choudhary with 43 views.

How to write data in Excel file without overwriting? made by @1000_Yukino with 42 views.

Top 3 Topics with Most Replies

How to write data in Excel file without overwriting? made by @1000_Yukino with 27 replies.

Index was outside the bounds of array-URGENT made by @mitul_choudhary with 19 replies.

Input string was not in a correct format-Urgent made by @mitul_choudhary with 18 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 23 posts!

@kumar.varun2 made 17 posts!

@prasath17 made 16 posts!

Top 3 Most Liked Posts

This post made by @Max_Herrera received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi everyone, I’m Maximiliano, I have more than two years of developing automation with different tools, recently I started learning UI Path and I think is a great application for automation. Best regards!!!

This post made by @prasath17 received 2 likes!

Check for empty cell in a datatable

@TyraS - Please try this… (From d in dtData.AsEnumerable Let check = d.ItemArray.Any(Function (x) isNothing(x) OrElse String.IsNullOrEmpty(x.toString.trim)) Select check).Any(Function (e) e) Assign the above statement to Boolean variable…

This post made by @ryoko received 2 likes!

Excelにウェブサイトの情報を入力する方法

いらせられませ、ようこそForumへ Webから読み込む情報の項目が決まっているのであれば、 情報.xlsxで読み込んだデータテーブルに追加で入れるのではなく、 Web情報は新規データテーブルに格納し、Excelに追記の方が良いかも？ 以下は情報.xlsxがA1から始まるデータで、ヘッダーが1行の例です。 情報.xlsxから読み込んだデータテーブルを読み込む…データテーブルA ⇒行数取得用。 『データ テーブルを構築』Activityで情報.xlsxと同ヘッダーの新規データテーブルを作成…データテーブルB Webから取得した情報をデータテーブルBに格納 『範囲に書き込み』の開始セルに、列アルファベット+データテーブルAの行数+2を設定。『ヘッダーを追加』はチェックしない。 ⇒例：“A”+(データテーブルA.rows.count+2).tostring ※+2は、ヘッダー1行と最終行オフセット1行の合計 多分これで行けるかと思うのですが、どうでしょ？

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

Check for empty cell in a datatable

@TyraS - Please try this… (From d in dtData.AsEnumerable Let check = d.ItemArray.Any(Function (x) isNothing(x) OrElse String.IsNullOrEmpty(x.toString.trim)) Select check).Any(Function (e) e) Assign the above statement to Boolean variable…

This solution provided by @manjula_rajendran received 1 likes!

Issue with Vm with unattended Bot

Hi @Tharusha.fernando , if it is a browser stuff, don’t need to worry. Complete your workflow. Set the Bot and set the scheduler for running. It will work on your VM. Note: If you are using Active Accessibility to scrape the data then it may not work if your screen is not enabled. Handle the situation in Try Catch. Thanks, Manjula

This solution provided by @kumar.varun2 received 1 likes!

Input string was not in a correct format-Urgent

CInt(((CDbl(If(drInvoiceMain.Item("IGST Amount").ToString.Equals(""), "0", drInvoiceMain.Item("IGST Amount").ToString))+CDbl(If(drInvoiceMain.Item("SGST / UT GST Amount").ToString.Equals(""), "0", drInvoiceMain.Item("SGST / UT GST Amount").ToString))+CDbl(If(drInvoiceMain.Item("CGST Amount").ToString.Equals(""), "0", drInvoiceMain.Item("CGST Amount").ToString)))/CDbl(drInvoiceMain.Item("Taxable Value").ToString))*100)=CInt(If(drInvoiceMain.Item("GST Rate").ToString.Equals(""), "0", drInvoiceMain…

---

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.