Forum Engagement Daily Reports

[system]

Daily Forum Report | 14 November 2023

Top 3 Topics with Most Views

Excelファイルの列や行を非表示にしたい made by @Yamasakia with 72 views.

DataTable segrgation made by @Akash_Javalekar1 with 53 views.

「アセット値を取得」アクティビティについて made by @chiharu-kikuchi with 44 views.

Top 3 Topics with Most Replies

Reading pdfs very slow made by @cemenike with 18 replies.

Assign all of the row in one assign made by @omar_ismail with 12 replies.

DataTable segrgation made by @Akash_Javalekar1 with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 30 posts!

@postwick made 17 posts!

@Nguyen_Van_Luong1 made 14 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Excelファイルの列や行を非表示にしたい

こんにちは 例えばClosedXMLなら以下になります。 [image] Using wb As New ClosedXML.Excel.XLWorkbook(filename) Dim ws As ClosedXML.Excel.IXLWorksheet = wb.Worksheet(sheetName) ws.Rows(3,4).Hide() ws.Columns("C:D").Hide() wb.Save() End Using Sample Sample20231114-4L.zip (8.6 KB)

This post made by @Nguyen_Van_Luong1 received 2 likes!

Excelファイルの列や行を非表示にしたい

こんにちは。 You can use activity in this package [image] Or try Invode VB code [Hide Columns in UiPath | Hide Multiple Excel Columns in UiPath] Hope it help!

This post made by @Yoichi received 2 likes!

How can I convert "Nov" to "November" for any month?

Hi, How about the following expression? DateTime.ParseExact(yourString,"MMM",System.Globalization.CultureInfo.InvariantCulture).ToString("MMMM") [image] Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Excelファイルの列や行を非表示にしたい

こんにちは 例えばClosedXMLなら以下になります。 [image] Using wb As New ClosedXML.Excel.XLWorkbook(filename) Dim ws As ClosedXML.Excel.IXLWorksheet = wb.Worksheet(sheetName) ws.Rows(3,4).Hide() ws.Columns("C:D").Hide() wb.Save() End Using Sample Sample20231114-4L.zip (8.6 KB)

This solution provided by @Yoichi received 2 likes!

How can I convert "Nov" to "November" for any month?

Hi, How about the following expression? DateTime.ParseExact(yourString,"MMM",System.Globalization.CultureInfo.InvariantCulture).ToString("MMMM") [image] Regards,

This solution provided by @marian.platonov received 1 likes!

Could not load file or assembly ‘UiPath.IntelligentOCR, Version=6.14.1.0, Culture=neutral, PublicKeyToken=null’. The system cannot find the file specified

Updating the UiPath.IntelligentOCR.Activities also requires an update for the UiPath.UIAutomation.Activities pack and for UiPath.OCR.Activities pack if included in the project. UiPath.IntelligentOCR.Activities and UiPath.DocumentUnderstanding.Activities should not be used together in the same project. Reference: Activities - About the IntelligentOCR Activities Package

---

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.