Forum Engagement Daily Reports

[system]

Daily Forum Report | 28 June 2023

Top 3 Topics with Most Views

I have to remove the unnecessary data from variable value made by @vinjam_likitha with 43 views.

Safely Close Excel Workbook made by @elliot.barling with 42 views.

How to extract table contain 15000 record and write in excel sheet made by @Abdalla with 41 views.

Top 3 Topics with Most Replies

How to extract table contain 15000 record and write in excel sheet made by @Abdalla with 18 replies.

How to set the input field empty before typing values made by @raju_alakuntla with 16 replies.

Use Application/Browser Activity Error after Studio Upgrade to 2023.6 Release made by @saurabh.goswami1 with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 37 posts!

@Yoichi made 33 posts!

@postwick made 32 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

"Expression Activity type 'VisualBasicValue`1' requires compilation in order to run" after attempt to add new column in Excel file

please check the following: the variable monthyear has a default value: today.ToString(“MMMyy”) please retype the default value and ensure that the double quotes are of type: " and not inverted

This post made by @mkankatala received 1 likes!

Automate excel web version

Hi @manasdas6224 If Your questions is How can automate the excel automation in UiPath web? In UiPath web there is no option to read the excel by using read range workbook. There is no read range workbook activity in UiPath web. You can read the google sheets in UiPath web. The UiPath web is only integrated with the cloud Google and microsoft only. Check the below attached image. [image] Hope it helps!!

This post made by @sangeethaneelavannan1 received 1 likes!

How to get the date from the below text

It worked .thanks

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

"Expression Activity type 'VisualBasicValue`1' requires compilation in order to run" after attempt to add new column in Excel file

please check the following: the variable monthyear has a default value: today.ToString(“MMMyy”) please retype the default value and ensure that the double quotes are of type: " and not inverted

This solution provided by @pravallikapaluri received 1 likes!

How to copy data from specific cell to another in Excel

Hi @mironb Excel Application Scope WorkbookPath: [Path to Excel file] Read Cell SheetName: “Sheet1” Cell: “A1” Output: cellValue Write Cell SheetName: “Sheet2” Cell: “B2” Value: cellValue End Excel Application Scope Hope it helps!!

This solution provided by @argin.lerit received 1 likes!

Inyección JavaScript

@camilo_gonzalez - Puedes tratar este código: "function(e, disponible){ let newVal = document.getElementsByClassName('string-cell editable renderable'); newVal[0]['innerHTML']=disponible; }" Y en el parameter InputParameter de la Actividad, pone la variable que contiene el valor de disponible en el código JS como asi: [image] Espero que esto es útil para ti

---

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.