How to copy rows in excel by C\AL Code?

I see 2 ways:
1) Go in excel. Record a new macro. Do the copying of a row manually. Stop the macro. Have a look at the code. Go in Navision and with automation, you must use the same commands.

2) Table 370:"Excel Buffer" contains functions to read info from excel and to write in excel. So read the cells you want from excel into the (temp)table, create a second (temp)table and fill that up with the coordinates to where the data has to go. Then launch the function that actually writes it to excel.

neramit wrote:

thank you for your suggest

but i want to know how to write code

Ex:
Xlsht.Rows("18:18").Copy

How to C\AL code ?

Please tell me
thank you

I don't know exactly how, but search the forum, you will find some information.
Maybe this can give you a start :http://www.mibuso.com/forum/viewtopic.php?t=213