how to import excel file ?

[atuldalvi]

how to import excel file ?

 

[jdpjamesp]

You're going to have to provide more information as to what you want to do. The simplest solution is to save the excel file as a csv and import that into variables or a temp-table and process. More complicated is to set up COM objects to access the Excel sheet directly. But like i say, your question is like asking 'how long is a piece of string?'.

 

[atuldalvi]

i just simply want to import excel data into a variable.

 

[taqvia]

Use COM HANDLE to import from excel file

Stil the easiest way will be to import as csv file

Arshad

 

[Stefan]

i just simply want to import excel data into a variable.

To import excel data into a variable you can do the following :

DEFINE VARIABLE mm AS MEMPTR.


COPY-LOB FROM FILE "c:/myexcelsheet.xlsx" TO mm.


MESSAGE GET-SIZE(mm) VIEW-AS ALERT-BOX.

If you have other requirements, you will need to be more specific.