Update Excel File Column

[NISHITHA]

Hii Team,

We have Queue Items which contain User Brand , File Path Location ,Etc

So once the processing is done and we get a popup from Portal

Example: Status updation Completed (It could be any popup)

How do we add column named as Status in Row 6 in Column H ( if Not present already)
In the Excel File in following way

And it should update for that specific Row in which the User Brand row found matches queue Item UserBrand

User_Brand|Status
88966 |Status updation Completed

Attached Screenshot and File For Output Format Reference

Test Shipper 1 (1).xlsx (5.1 KB)

Thanks team in advance

[monsieurrahul (Rahul)]

Are you okay to edit the table and then perform a write to Excel or do you have to modify the Excel in real time?

[NISHITHA]

Hello @monsieurrahul

We will have to modify the Excel because the column status is not present previously

So the Bot would have to first check in Row 6 if Status Column is Present or not

[monsieurrahul (Rahul)]

The bot has to read the file to understand if the column is available in the Excel or not so, are you going to edit the Excel for every transaction?

[mayank.te (Mayank Tewari)]

For every queue item is the excel file separate or there is a common excel file ?

[NISHITHA]

@mayank.te it can be a different excel file for different item

We have the File Path as one of the Queue Item

[sanjay3 (Sanjay)]

Hi @NISHITHA

1. Read the Excel

2. Use If Condition - DataTable.Column.Contains(“Status”)
   Then - Use Add Data Column (For Adding it the Column)

3. Use For Each Loop
   If Condition - row(“User_Brand”).ToString = yourQueueItemUserBrand
   Then - row(“Status”) = “Status updation Completed”

Hope this Helps