Скачать или смотреть 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