ALSM_EXCEL_TO_INTERNAL_TABLE

[Former Member]

hiiiiii

usign the FM ALSM_EXCEL_TO_INTERNAL_TABLE

look at this piece of code ==>

types:

begin of t_file_upload,

INCLUDE structure ALSMEX_TABLINE, " Rows for Table with Excel Data

end of t_file_upload.

i have an error at compile time which is missing , after include

[Former Member]

hi

begin of t_file_upload,

INCLUDE structure ALSMEX_TABLINE<b> .</b> " Rows for Table with Excel Data

end of t_file_upload.

use fill stop.

rward poins if useful

karthik

[Former Member]

HI,

u have to do like this.

types:begin of t_file_upload.

INCLUDE structure ALSMEX_TABLINE. " Rows for Table with Excel Data

types:end of t_file_upload.

rgds,

bharat.

[Former Member]

Hi,

Use this.

types: begin of t_file_upload,

INCLUDE structure ALSMEX_TABLINE.

types: end of t_file_upload.

there should be a period after the include structure <struct> statment.

regards,

Santosh Thorat

[Former Member]

HI,

Declare like this....

TYPES:BEGIN OF t_file_upload.

INCLUDE structure ALSMEX_TABLINE.

TYPES:END OF t_file_upload.

Cheers,

Bujji

[Former Member]

hi

data: begin of t_file_upload.

INCLUDE structure ALSMEX_TABLINE. " Rows for Table with Excel Data

data: end of t_file_upload.

reward the points it it helps to u

Thanks

Siva Kumar

[Former Member]

It doesn't work

how do you write without using header line (occurs 0) can i remove the occur 0

DATA: BEGIN OF IT_FILE_UPLOAD OCCURS 0.

INCLUDE STRUCTURE ALSMEX_TABLINE. " Rows for Table with Excel Data

DATA: END OF IT_FILE_UPLOAD.

[jayanthi_jayaraman]

Hi,

Types : BEGIN OF IT_FILE_UPLOAD .

INCLUDE STRUCTURE ALSMEX_TABLINE. " Rows for Table with Excel Data

Types: END OF IT_FILE_UPLOAD.

data : itab type standard table of IT_FILE_UPLOAD ,

wa type IT_FILE_UPLOAD .

Here IT_FILE_UPLOAD is the user-defined type, itab is the internal table and wa is workarea.

[Former Member]

types:

rc like alsmex_tabline.

types:

rctab type table of rc.

or in one go

types: rctab type table of alsmex_tabline.

Both of these will give it without a header line, which is the preferred way these days.

[Former Member]

Hiiii

tnks a lot will award point?

I was just wondering, i read in the forum than this FM will take a maximun number of data . is it truc if yes how much it is really 9999 or can it be more

[Former Member]

Anybody can advise me on my question above

[Former Member]

If the row and column numbers are of type NUMC 4 (as they are in our system) it would be tricky to get a number higher than 9999 in them.

You might be able to get round it by doing multiple reads manipulating the i_begin_row but I've never had the need to try. It depends if the row and col returned are fixed or relative.

[Former Member]

In the FM the value is decalre like this i don't see any numc

""Lokale Schnittstelle:

*" IMPORTING

*" VALUE(FILENAME) LIKE RLGRAP-FILENAME

*" VALUE(I_BEGIN_COL) TYPE I

*" VALUE(I_BEGIN_ROW) TYPE I

*" VALUE(I_END_COL) TYPE I

*" VALUE(I_END_ROW) TYPE I

*" TABLES

*" INTERN STRUCTURE ALSMEX_TABLINE

*" EXCEPTIONS

*" INCONSISTENT_PARAMETERS

*" UPLOAD_OLE