UiPath | Loop through Rows and Columns in Excel | Loop Excel/DataTable rows and columns in UiPath
#rpa #uipath #excel
👉 𝐄𝐧𝐠𝐥𝐢𝐬𝐡
● This video is about reading the rows and columns of an Excel file with a loop.
👉 𝐆𝐞𝐫𝐦𝐚𝐧
● In diesem Video geht es darum, die Zeilen und Spalten einer Excel Datei mit einer Schleife auszulesen.
🌟 Attention
Please make sure you have this package in your UiPath Studio:
Microsoft.Office.Interop.Excel
🌟 𝗖𝗼𝗱𝗲
● Using Column Name
✔ row.item("ID").ToString
✔ row.item("Name").ToString
● Using Column Index
✔ row.item(0).ToString
✔ row.item(1).ToString
📝 𝐏𝐫𝐨𝐜𝐞𝐝𝐮𝐫𝐞
➊ Add Read Range activity
➋ Add the Excel Path and Create an output variable from type: DataTable
➌ Add For Each Row activity
➍ Set the DataTable variable
➎ Add WriteLine activity and set the code in it
➏ Add another WriteLine activity and set the code in it
➐ Run the file to see the result
✍ 𝗞𝗲𝘆 𝗪𝗼𝗿𝗱𝘀
→ UiPath
→ UiPath Automation
→ UiPath Activity
→ Excel Automation
→ Loop Excel rows
→ Loop Excel Columns
→ Loop Through Excel Rows
→ Loop Through Excel Columns
→ Microsoft.Office.Interop.Excel
👍 / @actautomate