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

neramit

I want to copy rows in excel and insert to next rows in excel

i don't know about coding

Everyone who know please tell me

thank you

#-o

kriki

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

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

kriki

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