How to read this kind of excel file in uipath and add columns?

akashdeep.xlsx (10.0 KB)

The Excel file format is diff i need to add the col at end of the table

Could you elaborate?

i hope u have seen the excel at j9 i need to insert the qty col whose value will be 1 for all how to do that?

Sure! I hope you have seen the documentation links i sent :wink:

Use the Read Range activity (Range: A9:I27 in this case). Then use Add Data Column on the resulting DataTable. You can give default value of 1. Finally, use Write Range Activity to write back to the excel file.

Still facing the issue i want to read that whole excel and add the qty col at the end

Ok, I’m not getting it then. Hope someone else can help you.

Good luck!