dear sir i add the extracted data in built data table>add row > extracted data in it
can you take a solution for me thank in advance
It would be better if you tell more about your task and sending some sample input and Expected output
Also if possible add some screenshots
Regards
Sudharsan
Hi,@Shubham_Bidwai
First step-use bulid data table activity take it the variable (dt1)
Second step - assign create RHS (dt1.newrow) take it the variable(dt1_newrow)
Third step -inside loop take one assign and put
LHS(dt1_newrow(columnname)=RHS(which you exracted data in string format)
Cheers!
hi i did table extraction and send that tabular data through gmail but in gmail header of table can not be shown they automatically take first row of extracted data as a header that why i used built data table>add row > use extracted data but extracted data can not shown on mail
but i have data table from table extraction
Try this way
Right after Extracting the data write them with headers in the tempExcel.xlsx
use this activity from this package and give the workbook path(Should be full path like C:\Users\Sample.…) and give your Sheet Name and store them in a string
If you need the borders check on Border Required
The result will be as string so you can add this variable directly to the body of the Send SMTP
Note : This package can be found in the manage package only if you are using the Windows - legacy compatibility projects
Regards
Sudharsan
