Forum Engagement Daily Reports

[system]

Daily Forum Report | 24 October 2021

Top 3 Topics with Most Views

Where we will use index in excel made by @Subha_Sundara_moorthi with 29 views.

Extracting specific rows from data table: "Source contains no data rows" made by @Westfield with 27 views.

Hello everyone, i a, stuck in situation where i want to write data to exel workbook in a from a datatable row by row in a specific column.I am shareing a screen shot of this format.I have to write data row in B2 and then C2 .......please help me otta this made by @Trinity_Piyush with 27 views.

Top 3 Topics with Most Replies

Can't find "excel application scope" activity made by @Bassel_Ali with 8 replies.

Error Handling with Try Catch with excel output message made by @Daffodil with 7 replies.

How to solve the HRESULT E_FAIL made by @Veera_Raj with 7 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 14 posts!

@rahulsharma made 13 posts!

@Yoichi made 12 posts!

Top 3 Most Liked Posts

This post made by @katara received 1 likes!

Info: How Excel PDF Exported Files Stores Table Data

thanks document.pdf (109.8 KB) phpmyadmin

This post made by @katara received 1 likes!

Create a Chatbot Using UiPath API Documentation and Tools like Snatch Bot and Integromat

thanks

This post made by @Palaniyappan received 1 likes!

Error Handling with Try Catch with excel output message

Fine Make sure these are correct Columns are correct in that case use column index like this CurrentRow(0) - for first column CurrentRow(1) - for second column @Daffodil As column index starts with 0 for first column This multi assign activity is inside FOR EACH ROW activity And finally Try upgrading your activity package to latest version Go to Design tab → Manage Packages-> project dependencies-> upgrade all the packages Cheers @

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Error Handling with Try Catch with excel output message

Hi, It’s because your 1st column name in your Excel sheet is "Username ". (Extra whitespace exists at the end of the string.) Please remove the extra space in your excel sheet or modify column name in your assign to "Username " In addition Password and Status also has extra space. So correct them as same way. Regards,

This solution provided by @Palaniyappan received 1 likes!

Removing the first row and first 2 columns from an excel file

Hi Hope the below steps would help you resolve this To read .xls file always use EXCEL activity where use a excel application scope and pass the file path as input Inside the scope use a READ RANGE activity and there mention the range like this “C2” and get the output as dt If you are facing issue again then try upgrading the excel package Go to Design tab → Manage Packages → Project Dependencies → Upgrade UiPath.Excel.Activities Now to remove that empty row use this activity Rem…

This solution provided by @lakshman received 1 likes!

How get the first month of the invoice date

@copy_writes Try below expression. Input = “10/24/2021” Output = "01/"+CDate("10/24/2021").ToString("dd/")+CDate("10/24/2021").ToString("yyyy")

---

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.