Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to read Excel file with multiple sheet

Former Member
0 Kudos

Hi Group,

How to read Excel file from Application server which is having multiple sheets.

9 REPLIES 9

Former Member
0 Kudos

hi,

check this link:

/people/sap.user72/blog/2006/01/19/upload-data-from-multiple-worksheets-within-a-single-excel-file-into-internal-table-from-abap - 24k

Award points if helpful.

regards,

keerthi.

0 Kudos

Hi Kiran,

I need to read from Application Server.

former_member184569
Active Contributor
0 Kudos

Check these links

/people/sap.user72/blog/2006/01/19/upload-data-from-multiple-worksheets-within-a-single-excel-file-into-internal-table-from-abap

http://sap.ittoolbox.com/code/archives.asp?d=3027&a=s&i=10

Thanks,

Susmitha

rahulkavuri
Active Contributor
0 Kudos

Check the above 2 and award points if found helpful

Former Member
0 Kudos

Hi Group,

Can any body suggest how to read the Excel file which is existing on Application Server.

Former Member
0 Kudos

hi

chk this out

DATA:

dsn(20) TYPE C VALUE '/usr/test.xls',

rec(80) TYPE C.

OPEN DATASET dsn FOR INPUT IN TEXT MODE ENCODING DEFAULT.

IF sy-subrc <> 0.

EXIT.

ENDIF.

READ DATASET dsn INTO rec.

WHILE sy-subrc <> 0.

WRITE / rec. READ DATASET dsn INTO rec.

ENDWHILE.

CLOSE DATASET dsn.

0 Kudos

HI Pra,

Use these

<b> OPEN DATASET <NAME> FOR INPUT IN TEXT MODE.

READ DATASET <NAME) INTO <OUTPUT></b>

Regards,

Santosh

0 Kudos

Hi Ganesh,

In my Excel file I am having data in Multiple sheets,how to read these multiple sheets data

rahulkavuri
Active Contributor
0 Kudos

check this problem on this thread and also another thread referred before

Please refer to the answer from Micheal