Hai Team,
Can anyone help with the answer for below questions.
how to handle the large size excel files in UiPath?
how to extract the tabular data from email?
how to send tabular data through email?
Hi @Gayathri_Mk
-
To handle excels with large data you can use VB Macros as it will take much less time to execute.
-
To extract table from email Use Get outlook Mail Mesaages-> Use For Each to iterate through output of Get outlook Mail Messages-> Save the email attachment in .eml format-> Pass the same save email attachment in Start Process-> Use Extract Table Data and you can extract the table from email
-
You can use Create HTML Content activity and in code edito you will have Map Data Values there you can pass a datatable variable and send a table through email.
Hope you understand!!
Regards
Hi Team,
During one of my interviews, I encountered a question about the challenges we might face while handling large Excel data and how to handle it.
1 Like
While handling large Excel data with excel activities, the excel application will not respond and crash at the middle of the execution and the bot will throw System Exception. While using it will take much time to complete the excel automation.
To handle large Excel data we use VBA macros or Excel as database.
Hope you understand!!
Regards
Hi @Gayathri_Mk
you can use the below marketplace component to convert data table to html content and send in an email: