Hi all
I have a default template file of. Xlsm …i have to copy data from an excel file into that default template into desired columns
1 Like
Yah thats possible
–first we can get the data from that xlsm file either with READ RANGE or READ CELL activity
–if READ RANGE we will be getting the output with a variable of type datatbale named dt and then use FOR EACH ROW LOOP and mention dt as input
–inside the loop we are going to use EXCEL APPLICTION SCOPE and mention the file path of the default template excel
–inside this scope use WRITE CELL ACTIVITY where mention the cell position of each field whose value can be passed as row(“yourcolumnname”).ToString
or
if its READ CELL activity we need to use n number of READ CELL and store them in appropriate string variables inside the first excel application scope
–then use another excel application scope and pass the file path of default template and use WRITE CELL Activity and mention the input string variables and the exact cell position
kindly try this and let know for any queries or clarification
Cheers @prasssaadd
Hi @Palaniyappan
Thanks for replying
My doubt I’d we have to use
For each loop or for each data row act
Ya sure
@Palaniyappan
i have to copy the excel file data to this template under the desired column names like license number ,product code …etc…
THIRU_NANI
ushu
ppr
muhammedyuzuak
Rahul_Unnikrishnan
Nithinkrishna
jack.chan
Gokul_Jayakumar
Povilas_Jonikas
nilesh.mahajan