Get Dynamic Cell | Paste Data Dynamically |Append Range | (Excel Automation UiPath)| Scenarios | RPA

[@khaledbinjameel9639]

What a brilliant video

[@MukeshKala]

Thank you for the comment 😊

[@AnilKumar-mo3pr]

Thanks for the video. Great way to solve the append range issue.

[@MukeshKala]

Thank you 😊

[@gagansingh3481]

Sir if we have multiple sheets in workbook say sheet 1, sheet 2, sheet 3 ,sheet 4 ..... then how we can append

[@MukeshKala]

1. Add all the sheets Name in a List or Array.
2. Loop the Sheets name using for each
3. Inside the for each - add the logic to append.

[@getkarthin]

Brilliant

[@MukeshKala]

Thank you Karthik

[@veehamoolky4894]

how to append data in single row.
I have DT which already have 4 columns and i want to append next 4 columns to same row (different col name) with their respective values

[@MukeshKala]

This you need to do by taking the count of rows and columns of dataTable

[@dimasismu5738]

can you teach how to make success report of the process

[@MukeshKala]

Hi, when we say success report - Does it mean the status of a Process run from orchestrator or the status of the transactions in a particular Run ?

[@dimasismu5738]

@@MukeshKala : sorry, I mean the status of the transaction

[@MukeshKala]

We already have an export option available in Orchestrator. How different it would be ... I think i am not getting the requirement clearly - Why don't you write me an email - Lets discuss over there and you can send me some screenshots as well.

[@maheshbaraskar4565]

sir how to create multiple sheets one bye one in excel file with the name which we want.

[@MukeshKala]

Use Write Range Activity and in the Sheet Name - Provide Name of Your Choice

[@maheshbaraskar4565]

@@MukeshKala ok

[@sanjaykarthik2793]

Sir, what is the syntax and use of datatable variable.CLONE

[@MukeshKala]

Clone creates a new DataTable with the same structure as the original DataTable, but does not copy any data
To use -
DataTable newTable = originalTable.Clone()

[@sowmyarani6447]

How to get first and last column value of excel dynamically

[@MukeshKala]

1. Take Read Column and Specify the Cell as "A1" for First Column.
2. For the Last Column_ Read the Complete Data in DataTable - Get the Count of Columns - Convert that to an Alphabet - That would be your Last Column -
Say total 5 Columns then (Last Column will be F1) : Where Index start with Zero in datatable
th-cam.com/video/S-l5dbibHFw/w-d-xo.html

[@sowmyarani6447]

@@MukeshKala thank you very much for the reply

[@sowmyarani6447]

@@MukeshKala this video doesnot show how to get last row value dynamically from Excel I want to get only last row value data dynamically

[@MukeshKala]

To Get the last Row -
1. Read the Entire Data - let say you excel have 100 Records
2.So the Datatable will have 100 Rows
3. Take the count of Datatable using dt.rows.count ... This will give u 100
4. Now Substract 1 from it to get the last Row..
5. Use dt((dt.rows.count -1),0).toString : Here 0 means we are reading the last row - First Column
6. To get the Complete row - use getRow activity and in the Row specify (dt.rows.count -1)
How read row works - th-cam.com/video/S-l5dbibHFw/w-d-xo.html

[@thegame9551]

Thank GOD =/\=

[@MukeshKala]

🤩