UiPath | Transpose DataTable | Transpose Collection with VB.Net Code | Transpose Excel Sheet Table

preview_player
Показать описание
#rpa #uipath #collectionmanipulation
👉 𝐄𝐧𝐠𝐥𝐢𝐬𝐡
● This video is about transposing a table from an Excel file with a VB.Net code in UiPath.

👉 𝐆𝐞𝐫𝐦𝐚𝐧
● In diesem Video geht es darum, eine Tabelle aus einer Excel Datei mit einem VB.Net Code in UiPath zu transponieren.

📝 𝐏𝐫𝐨𝐜𝐞𝐝𝐮𝐫𝐞
➊ Add Read Range activity
➋ Set the path and create a variable for the input table
➌ Create another variable for the output table
➍ Add an Invoke Code activity
➎ Create the arguments inCollection and outCollection
➏ Write the code from the video
➐ Add Write Range activity
➑ Set the path and the name of the sheet and the datatable variable
➒ Run the code to see the result

✍ 𝗞𝗲𝘆 𝗪𝗼𝗿𝗱𝘀
→ UiPath
→ UiPath Automation
→ UiPath Activity
→ Transpose DataTable
→ Transpose Collection
→ Transpose DataTable with VB.Net Code
→ Transpose Collection with VB.Net Code
→ Transpose Excel Sheet Table
→ Excel Manipulation
→ Collection Manipulation

Рекомендации по теме
Комментарии
Автор

hey, sir if i wanted the opposite then what should I do?

atishayshrivastava
Автор

Hi, could you help us in writing a script transpose a table with rows and columns undefined. I mean how to make it dynamic

LearnToTradeGood
welcome to shbcf.ru