I want to create id card for multiple employees, i have record of employee in excel and i make id card format in MS word like below
can anyone plz tell me how i do this ex. in id card after name type employee name then enter ID no likewise
- Use Read Text activity inside Word Application Scope activity to read the data from word file.
- And then pass the data to Generate DataTable activity to convert string to DataTable.
- Finally use Write Range activity and pass above output DataTable to write into Excel file.
Hope it helps
Try below steps:
- Create one word template file. Write some dummy text in place of text you want to update it from Excel file.
- Next use Read Range activity to read the text Excel file and it will give output as DataTable.
- Then use For Each Row activity to iterate DataTable.a. Use Copy File activity to copy word template to some location.b. Then use Replace Text activity and replace that dummy text with Excel file data and this activity should be inside Word Application Scope activity.
I did that as screenshot in for each data table
but for second time it only save as pdf not replace record which is in excel
see the file saves with different name but record is same for all pdf shown in screenshot where i have 10 records in excel file and i want to replace all records one by one
Have you tried it? Uncheck the Auto save option
If it is not working.Place the Word Application Scope in For each row in datatable activity
can u tell me how to replace picture using below activity
how should i use it for multiple picture for id card generation
can u tell me I have multiple images in folder & I want to replace img as per id card details using for each data table then how i do it
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
ashokkarale
sharazkm32
sonaliaggarwal47
LamaX