Hello,
i need help in the below.
how i can migrate the data in excel row by row to a notepad template i already have ?
as example, i have excel with 10 records and include 4 columns ( A1,B1,C1,D1) and i have notepad write as :
name < A1 >,position <B1> , title<C1>,age<D1>
what i need to fill the notepad template and create one or 10 notepads taking for each file the data from excel row by row and fill each row data in its specific field.result will be as:
notepad1.txt include ( name < A1>,position<B1> , title<C1>,age<D1> )
notepad2.txt include ( name < A2>,position <B2>, title<C2>,age<D2> )
notepad3.txt include ( name < A3>,position <B3>, title<C3>,age<D3> )
notepad4.txt include ( name < A4>,position <B4>, title<C4>,age <D4>
ETC.....
notepad10.txt include ( name < A10>,position<B10> , title<C10>,age <D10>
many thanks in advance,
i need help in the below.
how i can migrate the data in excel row by row to a notepad template i already have ?
as example, i have excel with 10 records and include 4 columns ( A1,B1,C1,D1) and i have notepad write as :
name < A1 >,position <B1> , title<C1>,age<D1>
what i need to fill the notepad template and create one or 10 notepads taking for each file the data from excel row by row and fill each row data in its specific field.result will be as:
notepad1.txt include ( name < A1>,position<B1> , title<C1>,age<D1> )
notepad2.txt include ( name < A2>,position <B2>, title<C2>,age<D2> )
notepad3.txt include ( name < A3>,position <B3>, title<C3>,age<D3> )
notepad4.txt include ( name < A4>,position <B4>, title<C4>,age <D4>
ETC.....
notepad10.txt include ( name < A10>,position<B10> , title<C10>,age <D10>
many thanks in advance,