Hi Team,
Please help me on below excel data to copy in to email data.
.
I am facing issue in merging rows which required as per above picture.
Verification.xlsx (13.3 KB)
No you cannot get merged cells while reading merged table to data table
Simple interview questions in uipath|Read excel Merged cells|Part#2 |#vajrangtalks|#uipath
Convert datatable to html.
https://youtu.be/iaIoRBv-u14
1 Like
Hi @Vajrang,
Thank you for your response.
Do you mean by converting datatable to html ,can we merge the cells?
Appreciate if you share the sample code you have.
No you cannot use merge cells while reading data
You will have empty cells for merged cells
2 Likes
Are you sure you want to move the table in Excel to the Outloook Body? Then there is a way.
Please wait a moment.
1 Like
Unfortunately, we donโt provide it in UiPath, so we have to use VBScript.
I will deliver a VBScript that you can use right away.
-
Excel Table to put in Outlook body
-
Call this code using the UiPath Invoke Script function, or run VBS itself.
-
Result
ExceltoOutlook.zip (477 Bytes)
If you have knowledge of programming, you can easily understand it by looking at the short VBS.
To run the script, only one Excel must be turned on.
In addition, all of the MS Office suites can be handled with VBScript and can also communicate with each other.
Therefore, when VBScript is executed, the actual mail will not be sent. VBScript can be modified to send immediately, or Body can be modified.
I will attach the following MSDN document. If you have any questions, ask anything.
2 Likes
1 Like
Hi @JIHUN ,
Where we have to give Excel path and sheet path?
1 Like
-
Excel Path.
Getobject handles objects that are already on.
If you want the path, change it like this:
However, as mentioned above, there should be only one Excel on (it is difficult to handle when more than one Excel is on).
In particular, run Taskkill / f / im excel.exe frequently. If you get a VBScript error, -
Sheet
When you specify a sheet, you can use the sheet name or index.
Please refer to the screenshot below.
2 Likes